When building a multi-tenant application with PostgreSQL, you might choose to store your tenant-specific data in separate schemas within the same database. This is a common and efficient approach. However, what if you need to access information like tenant credentials that are stored in a completely separate database, possibly even on a different server? For...
Category: Databases
Types of Databases for Mobile Applications
.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...
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...