Phonegap Offline Database

I made an app recently that required this, targetting the same OS’s. You can use a combination of 2 databases : 1. LocalStorage :: Check for localStorage function supports_html5_storage() { try { return ‘localStorage’ in window && window[‘localStorage’] !== null; } catch (e) { return false; } } Set an item into LocalStorage localStorage.setItem(“bar”, foo); … Read more

Why don’t you start off with a “single & small” Cassandra server as you usually do it with MySQL?

TL;DR; You can even start with a single node, but you loose the highly available factor of c*. Cassandra is built for systems that handle huge volumes of data, terabytes and in some cases petabytes. Many users typically switch from MySQL (and lots of other RDBMS) to Cassandra once they find that their current DB … Read more

Difference between database drivers and database dialects

This question is not ambiguous , i think it should be answered correctly. We often use Dialect and Drivers to connect a certain application with a certain database management system. For example : in grails / java We define a Dialect property to connect to mysql as having one of this types MySQL5Dialect, MySQLInnoDBDialect, MySQLMyISAMDialect … Read more

Using liquibase on the existing database

The process to put a existing database under liquibase control is the following: Create the initial changelog (that’s what you did) Run liquibase using the command changelogSync. This will create the Liquibase tables and mark all change sets as being applied (this is what you missed) Add your change sets Run liquibase using the command … Read more

Are there any reasons why h2 database shouldn’t be used in production?

The main reasons not to use H2 (or HSQLDB, or Derby) for production are: Probability of critical bugs: compared to the ‘big’ databases Oracle, IBM DB 2, MS SQL Server, MySQL, PostgreSQL, the Java databases are relatively new and therefore possibly not as stable (have bugs). Please note this is true for all newer products, … Read more

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)