GitHub

Enhancement: Improve MySQL to SQLite parser to handle advanced SQL functions.

The mysqlToSQLiteParser.js script is a critical component for ensuring that SQL problems written in MySQL dialect run correctly on the server's SQLite engine. However, this translation layer may not ...
Linux Journal

MariaDB/MySQL, PostgreSQL and SQLite3 - Comparing Command-Line Interfaces

Don't be afraid of using your chosen database's command-line client. I might as well say this up front: I don't like using GUI (aka non-command-line or graphical) tools with my databases. This is ...
GitHub

Valid sqlite statement fails to transpile to mysql

In hindsight, we should not have tried to make SQLite accept MySQL 3.x syntax, and should have never allowed double-quoted string literals. However, there are countless applications that make use of ...
MacTech

MySQL/SQLite SQL Query and Data Export Component available

Steven Cholerton has announced MySQL/SQLite SQL Query and Data Export Component for Xojo and REALStudio Developers to use within their own applications. He says it allows developers to give their ...
prototypr

SQLite in Production: 10 examples out in the wild

Sometimes the best option is the simplest, even when it comes to databases. While many developers reach for Postgres or MySQL by default, might it be better to take the more lightweight approach to ...