See this page for a comprehensive (and very honest) assessment of the pros and cons of SQLite - in your use case, I would pay particular attention to the Education and Training section. 2MB (yes, MB, not GB!) and is probably better (for teaching purposes), and certainly more standards compliant, than MySQL. Richard Hipp is always up front about how he models copies PostgreSQL syntax. įrom here, SQLite is the "Protégé of PostgreSQL" - its primary developer, D. SQLite database files are commonly used asĬontainers to transfer rich content between systems 1 3 and asĪ long-term archival format for data. The SQLite file format is stable, cross-platform, and backwardsĬompatible and the developers pledge to keep it that way through at Into all mobile phones and most computers and comes bundled insideĬountless other applications that people use every day. SQLite is the most used database engine in the world.
Self-contained, high-reliability, full-featured, SQL database engine. SQLite is a C-language library that implements a small, fast, There are a number of videos from the creator of SQLite on YouTube!
I will give them credit for having become better in recent years.Ģ) For portability, you can use SQLite - it's a rock solid, very standards compliant database which will run off a memory stick. 1) For teaching and testing purposes I would like to run MySQL without actually having to install it.Ģ) Is there a portable app for OS X and for Windows which will do the job?ġ) For teaching and testing MySQL's relationship with the ISO SQL standard has always been, err., problematic.
0 kommentar(er)
