60
votes
8
answers
2.9K
views
Create new user in MySQL and give it full access to one database
I want to create a new user in MySQL and give it full access only to one database, say dbTest, that I create w
53
votes
7
answers
2.8K
views
'IF' in 'SELECT' statement - choose output value based on column values
SELECT id, amount FROM report I need amount to be amount if report.type='P' and -amount if report.
54
votes
14
answers
2.1K
views
How do I specify unique constraint for multiple columns in MySQL?
I have a table: table votes ( id, user, email, address, primary key(id), ); Now I want
60
votes
30
answers
1.7K
views
How do I quickly rename a MySQL database (change schema name)?
The MySQL manual at MySQL covers this. Usually I just dump the database and reimport it with a new name. This
63
votes
3
answers
2.3K
views
insert into database from Joomla form fields
I am beginner to Joomla! development and have created a very simple module. How do I create a form with 3 tex
59
votes
1
answers
955
views
Joomla database settings
What is the file, where database setting are stored in Joomla CMS? Like server, user name, database name and
62
votes
8
answers
382
views
Get users by name property using Firebase
I'm trying to create an application where I can get/set data in specific users accounts and I was tempted
54
votes
7
answers
1.7K
views
Firebase Permission Denied
I'm relatively new to coding and am having trouble. I have this code to send data to firebase app.useri
57
votes
4
answers
2.9K
views
In Firebase, is there a way to get the number of children of a node without loading all the node data?
You can get the child count via firebase_node.once('value', function(snapshot) { alert('Count:
75
votes
10
answers
795
views
Compilation failed to complete:Program type already present
When compiling my project I get the following error message: Program type already present: com.google.androi
59
votes
6
answers
1.1K
views
Firebase cloud functions is very slow
We're working on an application that uses the new firebase cloud functions. What currently is happening i
55
votes
9
answers
1.7K
views
How to protect firebase Cloud Function HTTP endpoint to allow only Firebase authenticated users?
With the new firebase cloud function I've decided to move some of my HTTP endpoint to firebase. Everythin
52
votes
5
answers
1.3K
views
Difference between set with {merge: true} and update
In Cloud Firestore there are three write operations: 1) add 2) set 3) update In the docs it says that usi
54
votes
7
answers
408
views
Query based on multiple where clauses in Firebase
{ "movies": { "movie1": { "genre": "comedy", "name": "As good as it gets", "lead": "Ja
59
votes
7
answers
1.4K
views
What's the difference between Cloud Firestore and the Firebase Realtime Database?
Google just released Cloud Firestore, their new Document Database for apps. I have been reading the documenta
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
815
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
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,