This tag is for general database questions; if you question is specific to SQL use that tag instead.
-1
votes
0answers
31 views
Any experience on open source database synchronization open source solutions? [on hold]
I'm considering few database synchronization open source solutions. The system in need for data synchronization is composed of instances of different types of databases, i.e. heterogeneous system. ...
3
votes
1answer
30 views
Where should the database and mail parameters be stored in a Symfony2 app?
In the default folder structure for a Symfony2 project the database and mail server credentials are stored in parameters.yml file inside ProjectRoot/app/config/parameters.yml with these default ...
2
votes
3answers
143 views
How long should I wait to autosave user input?
I have a table where a User can edit data by simply choose a field, then edit its value. I want to fire an update function to automatically save the data to a MySQL database.
However, I think that ...
2
votes
0answers
40 views
Best way to rename existing unique field names in database?
I have a database table that contains id, filename, userId
id is unique identifier
filename should also be unique
table may contain >10000 records
When a user uploads a file it should be ...
0
votes
0answers
39 views
Database model for keeping track of likes/shares/comments on blog posts over time
My goal is to keep track of the popular posts on different blog sites based on social network activity at any given time. The goal is not to simply get the most popular now, but instead find posts ...
-3
votes
0answers
35 views
Is MongoDB a good choice or not for my application? [closed]
I have a Reporting application which stores the reports in xml format as recieved from source (XML schema is not defined, it can be any format) and those reports contain some keys and values. Like ...
0
votes
0answers
7 views
How to manage primary key while updating [closed]
In the following table primaryKeyColumn is primary key.
To maintain the data history I always uses the values with WHERE condition(WHERE StatusColumn=1) And will set the StatusColumn to 0 if the data ...
2
votes
2answers
174 views
Implementing set of processes in a stored procedure or through the code?
I want to know what's the suitable method to implement the following case (best practice).
If i make a set of processes like this:
select data from set of DB tables.
loop on the selected result.
...
0
votes
0answers
6 views
How are sites like Pintrest able to hold all those pictures? [migrated]
Does anyone know how sites hold massive numbers of pictures in general? I tried researching this, but it seems like they would need massive storage spaces to hold all these, unless there was a trick ...
5
votes
4answers
209 views
Get Info From Database, or Build Inferred Info?
Does it make more sense to store and retrieve properties or information directly related to an item in a database, or, say in such a case that a product's ID could describe information about it, ...
2
votes
2answers
77 views
Designing a user-defined list to be stored in a relational database - Should I include user index?
By index, I mean, as the user creates the list, each item receives an integer index for its place in that particular list. Since there will be a table of ListItems, I'd prefer to avoid using the name ...
0
votes
0answers
24 views
What is the disadvantage of using abstract class as a database connectivity in zend framework 2 instead of service locator
If I use database by creating adapter with drivers, initialize it in some abstract class and extend that abstract class to required model. Then use simple query statement. Like this:
namespace ...
2
votes
1answer
38 views
Handling changes to data types and entries in a database migration
I'm fully redesigning a site that indexes a number of articles with basic search functionality. The previous site was written about a decade ago, and I'm salvaging about 30,000 entries with data ...
2
votes
0answers
45 views
Would a model like this translate well to a document or graph database?
I'm trying to understand what types of models that I have traditionally persisted relationally would translate well to some kind of NoSQL database. Suppose I have a model with the following ...
1
vote
2answers
219 views
Building a database class in PHP
I wonder if I should write a database class for my application, and if so, how to accomplish it?
Over there on SO, a guy mentioned it should be written as an abstract class. However, I can't ...
1
vote
1answer
114 views
Storing large data in HTTP Session (Java Application)
I am asking this question in continuation with http-session-or-database-approach.
I am planning to follow this approach.
When user add product to cart, create a Cart Model, add items to cart and ...
1
vote
2answers
89 views
Configurable tables in sql database
I have the following tables in my database:
Config Table:
======================================
Start_Range | End Range | Config_id
10 | 15 | 1
...
1
vote
2answers
271 views
Should I close database connections after use in PHP?
I wonder if I should close any unnecessary database connection inside of my PHP scripts.
I am aware of the fact that database connections are closed implicitly when the block stops executing and ...
5
votes
1answer
268 views
Is inline SQL still classed as bad practice now that we have Micro ORMs?
This is a bit of an open ended question but I wanted some opinions, as I grew up in a world where inline SQL scripts were the norm, then we were all made very aware of SQL injection based issues, and ...
3
votes
1answer
48 views
An extensible logging architecture for Android?
The end goal is to have a variety of data sets that can all be graphically plotted against eachother.
All data should correspond to a date, so that when plotted against each other, they show the ...
0
votes
0answers
20 views
How to mitigate security risks when deploying a database to the web via automated migrations?
I'm looking at using built in database migrations frameworks (such as the migration framework included in EF Code First or migratordotnet) but I have concerns about the implications of allowing a ...
2
votes
3answers
122 views
How do the blogging sites or sites that host prose like contents store the data?
How do the blogging sites, Q&A sites (or any other sites host prose like content) store their data? That is, how do you store blogs and Q&A content in the database?
I hope it is not good to ...
2
votes
1answer
100 views
content fingerprint algorithm
I have a database containing just simple URLs. It is as simple as it sounds for now and URL can link to a website or a document(i.e. anything parseable to text).
Now I have a simple code which ...
7
votes
4answers
340 views
What exactly does it mean that storing “large blobs in the database reduces performance�??
To someone who knows database internals this may be an easy question, but can someone explain in a clear way why storing large blobs (say 400 MB movies) in the database is supposed to decrease ...
2
votes
2answers
125 views
How does aggregation work when databases are involved?
So I'm reading a book on Design Patterns (Design Patterns Explained 2nd Edition), and all throughout the book it says to "favor aggregation over inheritance".
I'm trying to wrap my head around trying ...
3
votes
1answer
56 views
How does datomic handle “corrections”?
tl;dr
Rich Hickey describes datomic as a system which implicitly deals with timestamps associated with data storage
from my experience, data is often imperfectly stored in systems, and on many ...
0
votes
3answers
107 views
Modeling a Student Application/Committee Relationship
I'm developing an ERD for a graduate student manager program (it's for a university class, so it's a fairly trivial implementation).
In this snippet of the model, I'm trying to work out the ...
-1
votes
3answers
92 views
Choosing right database for school administration system [closed]
I need to choose the right database for the open source school administration system, which will be presented at one contest. As in Czech there is another one. Its main disadvantages are high fees ...
1
vote
1answer
127 views
Unit-testing databases: test all possible permutations of read and write to table?
I am testing a resource management class that is interacting with a database or a file system, or a combination of both. I was wandering if it is the norm to test all possible permutations of read and ...
3
votes
3answers
218 views
Web App vs. Desktop App Regarding Deployment
I'm taking on an opportunity for a local business to develop a small, simple timesheet manager (they still record time by hand) and am currently in the planning phases. It will include basic ...
