This tag is for general database questions; if you question is specific to SQL use that tag instead.
1
vote
2answers
120 views
Pattern / methodology for representing large database records as objects
A bit of background information: We have an old database application written in Access that lets users monitor their workload, and the code is... 'procedural' might be too kind. The vast majority of ...
2
votes
4answers
451 views
Notify players every x seconds in a multiplayer game
I'm working on a realtime multiplayer game using Django and gevent-socketio, I'm facing some issues:
I need to send an update of the game state to connected players every X seconds (~4 seconds), so ...
9
votes
4answers
1k views
Best Practices: Database app programming patterns
I have written many database (MySQL) web apps so far but I always think my structure is kinda clumsy. I want to improve the programming/design pattern I use, hoping for some advice here. Particularly, ...
0
votes
2answers
174 views
Data Aggregation of CSV files java
I have k csv files (5 csv files for example), each file has m fields which produce a key and n values. I need to produce a single csv file with aggregated data.
I'm looking for the most efficient ...
0
votes
0answers
38 views
dynamic form builder with ability to compare-search-filter input data [closed]
I want to create a dynamic form builder (admin makes different forms for car-home-home appliances-... and visitors present their products and other visitors search for proper product.
in below ...
1
vote
1answer
118 views
How should I handle two crons that update the database?
I'm working on a Bitcoin-clone block explorer (specifically Mincoin) which has a block timer of about 1 minute. For those unfamiliar with Bitcoin, basically a new data structure called a block is ...
2
votes
1answer
96 views
What is the preferred strategy for editing data from a database?
We are redesigning an old VB6 application in Net. The application makes extensive use of a database and includes management of club members and their results in the competitions that they partake in.
...
1
vote
1answer
50 views
How to Track File Uploads and Return Upload Status with REST?
The users for our software will want to upload potentially large amounts of files in bulk to our servers. It is then desired that we display the upload status any time the user views the upload ...
2
votes
2answers
112 views
Using Autoincrement Primary keys as Foreign Keys
When creating a table, there is an option for us to set the numeric primary key as autoincrement where it's value increases whenever a new data in inserted.
This primary number can be used for ...
2
votes
3answers
175 views
How to insert a database layer in PHP
I maintain and add features on a freelance basis to a website written in PHP. The application was started in PHP4 by a junior programmer back in 2006, and features some very insecure and ...
1
vote
1answer
124 views
Immutable Data Structure For Time Series Data
I'm wondering what the best data structure (for storing data on disk) is for storing immutable time-series data (99% of the data is truly immutable, the 1% is metadata that is separate from the ...
98
votes
13answers
32k views
Why use a database instead of just saving your data to disk?
Instead of a database I just serialize my data to JSON, saving and loading it to disk when necessary. All the data management is made on the program itself, which is faster AND easier than using SQL ...
0
votes
1answer
105 views
Database design for geographical data
So, I'm in need to provide geographical data to my application. That said, Postalcodes, States and Countries... Maybe even streets. But that's another point.
Is there any best practice on how one ...
3
votes
4answers
494 views
Other things to learn for becoming a Database Admin/Developer?
Obviously i'll have to make some sort of choice at what DB i choose to go with (MS-SQL/MYSQL/etc) but this question isn't about that.
The question mainly is what other languages/tools would be ...
0
votes
0answers
36 views
Fixing data duplication
I'm currently doing maintenance on an old order system that has grown into the poster child for bad coding practice. One of the tings I'm dealing with is a lot of data duplication, which I want to ...
