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
Tag Archives: sql
I big data sono passati di moda?
Questo articolo, di tal Jordan Tigani, getta una luce oscura sul futuro dei big data. E’ scritto dal CEO di un’azienda che sviluppa un nuovo database OLAP (Online analytical processing) chiamato Duckdb, che e’ open source ed e’ “embedded”, nel … Continue reading
Posted in Italian Content, Lettere a mia figlia
Tagged bigdata, duckdb, nosql, sql, sqlite
Leave a comment
SQLite, again (updated)
SQLite is slowing becoming a new standard. It is fast, and has a growing number of features. Useful settings PRAGMA journal_mode = wal; PRAGMA foreign_keys = true; Query, set, or clear the enforcement of foreign key constraints. PRAGMA busy_timeout=….; In milliseconds, … Continue reading
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
Removing duplicate rows in PostgreSQL, Oracle and SQLite
Sometimes you need to remove nasty duplicate on a table, based on a subset of the column. On every big database there is something called “rowid” which can be used to indentify a column in a unique way. On PostgreSQL … Continue reading
Posted in English Content, Knowledgebase, Structured Query Language (SQL)
Tagged dup, duplicate, duplicates, evil, oracle, postgresql, removal, sql
Comments Off on Removing duplicate rows in PostgreSQL, Oracle and SQLite
Oracle SQL Developer Keep Alive plugin
On some environment, on some customers, Oracle connections are drop after some idle time (i.e. 2 minutes). I have found a small plugin for Sql Developer to solve this issue: it is very handy and logs its usage. Code is also … Continue reading
Posted in English Content, Gio's Software Projects, Knowledgebase, Software, Structured Query Language (SQL)
Tagged oracle, plugin, sql, sqldeveloper
Comments Off on Oracle SQL Developer Keep Alive plugin