Blog: Peter Gulutzan


209 blogs updated: 8 min. ago
No more mysql.proc in MySQL 8.0
MySQL has thrown away the mysql.proc table for version 8.0 Development Releases. The best explanation that I've seen is the one that Dmitry ...
6
22-08-2017 23:04:14 Peter Gulutzan MySQL
The SQL Standard is SQL:2016
Now the words "SQL Standard" mean ISO/IEC 9075 Information technology -- Database languages -- SQL ... 2016" or more briefly SQL:2016. I am ...
13
27-04-2017 22:05:09 Peter Gulutzan MySQL
MySQL, MariaDB, International Components for Unicode
In an earlier blog post I wrote "MySQL has far better support for character sets and collations than any other open-source DBMS, except some...
9
11-04-2017 22:43:36 Peter Gulutzan MySQL
Sequences
What sequences are, who supports them, and why they're better than GUIDs or auto-increment columns except when they aren't. What sequences a...
9
13-03-2017 23:28:43 Peter Gulutzan MySQL
PL/SQL in MariaDB
The Oracle 12c manual says "Oracle PL/SQL provides functionality equivalent to SQL/PSM:2011, with minor syntactic differences, such as the s...
9
16-01-2017 02:03:52 Peter Gulutzan MySQL
Pronouncing Database Terms
It is the business of educated people to speak so that no-one may be able to tell in what county their childhood was passed. -- A. Burrell, ...
6
01-12-2016 03:31:46 Peter Gulutzan MySQL
The First Development Milestone for MySQL 8.0
MySQL 8.0.0 exists. For general impressions we already have comments by Giuseppe Maxia and Stewart Smith and Serdar Yegulalp. Two new featur...
12
29-09-2016 22:21:22 Peter Gulutzan MySQL
Binary Serializers
DBMS client applications need to store SQL query results in local memory or local files. The format is flat and the fields are ordered -- th...
6
24-08-2016 04:40:12 Peter Gulutzan MySQL
What's in the SQL of NoSQL
In a previous post I said it's bogus that NoSQL stands for Not Only SQL, but NoSQL products can have "some" SQL. How much? To get past the S...
34
01-08-2016 04:25:26 Peter Gulutzan MySQL
SQLite and Standard SQL
I'm going to need to use SQLite syntax for a project that I'm involved with, and predictably I wonder: how standard is it? The SQLite folks ...
23
25-06-2016 05:01:49 Peter Gulutzan MySQL


© Jiri Pinkas | this project on GitHub | related: SQL školení | Top Java Blogs | monitored using: sitemonitoring

Top SQL Blogs is a blog aggregator (with English-written blogs only) focused on MySQL, PostgreSQL, MS-SQL and Oracle databases.