PUBLIC MARKS from ms_michel with tag sqlite

Sortie depuis hier, la version 3.6.19 de SQLite gère désormais les clés étrangères, y compris les clauses ON DELETE et ON CASCADE.

Une réécriture de SQLite en C# (totalement indépendante de SQLite)

C# Utility to automatically do the conversion from SQL Server DB to SQLite DB

System.Data.SQLite is an enhanced version of the original SQLite database engine. It is a complete drop-in replacement for the original sqlite3.dll (you can even rename it to sqlite3.dll). It has no linker dependency on the .NET runtime so it can be distributed independently of .NET, yet embedded in the binary is a complete ADO.NET 2.0 provider for full managed development.

Simule les contraintes d'intégrité avec les triggers sous SQLite

SQLite Administrator is a powerful tool if you easily want to create, design or administrate SQLite database files. The SQL code editor helps you to quickly write sql queries with features such as code completion and highlighting. Both major versions of SQLite database files are supported by SQLite Administrator.

Exemples de triggers sous SQLite

base de données SQLite