Tuning a SQL query is a mix of data driven discovery and magic art, until now… Aiven SQL query optimizer allows you to speed up your query by simply pasting the SQL and additional metadata information. Check it out at https://go.aiven.io/ft…
Since the beginning of my journey into the data world I’ve been keen on making professionals better at their data job. In the previous years that took the shape of creating materials in several different forms that could help people underst…
Testing a database performance is a must in every company. Despite everyone’s needs beings slightly different, a good starting point for PostgreSQL® database is using pgbench: a tool shipped with the PostgreSQL installation that allows you
Some time ago I found an interesting database file suffix I never faced before: the .dbf and saw around that it was first introduced in 1983 with dBASE II. This article showcases how we can automatically generate the PostgreSQL table and fi…
Everyone is now talking about AI, and modern databases like PostgreSQL® are increasingly being adopted in companies’ AI journey as sources of data or key pieces of the AI infrastructure. Moreover there’s a new set projects that are solving
A boolean value should only contain two values, True or False, but is it correct? Usually people assume so, but sometimes miss the fact that there could be the absence of the value all-together. In databases this is absence is usually store…
One of the most common tasks with strings is concatenation! This blog post showcases several techniques to perform it with MySQL. Let’s take a basic example: a table containing firstname and surname fields we want to concatenate: We can con…
Last week the good old Gunnar Morling launched an interesting challenge about ordering 1 billion rows in Java. Like my ex colleague and friend Robin Moffat, I’m not at all a Java expert, and while Robin used DuckDB to solve the challenge, I…
You can tabulate a JSON document (retrieve it as a row) in MySQL with the JSON_TABLE function. NOTE: more info is available in the MySQL JSON functions documentation page It can be recreated with the following script: To retrieve one or mor…
You can insert a field in a JSON document in MySQL with the JSON_INSERT function. NOTE: more info is available in the MySQL JSON functions documentation page It can be recreated with the following script: To insert a field in a JSON documen…
You can merge two JSON documents in MySQL with: NOTE: more info is available in the MySQL JSON functions documentation page It can be recreated with the following script: To merge two (or more) JSON documents, by concatenating all the key v…
You can create a JSON document from fields in Mysql® with the JSON_OBJECT function NOTE: more info is available in the MySQL JSON functions documentation page It can be recreated with the following script: To create a JSON document, from a