Sql |

dapper-dot-net - Simple SQL object mapper for SQL Server - Google Project Hosting

May 15, 2011 · 1 min read

·

Dapper is a single file you can drop in to your project that will extend your IDbConnection interface. [...]
A key feature of Dapper is performance. The following metrics show how long it takes to execute 500 SELECT statements against a DB and map the data returned to objects.

Read More

NoSQL Rocks? We try to understand

Apr 10, 2011 · 4 min read

en featured knowledgebase sql · ideas nosql sql

·

Share on:

At Gioorgi.com we was never a SQL fan. In 2000 we thinked SQL was boring, mostly because sql algebra could be a bit boring. Then we found this book written by one of the father of SQL. Years ago Google and then Facebook popped out with new incredible ideas, for improved and super fast scalability, which eventually turned to the “NoSQL” mantra.

But NoSQL is a mature technology, or it is only a path traced by the Social company out of there? Let’s explore together…

SQL Server e Python

Feb 17, 2011 · 1 min read

it python sql · python sql sqlserver

·

Share on:

L’integrazione tra .NET e SQL Server è data per scontata: in questo articolo esploreremo invece come accedere a SQL Server da Python. Uno dei vantaggi di python è che è un linguaggio molto facile da imparare, con un notevole numero di librerie e un’ottima integrazione multi piattaforma. Oltre a ciò python offre un sistema di installazione rapido delle librerie (come Ruby e Perl).

SQL Server: meta programmazione e meta descrittori

Feb 6, 2011 · 2 min read

it sql · c sql sqlserver

·

Share on:

In questo articolo della serie SQL Server, vedremo come creare in modo dinamico delle istruzione per impostare delle policy di sicurezza. Creeremo da zero una stored procedure chiamata sp_FixOverallGrant che in modo dinamico imposterà i profili di sicurezza per due utenze, una in lettura e scrittura (EBRB0_APP) ed una in sola lettura (EBRB0_USR).

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: