.If you are in the process of creating a mobile app and want to know what’s the best type of database for mobile applications, you’ve come to the right place. Mobile apps have become an integral part of our culture, and you can only become a prominent app developer if your app is available 24...
Category: Databases
Materialized Views In MySQL And MariaDB
You can implement materialized views in MySQL. How? Read this post and I will show you 3 different methods for creating a MySQL materialized view. An application is only as fast as it’s slowest component. If your application uses MySQL your objective is clear: Improve MySQL query performance to get faster data retrieval and...
What is CouchDB equivalent of SQL not in or not equals?
I’ve started using CouchDB mainly as a database for mobile apps. However I found it useful also as a backend for server side web applications. I’m a beginner with CouchDB and in one of my applications I needed something simple. I wanted all documents except the ones with a certain value for a field. The...
MySQL backup restore gives “Invalid command” error
Doing the MySQL backup In this short post I would like to share with you a problem I encountered and the solution found while working with the MySQL tool mysqldump. The story is quite simple: doing some maintenance work on one production application server it was standard procedure to make a full MySQL backup before...