SQLite Archives - Database Tips

DBMS Genealogy

April 22, 2019 Database Tips History

Are PostgreSQL and Ingres related? What MariaDB, MySQL and Infobright have in common? What is the origin of Microsoft SQL[…]

Read more

3 ways to remove duplicate data

April 16, 2019 Database Tips Microsoft SQL Server, MySQL, ORACLE, PL/SQL, PostgreSQL, SQL, SQLite, Transact-SQL functions

Duplicate data can be generated in the database due to design error, software bugs or misuse by end users. Depending[…]

Read more

Using SQL in Python

February 22, 2019 Database Tips Microsoft Access, Microsoft SQL Server, ORACLE, Python, SQL, SQLite

Python has become one of the most popular programming languages and is used in various contexts, including in WEB applications[…]

Read more