Install MariaDB on Ubuntu 18.04 – Database Management System, the New MySQL

MySQL/MariaDB is probably the most popular multi-user database in the world. Since Ubuntu 18.04, you should install mariadb-* packages to use this database.

Posted in Uncategorized | Tagged , , , , , , , | Comments Off on Install MariaDB on Ubuntu 18.04 – Database Management System, the New MySQL

Initial Testing and Tries on MySQL Socket Authentication

MySQL has some initial support for passwordless socket authentication, but based on by very brief and initial testing, it does not seem to be ready for prime time yet. If you want socket authentication, PostgreSQL does socket authentication out of … Continue reading

Posted in Uncategorized | Tagged , , , , , , , , , , , , , , | Comments Off on Initial Testing and Tries on MySQL Socket Authentication

PostgreSQL Install and One Table Database – SQL CRUD tutorial for Ubuntu

PostgreSQL is a popular database used often with Python Django, Python Flask and many other frameworks. It’s known for reliability and being very ACID. In this tutorial, you’ll learn to Install PostgreSQL Server and Client on Ubuntu Create, read, update … Continue reading

Posted in Uncategorized | Tagged , , , , , , , | Comments Off on PostgreSQL Install and One Table Database – SQL CRUD tutorial for Ubuntu

Install PostgreSQL on Ubuntu – New user and database in 3 commands

Installing PostgreSQL is trivially easy. You just have to use the same name for linux user, database user and the database name.

Posted in Uncategorized | Tagged , , , , , , , , | Comments Off on Install PostgreSQL on Ubuntu – New user and database in 3 commands

Two Common MySQL Tricks: LAST_INSERT_ID() and Trash

Create a new database item, then open it for editing: LAST_INSERT_ID(). Undo is better than “are you sure”. Mark items deleted, then empty trash when sure. Read the basics first: MySQL Install and One Table Database – SQL CRUD tutorial … Continue reading

Posted in Uncategorized | Tagged , , , , , , , , | Comments Off on Two Common MySQL Tricks: LAST_INSERT_ID() and Trash

MySQL Install and One Table Database – SQL CRUD tutorial for Ubuntu

MySQL is the most popular multi-user database. In this tutorial, you’ll learn to Install MySQL Server and Client on Ubuntu Automate MySQL login Create, read, update and delete data (CRUD)

Posted in Uncategorized | Tagged , , , , , , , , , | Comments Off on MySQL Install and One Table Database – SQL CRUD tutorial for Ubuntu

Reading StackOverflow XML Dump to MySQL Database

StackOverflow data is available for free. To play with the XML data dump, you must insert it into MySQL database. This report shows you how. This article is not for beginners. To follow this article, you should have the StackOverflow … Continue reading

Posted in Uncategorized | Tagged , , , , , , | 1 Comment