52
votes
7
answers
933
views
How can I do Base64 encoding in Node.js?
Does Node.js have built-in Base64 encoding yet? The reason why I ask this is that final() from crypto can only
54
votes
4
answers
2.7K
views
WooCommerce: Finding the products in database
I'm creating a website using WooCommerce and I want to restrict the available products to users depending
52
votes
8
answers
3.1K
views
Table is marked as crashed and should be repaired
I am getting this error in wordpress phpMyadmin #145 - Table './DB_NAME/wp_posts' is marked as cras
47
votes
8
answers
2.7K
views
Ways to implement data versioning in MongoDB
Can you share your thoughts how would you implement data versioning in MongoDB. (I've asked similar quest
59
votes
12
answers
819
views
How do I manage MongoDB connections in a Node.js web application?
I'm using the node-mongodb-native driver with MongoDB to write a website. I have some questions about ho
57
votes
24
answers
2.8K
views
MongoDB: Is it possible to make a case-insensitive query?
Example: > db.stuff.save({"foo":"bar"}); > db.stuff.find({"foo":"bar"}).count(); 1 > db.stuff.find(
51
votes
15
answers
1.5K
views
How to remove a field completely from a MongoDB document?
{ name: 'book', tags: { words: ['abc','123'], lat: 33,
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
57
votes
30
answers
1.9K
views
How do I perform an IF...THEN in an SQL SELECT?
How do I perform an IF...THEN in an SQL SELECT statement? For example: SELECT IF(Obsolete = 'N' OR
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
63
votes
14
answers
2.1K
views
What is C# analog of C++ std::pair?
I'm interested: What is C#'s analog of std::pair in C++? I found System.Web.UI.Pair class, but I&apo
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