Category Archives: Structured Query Language (SQL)

Structured Query Language (SQL) is a standard computer language for relational database management and data manipulation. SQL is used to query, insert, update and modify data

SQLite Tool-set

Posted on June 20, 2022 by Giovanni Giorgi
Random list of very interesting projects (will be updated, guys). I will add my own ideas/impression as soon as possible. From simpler to more complex stuff: sqlite-utils is a rather useful tool for managing SQLite databases, importing structured data and … Continue reading →
Posted in IT Featured, Knowledgebase, Structured Query Language (SQL) | Comments Off on SQLite Tool-set

Simple method to add historic feature to SQLite

Posted on April 9, 2021 by Giovanni Giorgi
Abstract: Make a database which can be store historic modification is often considered a “secondary” activity, but bad design leads to databases that are difficult to optimize and often not very understandable. In this article we illustrate a simple method … Continue reading →
Posted in English Content, IT Featured, Knowledgebase, Structured Query Language (SQL) | Tagged , | Comments Off on Simple method to add historic feature to SQLite

Semplice metodo per storicizzare i dati su database

Posted on March 17, 2021 by Giovanni Giorgi
Abstract: Storicizzare i dati spesso è un attività considerata “secondaria”, ma un cattivo design porta a base dati difficili da ottimizzare e spesso poco comprensibili. In questo articolo illustriamo un semplice metodo che rispetta i dettami della teoria relazionale, è … Continue reading →
Posted in Italian Content, Structured Query Language (SQL) | Tagged , | Comments Off on Semplice metodo per storicizzare i dati su database

Avoid Kafka if unsure (think twice series)

Posted on December 2, 2019 by Giovanni Giorgi
Some co-workers started using Apache Kafka con a bunch of our Customers. Apache Kafka is a community distributed event streaming platform capable of handling trillions of events a day. Initially conceived as a messaging queue, Kafka is based on an … Continue reading →
Posted in English Content, IT Featured, Knowledgebase, Structured Query Language (SQL) | Tagged , , | Comments Off on Avoid Kafka if unsure (think twice series)

SQL: One of the most valuable skills – Craig Kerstiens

Posted on February 20, 2019 by Giovanni Giorgi
I admit it. I suffered from an “algebra narcoleptic syndrome” during my relational database lessons at University (1996 circa). Ok it is a fake. But it seems so real on these days. I was unable to avoid sleeping. I learned … Continue reading →
Posted in English Content, Structured Query Language (SQL) | Tagged , , , | Comments Off on SQL: One of the most valuable skills – Craig Kerstiens

Outer full and inner SQL joins: you are wellcome

Posted on August 27, 2018 by Giovanni Giorgi
For a complete description see https://www.codeproject.com/Articles/33052/Visual-Representation-of-SQL-Joins
Posted in English Content, Structured Query Language (SQL) | Tagged | Comments Off on Outer full and inner SQL joins: you are wellcome

SQLite Oracle Compatibility Layer

Posted on August 7, 2018 by Giovanni Giorgi
  It aims to provide a minimal compatibility with Oracle. The need was having some regular expression functions, and I do not like to work with risky C code, like this university project did Github link: https://gitlab.com/daitangio/sqlite_ora_functions
Posted in English Content, Gio's Software Projects, Projects, Python, Structured Query Language (SQL) | Tagged , , | Comments Off on SQLite Oracle Compatibility Layer