Search
Translate / Traduci
-
Available even in U.S.A. Support Gioorgi Editorial Board
Facet
February 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 Gioorgi EverGreen
Tag Archives: database
Il database con due tabelle
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
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
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 database, mssqlserver, oracle, sqlite
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 database, oracle
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 database, I-hate-64-bit, oracle, visio
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 c#, database, history, sqlserver
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 database, java, jug
Comments Off on H2 Database Engine