Sql |

Introduzione a SQL Server 2008 Express

Jan 30, 2011 · 4 min read

·

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.

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:

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.

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!

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

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.