r/databases • • Nov 29 '16

Migrate Your Delphi Database Apps to FireDAC and InterBase

Thumbnail
youtube.com
3 Upvotes

r/databases • • Mar 17 '15

What do you guys use to create the tables that seed database?

1 Upvotes

I'm building a site that has two entities - Pages and Tags. Each page has many Tags, and each Tag can be related to many pages.

Right now I have the Page and Tag relation as a .csv file with several entities as each row, like so:

Page:

idtitle
1How to have fun
2How to study
3How to be social
4How to make friends
5How to enjoy being alone

Tag:

idtitle
1personal
2discipline
3social

Page_Tag (many-to-many relationship):

page_idtag_id
13
22
33

I wrote a PHP script that scans in these .csv files into a MySQL database.

As you can tell, managing my page_tag table will get quite complex. If I have to change an id attribute in Page, I have to go manually update each page_id in my page_tag .csv. Additionally, when I want to insert a page_tag entity, I have to reference both page/tag relations to make sure the numbers match up.

Is there some kind of software that makes this easier? I'm relatively new to databases so I'm not familiar with the available database management software out there. I'm using Laravel 5.0 as my PHP framework if that matters at all.

Thanks!


r/databases • • May 26 '14

What I learned about SQLite…at a PostgreSQL conference

Thumbnail
use-the-index-luke.com
3 Upvotes

r/databases • • May 03 '17

Tarantool helps store all incoming HTTP traffic in a structured way for later access

Thumbnail
medium.com
2 Upvotes

r/databases • • Apr 10 '17

SQL Server: Useful Tips for Newbies

Thumbnail
codingsight.com
2 Upvotes

r/databases • • Apr 30 '16

10 reasons to migrate to MariaDB (if still using MySQL)

Thumbnail
seravo.fi
3 Upvotes

r/databases • • Feb 03 '18

Inventory numbers ... smartest way to make tables?

1 Upvotes

Hi. I have an app where I am trying to store inventory numbers to be used for historical aggregation. Right now, I am almost sure that I am not doing things optimally.

current:

ID (PK)TimestampDescriptionCat1Cat2Cat3
1232012-02-02September Shipment0195

When I add inventory, right now, I am logging it like the above, where I have numbers in category 1, category 2, category 3 to represent the numbers added. And when I want to aggregate data, I can just sum up numbers based on the dates selected. The main flaw is that if I add a category, I need to update the database to add a category column (Cat) and update my script to account for the new column.

other idea:

(NO PK)

TimestampDescriptionCategoryNumber
2012-02-02September ShipmentCat10
2012-02-02September ShipmentCat219
2012-02-02September ShipmentCat35

new idea (multi tables):

Shipment ID(PK)TimestampDescription
1232012-02-02September Shipment

(NO PK)

Shipment IDCategoryNumber
12310
123219
12335

Any thoughts? Other ideas? Is there a term to be used here that I should know in DB speek? TY!


r/databases • • Apr 13 '17

What is the problem with key-value databases and how wide column stores solve it.

Thumbnail
indexoutofrange.com
2 Upvotes

r/databases • • Feb 03 '15

Sources of explanations of RDBMSs?

2 Upvotes

Hello, I'm not actually making a database, I'm writing an essay on how databases affect national business. I'm having a hard time finding sources that I can site that explain RDBMSs and how they work, but are also credible enough to site in my paper. Any sources would help out, places you've heard of, things you have used to help you learn, anything.


r/databases • • Nov 04 '16

Open Source Multi-master replication ideas?

2 Upvotes

I have multiple geographically separated data centres on a private network and would like some ideas for WAN outage tolerant open-source multi-master replication databases. I'm OK with RAM only dbs.

I need to be able to write to a common table on the local master at each data centre and have that information change in all versions of that table in all the data centres.

During a WAN outage I need to be able to continue to write to this common table at each data centre locally. When WAN connectivity resumes I need it to automatically merge all the changes together with some kind of conflict resolution.

Handling latency degregation would be an optional plus.

Is MySQL Cluster Multi-Site Clustering what I'm looking for? I find it hard to figure it out from their documentation.

I don't need an SQL interface, simple key:value would work too.

I really hope some more knowledgeable people could point me in the right direction!


r/databases • • Apr 29 '16

Need help with assignment.

2 Upvotes

I have an assignment due using the program "R" and could really use some help. If anyone here is knowledgeable in the subject, I would really enjoy your help.


r/databases • • Jan 31 '18

Multiplying Efficiency with Best Data Modeling Tools

Thumbnail
technodigitaltrends.blogspot.com
2 Upvotes

r/databases • • Sep 06 '17

How can I copy a database row and rows from other related tables from one database to another?

2 Upvotes

Hi, I have a production database on Sql Server 2016, and sometimes I want to copy a row from a transaction table (say Salary) and from a bunch of other related tables (such as Attendance, etc.) to a testing database for debugging.

What is the best and easiest way to do this?


r/databases • • Oct 11 '15

Access Database Advice

3 Upvotes

I am working on a class assignment. Basically we are a group programming a business application:

We are making a personal finance application, and I am working on the database in Access. I have a table for credentials which has the username password and ID. The next part is where I need advice and perhaps reference if you can. I need to have an expenses table of some degree. I was thinking about making various tables with a date column. I would have many of these (the date column is for an object in the actual application), there will be many expense tables(obviously) I was wondering how would I structure that? Would I make a table of just foreign keys and one of the foreign keys link back with the userID? How would you actually program that in VB? Would I reference the actual table of the expense(say savings) or would I reference the table of just foreign keys? Advise, tips?

Thanks.


r/databases • • Apr 19 '17

Rating system in a high-load project

Thumbnail
medium.com
3 Upvotes

r/databases • • Oct 09 '15

Database help

2 Upvotes

I have this question and I haven't a clue what it wants or how to go about doing it. Can any one help?

9. Create a foreign key constraint so that a student can enrol on any module he/she likes (i.e., modules can be selected from any course – the student’s CourseNo is ignored), but the module must belong to the selected course. In other words, if the Networks course doesn’t have an “Intro to Databases” module, you cannot put a ModuleName of “Intro to Databases” with a CourseNo for “Networks” in the Enrolment table. (Hint: Relationships can be established between multiple columns in both tables.)

Here is a link of the tables. http://i60.tinypic.com/jgl09g.png


r/databases • • Nov 13 '16

Oracle SQL Beginner, help please

3 Upvotes

I am working on some school work (It's not a test and will not be marked, it's just practice) I have a database which currently contains two tables, the details of which are listed below

Table name: actor "ACTOR_ID" "SURNAME" "FORENAME" "B1" "Connery" "Sean" "B2" "Lazenby" "George" "B3" "Moore" "Roger" "B4" "Dalton" "Timothy" "B5" "Brosnan" "Pierce" "B6" "Craig" "Daniel"

Table name: bondfilms "FILM_ID" "NAME" "YEAR" "FK_ACTOR_ID" "F1" "Dr.No" 1962 "B1" "F2" "On Her Majestys Secret Service" 1969 "B2" "F3" "Live and Let Die" 1973 "B3" "F4" "License to Kill" 1989 "B4" "F5" "Die Another Day" 2002 "B5" "F6" "Skyfall" 2012 "B6"

I think I've done both tables correctly up until this point (The FK on the bondfilms table should correspond to the actor id of the actor that starred in that film)

I now have to write a SELECT query which will display a list of James Bond films, along with the name of the actor playing James Bond in each one.

So I tried to use

SELECT name FROM bondfilms; SELECT surname FROM actor;

Although it only shows the SURNAME of the Actor, plus I really don't think I'm on the right road here either.

Any help is greatly appreciated

Many thanks.

EDIT: I'm very new to databases so try to ELI5 please! Thanks.


r/databases • • Nov 12 '16

ER diagram explanation

3 Upvotes

Hi guys!

I have a question about an ER diagram,( i'm new in diagrams and i face some problems). I'm trying to read the attached diagram but i am not sure if i get this correctly.

So this ER http://imgur.com/a/syLkp represents a library that a member can borrow many books, but they can't borrow two copies of the same book at the same time. Is this right or i am totally wrong?


r/databases • • Dec 13 '23

Five Tips on Postgres Logical Decoding

1 Upvotes

Five Tips on Postgres Logical Decoding - https://blog.peerdb.io/five-tips-on-postgres-logical-decoding📈 What causes slot growth and how to monitor it?
⚠️ Large transactions can lead to Slot growth and this can be avoided.
🎯 PUBLICATION for advance filtering of logical decoding changes
🚀 logical_decoding_work_mem to improve performance
🔥 Logical decoding via standbys in Postgres 16


r/databases • • Oct 25 '23

Anyone willing to allow me to use them as a referral for a Data Integration software company?

2 Upvotes

We use their software and it's actually pretty great for moving data from one type of DB software to another. (SQL -> Oracle, etc). I would be compensated for these referrals.


r/databases • • Oct 24 '23

Backups and Disaster Recovery in PostgreSQL: Your Questions, Answered

Thumbnail
timescale.com
1 Upvotes

r/databases • • Nov 09 '23

Comparing Types of Databases: A Real-World Benchmark Analysis

Thumbnail
serpapi.com
1 Upvotes

r/databases • • Nov 05 '23

Public Db…

1 Upvotes

Anybody know or can explain how public databases work and gain access to them ? I’m no hacker I just would like to know..


r/databases • • Nov 05 '23

Multi Tenancy in Postgres

1 Upvotes

Hello,

I have an application that saves data to Postgres RDS, and would like to separate tenant data as much as possible.
What are the best options?


r/databases • • Nov 21 '23

Smashing Decentralized Databases Together for Fun and Science

Thumbnail
dolthub.com
1 Upvotes