Sequelize is a promise-based ORM for Node.js and io.js. It supports the dialects PostgreSQL, MySQL, MariaDB, SQLite and MSSQL and features solid transaction support, relations, read replication and more.
Objection.js is an ORM for Node.js that aims to stay out of your way and make it as easy as possible to use the full power of SQL and the underlying database engine while keeping magic to a minimum.
For many years MySQL and PostgreSQL were competing databases, which addressed slightly different audiences. Here's why you always should go for PostgreSQL!
This is the explanation for the failure to login without superuser
Excerpt from the file "/etc/mysql/mariadb.conf.d/50-server.cnf" line 115
```
# * Unix socket authentication plugin is built-in since 10.0.22-6
#
# Needed so the root database user can authenticate without a password but
# only when running as the unix root user.
#
# Also available for other users if required.
# See https://mariadb.com/kb/en/unix_socket-authentication-plugin/
```
----ule---
Also make sure needed record in table user has empty plugin field (there can be, for example, "unix_socket").
Since version 5.5.7 mysql has various auth plugins support https://dev.mysql.com/doc/refman/5.6/en/authentication-plugins.html
So if you have non-empty plugin field then password would be ignored and there would be warning at mysql error log (for me it's /var/log/mysql/error.log):
[Warning] 'user' entry 'root@localhost' has both a password and an authentication plugin specified. The password will be ignored.
shareedit
answered Apr 28 '16 at 21:27
d9k
12317
1
For someone else that runs across this, when running mysql server 5.7.15, this actually locks your user out if you do not provide a plugin. Probably what you are looking for is a plugin of mysql_native_password. – Jonathan Cantrell Sep 28 '16 at 17:41
For example, to delete rows that exist in t1 that have no match in t2, use a LEFT JOIN:
DELETE t1 FROM t1 LEFT JOIN t2 ON t1.id=t2.id WHERE t2.id IS NULL;
The SQL OFFSET keyword is evil. It basically behaves like SLEEP in other programming langauges: the bigger the number, the slower the execution. Fetching resul…
This article is part of a series. You do not have to read them in order but I will be referring to topics and explanations in previous articles: Implementing Your Own Transactions with MVCCSQL Transaction Isolation Levels ExplainedImplementing Repeatable ...
K. Yank. dpunkt-Verlag, Heidelberg, 2., aktual. und erw. Aufl., Übers. der 3. engl. Orig.-Aufl. edition, (2005)Build your own database driven website using PHP & MySQL <dt.>.