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

MySQL Automatic Install with Salt – Preseed Database Root Password

MySQL is probably the most popular multi-user database in the world*. It’s part of the most popular web development stack, LAMP (Linux Apache MySQL PHP). This article shows a Salt state to automatically install MySQL on Ubuntu. As the package … Continue reading

Posted in Uncategorized | Tagged , , , , , , , , , | Comments Off on MySQL Automatic Install with Salt – Preseed Database Root Password

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

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

Monty Widenius Speaks in Pasila

Monty Widenius speaks in Haaga-Helia. He created MySQL database. Database Transaction Summit on w36 Wed 2013-09-04. Free registration until w35 Fri 2013-08-30.

Posted in Uncategorized | Tagged , , , , , , , , | Comments Off on Monty Widenius Speaks in Pasila

Download StackOverflow – XML dump under CC-by-sa license (torrent link)

StackOverflow is the leading programmers question and answer site. Now you can legally download their whole database as XML. Download StackOverflow database dump (4.9 GB 7z torrent, contains all StackExchange sites until Dec 2011) StackOverlow blog links to Clear-bits (in … Continue reading

Posted in Uncategorized | Tagged , , , , , , , | Comments Off on Download StackOverflow – XML dump under CC-by-sa license (torrent link)