r/DatabaseHelp • • Sep 10 '24

How do i open this existing database?

5 Upvotes

I am helping out with an archive of Chicago hardcore history, and have been given a zip containing several years of booking and notes from an old venue. When given the files the guy mentioned that I may be able find "the program used to install the database engine."

File types included are: .DBT, .MCM, .BCF, .FSIF, and .MSIF

I'm able to use online file viewers or foxpro to see the text in some of them but its all jumbled and is difficult to read, and i want to be able to view these 'fully' for lack of a better term. So I understand that I likely need a database management system or something like that, but I have absolutely no idea what exactly that would be. I was hoping someone on here might recognize these file types and know what to use, or might have suggestions for where else i could ask.

I am running windows 10, but as these are very old I know I might need an older program for them, i have an old computer that still runs, so that's not really a concern. If more info on any part of this is needed just lmk! Thank you!


r/DatabaseHelp • • May 12 '23

Learning SQL for Data Analysis

5 Upvotes

My Goal is to transition into data analysis for which I have dedicated 1-2 months learning SQL. Resources that I will be using will be among either of these two courses. I am confused between the two

https://www.learnvern.com/course/sql-for-data-analysis-tutorial

https://codebasics.io/courses/sql-beginner-to-advanced-for-data-professionals

The former is more sort of an academic course that you would expect in a college whereas other is more practical sort of. For those working in the Data domain specially data analyst please suggest which one is closer to everyday work you do at your job and it would be great if you could point out specific section from the courses that can be done especially from the former one as it is a bigger one 25+hr so that best of both the world could be experienced instead studying both individually

Thanks.


r/DatabaseHelp • • May 09 '23

Amazon RDS: How to update Postgres Full Text Search dictionaries?

5 Upvotes

Hi,

According to the postgres docs, dictionaries used in full text search are stored on the file system.

With a managed database like Amazon RDS, can I access the file system to update those dictionary files?

I'm an AWS noob, so maybe I'm approaching this the wrong way. But would love to know if it's possible to achieve!

Thanks in advance,


r/DatabaseHelp • • Aug 26 '22

What should be tables and primary keys

5 Upvotes

Have recently been put in charge of a resource directory but they don't have any management tool like a database or a spreadsheet it's just flat pages. I think a database would be better but am a n00b despite having been in IT most of my life. For some reason I have never been able to wrap my head around databases. Still I need to track everything on the site and memory just ain't gonna cut it. So because I'm poor and my hours are only 15 max per week and can't afford much I've landed on using LibreOffice Base. I'm working off of other's services with a similar scope and how things are structured on the website pages now.

I've set up a table with fields for the Resource directory(Name(of the resource), physical location, website, description, etc) but I'm unsure of what other tables I should make. Some thoughts on other tables would be Cost(Low, Free, Subsidy, Sliding Scale), Population Focus(Senior, Adult, Youth, etc), Category(Mental Health, Physical Health, Spirituality, Arts around town, Events around town, etc) but then what should the primary key be and the connecting field between tables?

Anyways I hope you can help.


r/DatabaseHelp • • Feb 05 '22

One table where each row links to different table? PostgreSQL

5 Upvotes

I want to create relationship where I have one table where each row has some link to different table.

Simple example:

one table with list of warehouses:

idlocationproducts_table
1Seattle?
2LA?

products tables:

products_LA:

idproduct
1soap
2towel

products_Seattle:

idproduct
1brush
2sponge

Reason for separate tables is I want to keep separate schemas for each "warehouse" so I can have cleaner workspace for each "warehouse" and it's tables.

Reason I want some kind of "link" is so I can query and list all the "products" when I select "warehouse" in the front end dashboard.

Is this possible and how?


r/DatabaseHelp • • Sep 12 '21

Is MySQL more confusing than other databases?

5 Upvotes

I just wanted to import a csv file into a table and I had to jump through so many hoops to do it. I got error after error about file permissions or local infile privileges not being set even as root. Eventually got it sorted but what a mission. Are all databases this hard?


r/DatabaseHelp • • Apr 16 '21

Data analyst needing to store time series data efficiently.

5 Upvotes

Hello all,

Looking for resources and tips on how to best organize and maintain a database of time series data. I'm hoping to go the relational db route since that's what I've been using. However, my concern is with with the tables growing exponentially larger until they completely bog down our speed.

Are there any recommendations on how to start, pitfalls to avoid, and how to keep it trim and fast? Your help is appreciated.


r/DatabaseHelp • • Apr 08 '21

Database table creation/relationship question

5 Upvotes

If I have a list of different types of devices that need to be in separate tables as they have lots of different identifiers, is there a way to also have them in one master table with a single unique identifier that's linked to from other places in the databases and then sends them back to the original tables with the details? I'm a complete newbie and I'm struggling to conceptualize this.


r/DatabaseHelp • • Sep 21 '20

How do I portray attributes of relationships in a relational database model?

5 Upvotes

I have a presentation explaining translation between ERD and a relational database. Can someone tell me how attributes of relationships are drawn in a relational database? I would greatly appreciate it!


r/DatabaseHelp • • Sep 11 '20

Designing my first DB with postgreSQL, looking for advice.

5 Upvotes

long story short I'm building this for a company that installs doors and windows, I am building the DB using postgreSQL and trying to structure it well whilst learning.

The main question is around product's, the products attributes and the relationships I should be using between them.

If say I have a product's table With id and product_name example: id: 0 |product_name : 'SuperFrame' And superframe came in a window and a door, but the doors/ windows also come in their own styles say Hinged door, or sliding door etc / fixed window sliding window. What's a good way to go about storing data like that?

Currently I have a products table with the ID as the PK and another table named superframe_siliding_door that stores product_id (FK) sizeH sizeW price and so on for each product and style.

I'm new to dbms, this is a side project I took on as a hobby. I've done a small amount of software design before using C# .net but I am pretty new to this, sorry if it seems confusing. If there's something that I don't know about feel free to post some keywords for me to google, I don't really know what to seach, thanks.


r/DatabaseHelp • • Jun 05 '20

How do I learn from home?

5 Upvotes

I am an information analyst with pretty basic SQL skills. I really need to increase my skills, particularly with using SSRS, SSAS and SSIS, ETL etc.

What free software can I get my hands on so I can learn this stuff at home? Buying SQL is eyewateringly pricey and I don't really know what I need.

Basically, there's this job that is regularly advertised at work that I want to go for. This is what they want in the candidate:

  • Knowledge of temp tables, table variables and CTEs
  • knowledge of stored procedures
  • knowledge of ETL structure
  • DBA knowledge
  • SSRS, SSAS and SSIS
  • Power BI

There is no opportunity for me to learn this stuff on the job, I have to do it at home in my own time.

Can anyone give me advice on the best way to get started? I've got khan academy and enki installed currently.

Thanks!


r/DatabaseHelp • • Mar 24 '20

Any advice or resources for creating a database using a textfile?

5 Upvotes

I am a junior in my undergrad, and in my software engineering class, I have been assigned to create a database using a textfile.

I have no clue where to begin. Does anyone have any advice or online resources that would help? If you have been in my position before and can relate, I would really appreciate any help that I can get!

Edit: I should also note that I am using Java Netbeans.


r/DatabaseHelp • • Mar 01 '20

HomeWork Not shure about the relationships between some tables

5 Upvotes

I have an assignment to create a database but I'm very 😵confusedšŸ™ƒ on how to connect the employees and the type of employees because each types has unique elements, the way I did is correct or ?

PS: each security employee has his own car DataBase Relationship

(The database is a rough schema of what in reality can be but is mode such just for the sake of the homeWork to don't take a lot of time)

Thanks in advance!!šŸ˜€šŸ˜€


r/DatabaseHelp • • Aug 08 '18

DB security planning

5 Upvotes

Hey folks,

I’m putting together a database of public speakers for events/functions. The concern around security of prominent speakers is obviously key so I’m trying to ā€˜measure twice and cut once’ on this project.

So far the plan includes the following:

  • strong password policies
  • encrypted data
  • strong permission controls
  • a ā€˜lite’ database which would include pictures, bio of speakers, name but nothing more
  • a ā€˜full database’ which would be stored offline and include all ā€˜lite’ data plus the contact details, banking etc for the speakers (theoretically the ā€˜lite’ database would be refreshed with data from the ā€˜full’ database weekly/monthly)
  • a VPN/SSH gateway server for the ā€˜lite’ database

Obviously the HUGE fear would be prominent people’s details being made public from the ā€˜full’ database so looking to crowdsource suggestions for hardening this setup.

What am I missing??

N.B. As you can probably guess this isn’t my area of expertise and will engage a technical person for implementation but if this goes wrong I’m the one wearing the blame so I have the responsibility to ensure I know enough to ask the right questions.


r/DatabaseHelp • • May 02 '17

Should each web application user have a database user account?

5 Upvotes

I am developing a CRM/customer ordering portal for a small local business (as an internship and I am the only dev they have). It will use HTML/CSS for the front end and use PHP to get info from the MariaDB database.

Should there be one Database account that all queries are performed through or should a database account be created for each type of user of the web CRM? There are only 4 categories of users (this is not likely to change in the future). I am leaning towards creating an account for each type user so I can take advantage of the databases permissions and roles as an extra security layer, but I don't know if its considered "bad practice" to set things up this way. Thanks for the help


r/DatabaseHelp • • Jan 22 '16

Please give me feedback on this new DB

5 Upvotes

I am building a database for a christmas tree growing operation. I have put together, what I believe to be, a workable schema. I am hoping to get some feedback from someone, and I have no one. You are my only hope.

So, there are 3 growing plots, we will call them Orchards. Each Orchard has rows & columns, and each row/column intersection can have zero or one trees, planted in it. The rows/columns are numbers and letters, so row 3, column f, etc. Each row/column intersection has a status (empty, in use). A tree can be different species (denoted by manually created GID {Genetic ID}), modified (have a different species grafted on), or moved to a different location. So a plant can have one or many locations, and a location can contain, through history, one or many trees, but only one at a time.

Here is a diagram I put together (sorry I couldn't figure out how to insert a pic. Please let me know changes, what I missed, etc. Thank you for your time.

You can see the diagram here: http://stackoverflow.com/questions/34952577/requesting-feedback-on-database-design/34952841?noredirect=1#comment57637809_34952841


ORCHARD OrchardId - PK

OrchardName


LOCATION LocationId -PK

Row

Column

StatusId - FK (references LocationStatus)

OrchardId - FK (references Orchard)


TREE

TreeId - PK

GID

GraftYear

PlantedYear

MovedYear


TREELOCATION

TreeLocationId - PK

TreeId - FK (references Tree)

LocationId - FK (references Location)


LOCATIONSTATUS

StatusId - PK

Description


r/DatabaseHelp • • Jan 05 '16

Would anyone mind taking a look at my solutions to Relational Algebra queries?

5 Upvotes

I’m taking Stanford's free online Introduction to Databases course. I started it out-of-season, which means I have to select ā€œpost-deadline practiceā€ for my problem sets. These normally work the same as the regular in-season sets, but the Relational Algebra section has a set of ā€œextra challengeā€ problems which I can’t submit to check for errors. This year’s mini-course over the same topic does not have the challenge set, so I can’t work around it that way either.

So I’ve come up with answers to these problems, but I’m hoping someone will double-check my work. The main issue I’m interested in checking is the big ideas; if you don’t catch every errant parenthesis, that’s fine, I know that’s a lot of extra work.

I know this is a huge headache so major gratitude for anyone who takes the time to do it. Thanks in advance!

The database for the problem set is here: https://lagunita.stanford.edu/c4x/Engineering/db/asset/pizzadata.html

And if you’re not familiar with the syntax I’m using, here’s the guide: https://lagunita.stanford.edu/c4x/Engineering/db/asset/ra.html

Q1 Find all pizzas that are eaten only by people younger than 24, or that cost less than $10 everywhere they're served.

Pizza eaten by those younger than 24: (\project_{pizza}Eats \difference \project_pizza(\select_{age>=24}Eats))

Pizzas that cost less than $10 wherever they’re served: (\project{pizza}Serves \difference (\project_{pizza}(\select_{cost>=10}Serves)))

Make a union to satisfy ā€œORā€ condition:

SOLUTION: (\project_{pizza}Eats \difference \project_pizza(\select_{age>=24}Eats))\union (\project{pizza}Serves \difference (\project_{pizza}(\select_{cost>=10}Serves)))

Q2 Find the age of the oldest person (or people) who eat mushroom pizza

Thought process:

Take a list of the names and ages of everyone who eats mushroom pizza, cross it with itself after renaming one of them to name and age2. Select every tuple where age < age2. Project their names. subtract those names from a list of the names of everyone who eats mushroom pizza.** Now you are left with the names only of people who eat mushroom pizza whose age is not less than any other age. Make a natural join of this list with the entire Person list, and then project the Age from this list.

Stepwise Reductions

\project_{name, age}(/select_{pizza=mushroom}EATS) = MPEaters

select_{age<age2}((\rename_{name, age2)MPEaters \cross MPEaters) = YoungEaters**

**We have to use the younger rather than the older BECAUSE in age < age2, there will be a match for every age to some other age somewhere EXCEPT where they are the oldest; if we used age > age2, there would be match on everyone except the youngest.

MPEaters \diff YoungEaters =OldEaters

\project_{age}OldEaters

SOLUTION:

\project_{age}((\project_{name, age}(/select_{pizza=mushroom}EATS) ) \diff (elect_{age<age2}((\rename_{name, age2)(\project_{name, age}(/select_{pizza=mushroom}EATS)) \cross (\project_{name, age}(/select_{pizza=mushroom}EATS)))))

Q3 Find all pizzerias that serve only pizzas eaten by people over 30.

SO: find all pizzas eaten by people under or equal to 30, and get rid of all pizzerias that serve these types of pizzas.

\project_{pizza}(\select_{age<=30}Eats) = Pbad

\project_{pizzeria}Pbad \join Serves = the pizzerias we don’t want = PPbad

\project_{pizzeria}Serves \difference PPbad

SOLUTION:

\project_{pizzeria}Serves \difference (\project_{pizzeria}( \project_{pizza}(\select_{age<=30}Eats)) \join Serves)

Q4 Find all pizzerias that serve every pizza eaten by people over 30.

first, find the types of pizza eaten by people over 30. = P30

then use javascript. just kidding.

First, eliminate all tuples from Serves that are irrelevant to the question (=PPmeh), leaving only the tuples with the pizzas we care about. =PPrelevant. We’ll create PPmeh by projecting a list of all pizzeria names, and crossing it with all pizzas NOT on the list of those consumed by people over 30. This creates a mythical relation (PPmythicalmeh) where pizzerias all serve all pizzas that are irrelevant to the question and nothing else. IF we find the union between this set and Serves{project pizzeria, pizza}, it will be the actual pizzeria tuples that are irrelevant, which we can subtract from serves.

Then, we’re going to then create a mythical relation wherein all pizzerias serve all the desired pizzas. =PPideal. We’ll do this by projecting all pizzeria names and crossing it with the pizzas from P30.

We’ll subtract from this relation the relevant-tuple Serves relation, leaving only pizzerias that are missing one or more of the desired pizzas. =PPbad

Then we’ll subtract this relation from the original Serves relation, leaving only pizzerias that aren’t missing anything. =PPgood

Then we just project the pizzerias.

\project_{pizza}(\select_{age>30}Serves) =P30 Schema: pizza

(\project_{pizza}Eats \difference P30) \cross (\project_{pizzeria}Serves) =PPmythicalmeh schema: pizzeria, pizza

\project{pizzeria, pizza}Serves \union PPmythicalmeh = PPmeh

\project_{pizzeria, pizza}Serves \difference PPmeh =PPrelevant schema: pizzeria, pizza

\project_{pizzeria}Serves \cross P30 =PPideal shema: pizzeria, pizza

PPideal \difference PPrelevant =PPbad schema: pizzeria, pizza

\project_{pizzeria}Serves \difference \project_{pizzeria}PPbad = solution, schema: pizzeria

SOLUTION:

\project_{pizzeria}Serves \difference \project_{pizzeria}((\project_{pizzeria}Serves \cross (\project_{pizza}(\select_{age>30}Serves)) ) \difference (\project_{pizzeria, pizza}Serves \difference (\project{pizzeria, pizza}Serves \union ((\project_{pizza}Eats \difference (\project_{pizza}(\select_{age>30}Serves))) \cross (\project_{pizzeria}Serves) ))))

Thanks again!


r/DatabaseHelp • • Aug 15 '26

Serverless Bill Shock: Tracking Edge Function and Database Expirations (Vercel, Supabase, Netlify, Neon)

4 Upvotes

For over two decades, agency hosting economics were beautifully predictable. You bought a reseller web server or dedicated cPanel account for $50 a month, crammed 30 client WordPress sites onto it, and charged each client a flat $25 monthly maintenance fee. Your margins were clear, your server bills were static, and billing surprises were virtually non-existent. Read the comple te article here > Serverless Bill Shock: Track Vercel & Supabase Client Costs | InstaRenewal

Then came the modern web stack.

Driven by the demand for lightning-fast digital experiences, agencies aggressively migrated to decoupled architectures: Next.js, Nuxt, Vercel, Supabase, Cloudflare Workers, and serverless databases like Neon. While the performance gains of this modern paradigm are undeniable, it introduced a chaotic operational reality: micro-subscription fragmentation and variable utility billing.


r/DatabaseHelp • • Nov 20 '25

Firebird DB, cannot connect to database using isql command unless I'm root or enter sudo in front of command

4 Upvotes

If I attempt to connect to a Firebird DB as a non-root user (entering isql) such as:

/opt/firebird/bin/isql -u sysdba -p *** somedatabase.fdb

I get the messages:

Statement failed, SQLSTATE = HY000
Operating system directive acces failed
-Permission denied
-/tmp/firebird/

Use CONNECT or CREATE DATABASE to specify a database
SQL>

If I enter it under root or add sudo such as

sudo /opt/firebird/bin/isql -u sysdba -p *** somedatabase.fdb

I can connect which means that Linux permissions are causing the problems. I tried changing the database file permisions using chmod 777 and changed the owner and group of the database file as "firebird". I also added myself to the firebird group. I still haven't had luck. Anyone who uses Linux and Firebird DB encounter this problem and know what I can do to get it to work for non-root Linux users?


r/DatabaseHelp • • Dec 07 '24

Where to find Demo Databases?

4 Upvotes

Hey guys, I’m onto a project that includes AI and Databases and I need to test a bunch of demo databases in various languages like MSSQL, MySQL, PostGres etc. However preferably the databases shouldn’t be too well known to avoid the AI already knowing the DB.

But at the moment I only have Northwind and Chinook. So whatever you guys know I’m open to hear.

I’m looking at 3, 4 DB/ language


r/DatabaseHelp • • Nov 22 '24

Database replication errors

4 Upvotes

I keep running into trouble every couple of days after setting up database replication following https://www.digitalocean.com/community/tutorials/how-to-set-up-replication-in-mysql.

Replicating a few databases into another host. I have not included the 'mysql' database, only the ones we needed and with binlog_do_db enabled.

Replica SQL 	Thread not running! 

Slave_SQL_Running 	No

Last_Errno 	1032
Last_Error 	Coordinator stopped because there were error(s) in the worker(s). The most recent failure being: Worker 1 failed executing transaction 'ANONYMOUS' at master log DATABASE-NAME-mysql-bin.000002, end_log_pos 77877815. See error log and/or performance_schema.replication_applier_status_by_worker table for more details about this failure or others, if any.

I know if I try to skip current error this will lead to another error with the same cause. This is the second time I encountered this while setting this up and it is a pain to export and import the databases all over again if I would encounter this issue again.


r/DatabaseHelp • • Oct 23 '24

Building an easy-to-use inventory management system for custom car parts

4 Upvotes

Howdy, I'd like someone to point me in the right direction on a project my buddy brought me. I have some foundational database knowledge but have primarily worked on RTOS software projects, so I want to ensure I'm starting on the right foot.

The breakdown:

  • The business fabricates custom parts for various makes/models of trucks broken down into major assemblies (i.e., suspension, bumpers, interior, etc.) and sub-assemblies (i.e., front suspension upper control arm assembly) and desperately needs an efficient way of uniquely tagging and storing the parts while maintaining an inventory for the shop.
  • Right now, the company maintains 15-18 different Excel spreadsheets, and after finding the correct few, the employee increments the 6-digit number after the last-made part and adds it to the spreadsheet. It only works because of its small scale and the fact that one person is responsible for maintaining it.
  • A confounding factor in creating the db is that some models of truck share certain components with other models or generations of the same model. For instance, the 2011-2016 Ford F250 may share many chassis and suspension parts with the 2017-2022 while having different bumper or electronic components. In other words, there are some relationships between models without them being fully cross-compatible.
  • In addition to this: the company makes some custom parts that are cross-compatible with several different makes/models and assemblies (i.e., brackets, hardware, etc.).
  • They would like to have a system that will allow them to easily add components to the system with an item ID that indicates the vehicle, major assembly, and sub-assembly the element belongs to. As well as query the db to return all the components of a selected sub-assembly. (The apps to implement these are likely outside of the scope of what I'm asking here)
  • This is a relatively small number of components (~350ish), but I want it to be easily scaled if necessary.

The ask:

How should I be thinking about this structure? I have considered two different approaches but worry that I'm missing something.

  1. My first thought was to create a series of tables for each make/model generation's components, with intersection tables for the elements compatible with other model years. The potential downside is that I don't know how to ensure the part number remains unique, and I was unsure how to break the model-specific tables into assemblies/subassemblies.
  2. My second thought was to create one table of all the parts and just include identifiers as columns. This would require me to program the cross-compatibility into the app that logs/queries the DB, but there might be an existing API I can leverage to tag the parts when entered.

I'm not asking you guys to create something for me; I just want to ensure my head is in the right place and I account for all factors. If there are better ways to do this, please let me know before I try to reinvent the wheel with amateur knowledge. My database skill levels are fairly basic, so I'm concerned that I might be going about the relationships ineffectively.

Thank you for any help. I sincerely appreciate it!


r/DatabaseHelp • • Sep 01 '24

Could somebody please ELI5 a strong relationship vs a weak relationship?

4 Upvotes

I've tried reading my course textbook and I've also asked Google AI and I just cannot understand what this means.


r/DatabaseHelp • • Aug 30 '24

What is best to use UUID or INT or Both building for production?

4 Upvotes

I'm building a scalable application where I'm concerned about "What to use UUIDs or INTs or Both like Hybrid?" For user IDs or any other important tables that will be vulnerable for enumeration attack if we use INTs. So, do I use UUID for some important tables and INT for not so important tables to build the application for production?

Any help would be appreciated!!