This tag is for general database questions; if you question is specific to SQL use that tag instead.
2
votes
1answer
133 views
Designing a universal database driver class
I have a homebrew MVC framework that I have been using for a while, and it has been working great, but I am planning an upgrade to it for its ORM classes. So far, it only supports SQL databases by ...
0
votes
0answers
29 views
What are the benefits of having a remote database for your command line utility
I'm current working on a command line app that will grab resources online for you when you're setting up a new project locally. Right now all the urls for the resources I need are hardcoded into the ...
0
votes
2answers
144 views
JSON vs Foreign Keys
I'm developing an enterprise website, and I have to define some sections like this:
I have many sections and each section have many (or one) sub-pages.
The number of sub-pages vary per section.
...
0
votes
4answers
173 views
Create a database for database tables
I'm working on a project where I have to give users the ability to build their own tables,
each user can create more than one table.
(the type of all data is string).
The user can create a table and ...
1
vote
2answers
250 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 ...
0
votes
0answers
60 views
Unit Tests for Database Abstraction Layer
I previously asked this question about creating an algorithm for joining records from multiple databases, and since then, I have built a rudimentary version of it (which doesn't allow for inter ...
3
votes
1answer
151 views
Reading from a file and inserting into a database, a good practice
I am making an Android application which reads several JSON files and inserts the read information into tables in my database.
For instance, there are three files:
countries.json
{
...
2
votes
2answers
92 views
What are some important analytics for a SaaS Product Dashboard?
Question:
What are some important analytics for a SaaS Product Dashboard?
Background:
I will be making a dashboard for administration of our product. In this dashboard gathering some analytics for a ...
0
votes
2answers
92 views
Use client to access database or server to access database
I' creating a client server application in which I need to update a particular database. I'm using python with MySQL. There are two options:
I use a client.py and server.py, the client.py can send ...
5
votes
3answers
430 views
Unit Testing DatabaseOpenHelper class in Android
I've written several unit tests for an already existing DatabaseOpenHelper class. I covered the creation scenario and migration from old schema to new one. Unfortunately, I don't feel that my tests ...
0
votes
1answer
28 views
One to Many Relationship Django
let say I want my User model to have only one location and my Post model to have many location. How Do I design the model? This is what I have in mind so far. Is this going to work? Do I need to ...
2
votes
2answers
177 views
Duplication of view access control logic in database queries and application component
Our web application has a complex access control system which incorporates role-based and object-level privileges.
In the business logic layer, this is implemented by a component that obtains (and ...
3
votes
0answers
102 views
Suitable algorithm for joining records from multiple databases
I am in the process of writing a library that is used to be able to access data from a database. The library requires the initial definition of all the tables that the application will be using in the ...
-1
votes
1answer
35 views
Which cloud computing provider? [closed]
I need help choosing a cloud application server / database provider.
I am going to write a small trade management system and does not want to setup my own server.
I need to run two tomcat instances ...
2
votes
4answers
179 views
Plugin Architecture: How to Handle Databases and Logging?
I am in the process of designing an architecture for a plugin based application and I have some questions about how to handle database access and logging. The goal of my application is to allow a ...
-1
votes
0answers
41 views
Python: Single Quotes Showing up in my Database [migrated]
I'm doing some python programming, inserting data into a MYSQL database for a project. I've been doing the coding, but noticed an odd artifact; Whenever I insert string data, my database includes the ...
3
votes
2answers
315 views
Suggested Web Application Framework and Database for Enterprise, “Big-Data” App?
I have a web application that I have been developing for a small group within my company over the past few years, using Pipeline Pilot (plus jQuery and Python scripting) for web development and ...
0
votes
0answers
84 views
HDF vs NOSQl solutions
Hi I get a look in some scientific data stored in HDF5 format and I was wondering if there is any NoSQl solution that will reach the same performance in read/write as HDF5 .
The data of my example ...
0
votes
2answers
143 views
ACID compliant Database that isn't NoSQL? [closed]
I'm not necessarily asking if a NoSQL database can be ACID compliant, which has been asked here:
Is there any NoSQL that is ACID compliant?
I'm wondering if we have a database either now or in the ...
-2
votes
0answers
63 views
Server for running MySQL with ultra large databases? [closed]
I have quite many very large databases (millions of records at the least) in MySQL that need to be sorted, re-organized, indexed, etc. and I currently have 2 desktop Intel i7 PCs running all day long ...
3
votes
3answers
254 views
Architecting persistence (and other internal systems). Interfaces, composition, pure inheritance or centralization?
Suppose that you need to implement persistence, I think that you're generally limited to four options (correct me if I'm wrong, please)
Each persistant class:
Should implement an interface ...
2
votes
3answers
115 views
Referencing countries via Foreign Key Constraint
To make things simple to explain: I've got two tables: Table1 and Countries.
The Countries table contains a nice flag and some information, such as DisplayName, the ISO3166 ALPHA3 code and the phone ...
10
votes
2answers
497 views
General thought process for “How would you build this website/app” interview questions
I've collected a bunch of interview questions like "Describe how you would design a photo album application", "Describe how you would design this particular feature of this particular website" (e.g. ...
1
vote
2answers
127 views
What is the best practice for saving TimeZones in the database?
We want to start collecting timezones for each of our addresses in the database. What is the best practice to store the timezones? How would you go about acquiring timezones for the existing address ...
0
votes
1answer
54 views
What are some database designs that support lineage tracing?
Environment
PostgreSQL 9.1
Java
Problem
I'll try to illustrate the problem here as simply as possible:
I'm trying to record the following relationship:
Node 1 => Node 2 => Node 3
Where Node 1 ...
0
votes
1answer
51 views
Should I re-download my server data after each change?
I have a simple DB editor that sits on the client. When I make changes via the editor, should I re-get all my data, as some of it is changed, or can I just do a check to make sure the procedure ran ...
1
vote
4answers
346 views
Why NoSQL (Key-Value) storage become popular these days?
It seems that NoSQL concept not something very new and innovative, but these days become very popular. Why it become popular recently but not happen in the time when SQL is very popular?
6
votes
5answers
214 views
Storing a re-orderable list in a database
I'm working on a wishlist system, where users can add items to their various wishlists, and I plan to allow users to re-order the items later on. I am not really sure about the best way to go about ...
1
vote
1answer
151 views
Which practice is the best for database connection? (PHP, etc)
Leave a open database connection throughout the execution of the aplication, or for each time a operation will be executed a new connection will be created?
Open throughout the execution:
Open ...
6
votes
2answers
741 views
Will B-Trees and Other Data Structures Become Obsolete With The Advent of Solid State Drives?
Many (perhaps most?) database applications today use B-Trees and variations to store data, because this data structure optimizes the read, write and seek operations on a hard disk (and these ...
7
votes
1answer
309 views
Are there tools that do automated validation of database standards?
I'm looking for something akin to FxCop, but for databases. Basically, I want to have a tool where I configure my database standards (naming conventions, field types, or more complex custom rules). ...
12
votes
6answers
1k views
In plain English, what is a database index most similar to?
Setup: Suppose you are teaching an introduction to Databases class, the students are CS students that have a working knowledge of tree structures, how they can speed up searches, and have probably ...
87
votes
15answers
3k views
How do you store “fuzzy dates” into a database?
This is a problem I've run into a few times. Imagine you have a record that you want to store into a database table. This table has a DateTime column called "date_created". This one particular record ...
4
votes
6answers
471 views
HTTP Session or Database approach
I am confused a little as what should be my approach, Working on a design of shopping cart and i need to store shopping cart either in session or in database but not sure which approach would be ...
8
votes
6answers
416 views
How much business logic should the database implement? [duplicate]
I've worked in some projects where most of the business logic was implemented on the database (mostly through stored procedures). On the other side, I've heard from some fellow programmers that this ...
1
vote
1answer
81 views
Identifying Users
We have a site that allows users to generate their own content. If users generate illegal content, we'll be submitting a report to the authorities. In the event that we do have to report a user, we ...
10
votes
5answers
550 views
For an ORM supporting data validation, should constraints be enforced in the database as well?
I have always applied constraints at the database level in addition to my (ActiveRecord) models. But I've been wondering if this is really required?
A little background
I recently had to unit test a ...
2
votes
2answers
217 views
Moving from local storage to a remote database: how should I cache the data locally?
I have a .NET (C#) application that I am releasing soon, which also has some support files. Right now I am storing those files as .txt files, and I update them as necessary whenever the application ...
-1
votes
1answer
61 views
Storing User Form Data
I am trying to come up with a data schema/methodology for storing the data collected from various different user application forms.
All forms contain the basic info like name, address, etc but then ...
3
votes
2answers
156 views
java classes and database queries
Can someone please explain the best way to solve this problem.
Suppose I have three classes
Person
Venue
Vehicle
I have a DAO method that needs to return some or all of these attributes from each ...
0
votes
2answers
167 views
Mapping a legacy database to ORM using wrapper classes
I want to use an ORM with a legacy database, but I don't want to expose some of the underlying data types. For example, some of the columns are nullable doubles or floats and I want my domain model to ...
-3
votes
2answers
102 views
Suggestions for useful “databases health” dashboard [closed]
Background:
I work as a dev at a face-paced start-up where we use several MySql instances. My non-dev colleagues, who consume our internal services fairly often send emails to our group complaining ...
3
votes
4answers
525 views
NoSQL and BIG DATA
I am doing an internship on Big Data technologies so I am new to this area. My question is about the use of NoSQL in the Big Data architecture. Do we need always to use a distributed storage (like ...
2
votes
1answer
129 views
Best way to lazy load blob from database in Java?
I have a database table that stores uploaded files (excel files) in a blob field. Each record contains the uploader, upload-time, the upload ID (primary key) and of-course, the blob itself.
At some ...
0
votes
3answers
117 views
Search on multiple values
I have a database having around 15 tables.Currently I am working on a report generation page, which is having 16 criteria.The values are distributed among multiple tables.User can select any number of ...
0
votes
6answers
229 views
For a web-application, should I programmatically create the database tables or provide a schema file and instructions?
The few LAMP web applications I have installed require me to create the necessary database tables myself, with a schema file, instead of doing it automatically with a script or setup page. Is this a ...
3
votes
1answer
153 views
Application Design with a Shared Database
I have a generic design question that relates to enterprise applications but I think that software developers from other types of projects may have experience with this as well.
The scenario is ...
-2
votes
1answer
192 views
How do I create a web service with high amounts of traffic that works effectively with lots of different users? [closed]
I have created web services before that are used by a small number of users but have a new project that would have lots of users.
For each user that uses the services, this is what they would do:
1) ...
16
votes
7answers
3k views
How to suggest using an ORM instead of stored procedures?
I work at a company that only uses stored procedures for all data access, which makes it very annoying to keep our local databases in sync as every commit we have to run new procs. I have used some ...
5
votes
1answer
112 views
What is the common approach to component template databases?
My Project:
I have employees who are required to go through a checklist when they encounter a duck, a cat, and a human. In our business, we have a set number of ducks, cats, and humans that come in ...
