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 , , , , , , , , , , , , , , | Leave a comment

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 , , , , , , , | Leave a comment

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 , , , , , , , , | Leave a comment

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 , , , , , , , , | Leave a comment

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 , , , , , , , , , | Leave a comment

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
  • Picks

  • Boxing Clock for AndroidOcton8 Diving T-ShirtsShaking Tower Panda Android GameLearn Chinese with Android
  • Student projects