Tagged Questions
0
votes
2answers
94 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
3answers
103 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 ...
1
vote
0answers
78 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
2answers
143 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 ...
10
votes
4answers
935 views
Why do relational databases only accept SQL queries?
As far as I know, most relational databases do not offer any driver-level API for queries, except a query function which takes an SQL string as an argument.
I'm thinking how easier it would be if one ...
57
votes
13answers
4k 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 ...
12
votes
6answers
1k views
Do You Still Need Indexing After Database Normalization
After you have done a good normalization, do you still need to index the table? How is this going to affect the performance? Will it even affect the performance in some way after a good normalization? ...
1
vote
1answer
88 views
Database data structures for RESTful api
I am creating a RESTful API. I am struggling to decide on the best way to design my database tables around my resources.
Initially, I though a table per resource would be a good way to go, but I'm ...
2
votes
2answers
369 views
Why is NoSQL better for this scenario?
Hypothetical scenario: Let's say we are downloading JSON from Facebook with details of a user's friend's checkins, posts, etc... These come in as one document per friend per activity, so with 8 ...
2
votes
1answer
737 views
Size of database a factor for Hibernate vs JDBC?
Do you know if the size of the database (number of tables used) is a factor when choosing between Hibernate and JDBC? Why or why not?
-1
votes
1answer
121 views
Development paradigm: SQL programming vs using SQL to program [closed]
I would like to know what are the pros and cons to two apparently valid philosophies regarding the programming of an application which makes extensive use of a database.
The first philosophy is to ...
29
votes
11answers
10k views
SQL: empty string vs NULL value
I know this subject is a bit controversial and there are a lot of various articles/opinions floating around the internet. Unfortunatelly, most of them assume the person doesn't know what the ...
1
vote
1answer
93 views
Is Neo4j graph database sufficient to itself for all query types?
Neo4j eases relationship traversals => especially useful for a social network for instance.
But are there any scenarios when it's advised to associate an additional relational database (or other ...
7
votes
4answers
355 views
Database History Table / Tracking Table
Currently I want to structure a tracking/history table like this:
PrimaryKey - ID
OtherTableId - fk
fieldName - name of the field its tracking
OldValue
NewValue
UserName
CreateDateTime
So ...
8
votes
4answers
346 views
Should database queries be abstracted out of the page itself?
When writing page generation in PHP, I often find myself writing a set of files littered with database queries. For example, I might have a query to fetch some data about a post directly from the ...
