Search
Translate / Traduci
-
Available even in U.S.A. Support Gioorgi Editorial Board
June 2023 M T W T F S S 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 Gioorgi EverGreen
Category Archives: Structured Query Language (SQL)
SQLite Tool-set
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
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 database, sqlite
Comments Off on Simple method to add historic feature to SQLite
Semplice metodo per storicizzare i dati su database
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 database, oracle
Comments Off on Semplice metodo per storicizzare i dati su database
Avoid Kafka if unsure (think twice series)
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 java, kafka, nosql
Comments Off on Avoid Kafka if unsure (think twice series)
SQL: One of the most valuable skills – Craig Kerstiens
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 postgresql, skill, sql, sqlite
Comments Off on SQL: One of the most valuable skills – Craig Kerstiens
Outer full and inner SQL joins: you are wellcome
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 sql
Comments Off on Outer full and inner SQL joins: you are wellcome
SQLite Oracle Compatibility Layer
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 oracle, sql, sqlite
Comments Off on SQLite Oracle Compatibility Layer