60
votes
19
answers
1.3K
views
MongoDB or CouchDB - fit for production?
I was wondering if anyone can tell me if MongoDB or CouchDB are ready for a production environment.
62
votes
11
answers
1.7K
views
How do you query for "is not null" in Mongo?
I would like to execute a following query: db.mycollection.find(HAS IMAGE URL) What should be the correct s
60
votes
10
answers
440
views
How do you rename a MongoDB database?
There's a typo in my MongoDB database name and I'm looking to rename the database. I can copy and d
60
votes
17
answers
1.4K
views
How can I list the tables in a SQLite database file that was opened with ATTACH?
What SQL can be used to list the tables, and the rows within those tables in an SQLite database file - once I
63
votes
7
answers
2.1K
views
What are the options for storing hierarchical data in a relational database?
Good Overviews Generally speaking, you're making a decision between fast read times (for example, nested
52
votes
28
answers
2.1K
views
Insert into ... values ( SELECT ... FROM ... )
I am trying to INSERT INTO a table using the input from another table. Although this is entirely feasible for
60
votes
27
answers
2.9K
views
What is the difference between "INNER JOIN" and "OUTER JOIN"?
Also how do LEFT JOIN, RIGHT JOIN and FULL JOIN fit in?
59
votes
3
answers
1.6K
views
How does the HyperLogLog algorithm work?
I've been learning about different algorithms in my spare time recently, and one that I came across which
54
votes
14
answers
2K
views
What are the differences between B trees and B+ trees?
In a b-tree you can store both keys and data in the internal and leaf nodes, but in a b+ tree you have to stor
58
votes
7
answers
2.3K
views
Codeigniter - multiple database connections
I have to retrieve a MySQL database information from master database and then connect to that database, and fe
65
votes
1
answers
2.7K
views
Advantages / Disadvantages of pconnect option in CodeIgniter
One of the parameters in the CodeIgniter database config is the following ['pconnect'] TRUE/FALSE
62
votes
11
answers
951
views
CodeIgniter - return only one row?
At the moment if I am doing a query on the database that should only return one row, using: ...query stuff...
