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...
Category: Databases
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....
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...