Sql |

Introduzione a SQL Server 2008 Express

Jan 30, 2011 · 4 min read
featured it sql · c database sqlserver
·
Share on:

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 versione 6.0 è la prima versione per Windows NT che non ha più dipendenze di copyright da Sybase.

Read More
SQLite alter table

Jul 25, 2010 · 1 min read
it sql · cute embedded programming small smart sql sqlite
·
Share on:
SQLite is a small, powerful embedded database. A friend of mine started using it about six years ago. Some years ago it comes also on top of Python 2.5. It is used inside
- FileMaker Bento: its ultra customized model is based on a big sqllite db
- DropBox client, to store its internal state
- iPhone: stores your SMS and also other stuff. It is widely used by apps.
- Apple Safari uses it for HTML5 storage support
- Google Gears uses it
- ...and in a lot of embedded product.
I was annoyed because until version 3.1.3 SQLite did not provide an alter table syntax but… it is quite easy to emulate it with something like this, even if it required a bit of work:

Read More
MySQL Installing MySQL on Mac OS X

Oct 26, 2009 · 1 min read
knowledgebase sql · mysql
·
Share on:

If you're trying to use MySQL with phpMyAdmin, you've set up the phpMyAdmin's config.inc.php, and you're getting an error saying "Client does not support authentication protocol requested by server; consider upgrading MySQL client", you need to set the password on the mysql command line using the OLD_PASSWORD('password') routine.
For example:

Read More
The destiny of MySQL?

Apr 21, 2009 · 1 min read
en software sql · mysql news opensource
·
Share on:

Slashdot underlines there are too much forks of MySQL on the way.

Read More
H2 Database Engine

Apr 9, 2009 · 2 min read
en knowledgebase sql · database java jug
·
Share on:

The creator of HSQL has created a new Java database called H2. We have tried it!

Read More
Storia dei database

Dec 17, 2008 · 3 min read
it software sql · formazione
·
Share on:

NB: Questo è la storia super rapida dei database relazionali, e non è ancora completata. L’idea è di confrontare la storia del modello E-R con quello dello sviluppo OOP, evidenziando simmetrie e differenze

Read More
Postgres performance tuning

Apr 3, 2008 · 1 min read
blog-objectsrootcom en knowledgebase software sql · database postgresql sql
·
Share on:

After a bit of work, I have managed to optimize the performance of my Postgresql Server.

Read More
- 1
- 2
- 3

Introduzione a SQL Server 2008 Express

SQLite alter table

MySQL Installing MySQL on Mac OS X

The destiny of MySQL?

H2 Database Engine

Storia dei database

Postgres performance tuning