Tag Archives: database

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 , | Comments Off on Simple method to add historic feature to SQLite

Smart Sync

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

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

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

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

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