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

Java JDBC Probe

Tired of prepared statement written down on the code? Tired of Hibernate, and willing to come back to crude SQL debugging? No problem, dudes! We tried Elvyx, a  JDBC probe, without a full success. Our quality vote is 5, because … Continue reading
Posted in English Content, Knowledgebase, Software | Tagged , , , , , , , | Comments Off on Java JDBC Probe