Tag Archives: database

Il database con due tabelle

Posted on August 12, 2022 by Giovanni Giorgi
In questo articolo del 2012, si legge che Reddit avrebbe un database da due tabelle. Le due tabelle si chiamano “Cose” e “Dati” (i.e. attributi delle cose). “Cose” contiene una riga per ogni oggetto del sistema (utenti, forum, ecc) e … Continue reading →
Posted in Italian Content, Software | Tagged , | Leave a comment

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

Smart Sync

Posted on March 22, 2021 by Giovanni Giorgi
On 2002, I was forced to build a small java class to “sync” two databases (sorry for Italian): SmartSync used the Metadata offered by JDBC API to be able to copy data between two tables. In the last years I … Continue reading →
Posted in English Content, Gio's Software Projects | Tagged , , , | Comments Off on Smart Sync

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

Windows x64: 32bit Odbc vs 64bit Odbc

Posted on November 10, 2011 by Giovanni Giorgi
I run into a very big trouble on these days. My big company delivered to me a Windows7 64bit system (first error) I asked for Office 64 bit and Visio2007 32 bit I tried to connect to Oracle (second error) … Continue reading →
Posted in English Content, Knowledgebase | Tagged , , , | Comments Off on Windows x64: 32bit Odbc vs 64bit Odbc

Introduzione a SQL Server 2008 Express

Posted on January 31, 2011 by Giovanni Giorgi
In questo articolo parleremo di Microsoft SQL Server. SQL Server nasce inizialmente da uno sforzo congiunto di Microsoft, Sybase and Ashton-Tate che nel 1989 creano tale prodotto avente come target OS/2. Dopo alcune vicessitudini Microsoft si smarca da Sybase e SQL Server … Continue reading →
Posted in IT Featured, Italian Content, Structured Query Language (SQL) | Tagged , , , | Comments Off on Introduzione a SQL Server 2008 Express

H2 Database Engine

Posted on April 9, 2009 by Giovanni Giorgi
The creator of HSQL has created a new Java database called H2. We have tried it!
Posted in English Content, Knowledgebase, Structured Query Language (SQL) | Tagged , , | Comments Off on H2 Database Engine