Ben Chuanlong Du's Blog

It is never too late to learn.

Comparison of Embedded Databases

Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!

SQLite

Apache Derby

H2

HSQLDB

References

https://www.baeldung.com/java-in-memory-databases

https://www.quora.com/Would-you-use-Apache-Derby-or-SQLite-for-a-single-file-embedded-database-for-your-Java-application

https://www2.sqlite.org/cvstrac/wiki?p=SqliteVersusDerby

https://db-engines.com/en/system/Derby%3BH2 …

Connect to Databases Using pyodbc in Python

Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!

pyodbc only supports qmark

https://github.com/mkleehammer/pyodbc/wiki

Unicode Converter Buffer Overflow

This issues arises in Python3 but not Python2, so the simplest way is to use Python2 if …

Tips on MySQL

Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!

sudo service mysql restart
mysqladmin -u root -p variables | grep port

mysqladmin --help list the locations of my.cnf.

mysqladmin --help

Python Packages

  1. peewee

  2. PyMySQL

  3. MySQLdb

References

Tips on MongoDB

Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!

{"\(and": [{"tags": {"\)regex": "idea"}}, {"tags": {"$regex": "idea"}}]}

{"\(and": [{"tags": {"\)regex": "idea"}}, {"tags": {"$regex": "mob"}}]}

mongoimport -d notes -c note notes.json

mongodb: dbpath, centos: /data/db by default

Tips on Elasticsearch

Things on this page are fragmentary and immature notes/thoughts of the author. Please read with your own judgement!

https://www.elastic.co/guide/en/elasticsearch/reference/2.1/setup-service.html

SQL Support

  1. Elasticsearch supports SQL syntax starting from version 6.3. There is also an unofficial SQL support of …