|
Size: 1383
Comment:
|
Size: 1504
Comment:
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 6: | Line 6: |
| URL:: http://www.hwaci.com/sw/sqlite/ | URL:: http://sqlite.org/ |
| Line 14: | Line 14: |
| URL:: http://pysqlite.sourceforge.net/ | URL:: http://pysqlite.org/ |
| Line 16: | Line 16: |
| licence:: Python Licence platforms:: Windows 95/98/2000, POSIX Python versions:: 2.1 - 2.2 |
licence:: zlib/libpng License platforms:: Windows 95/98/2000/XP, POSIX, MacOS X Python versions:: 2.1 - 2.4 (1.x branch)/2.3 - 2.4 (2.0 branch) |
| Line 24: | Line 24: |
| * autocommit mode | |
| Line 42: | Line 43: |
| * Roundup * PyPI * Trac |
|
| Line 48: | Line 53: |
| * it dosn't put all data in memory like gadflay does | * it dosn't put all data in memory like gadflay does (yet you can do that if you want, just use ':memory:' as filename |
| Line 50: | Line 55: |
(Comment by Dirk Holtwick, holtwick at spirito.de) |
* Implements almost all of SQL92 |
| Line 55: | Line 59: |
| * Only a small subset of SQL. * Untyped! |
* Untyped! (this is also a feature) |
Masthead
- URL
- licence
- Sources are uncopyrighted. Use for any purpose.
- platforms
- Built and tested under Linux and Win2K.
DB API 2.0 Drivers
PySQLite
- URL
- SourceForge
- licence
- zlib/libpng License
- platforms
- Windows 95/98/2000/XP, POSIX, MacOS X
- Python versions
- 2.1 - 2.4 (1.x branch)/2.3 - 2.4 (2.0 branch)
Extensions to DB API
- Support for Unicode conversion
- Due to SQLite being an embedded database, it's possible to write SQL functions and aggregates in Python
- autocommit mode
Comments
Other Drivers
driver name
- URL
- licence
- platforms
- Python versions
Programming Model
Comments
Supported Python Applications
- Roundup
- PyPI
- Trac
Pros
I think SQLite may be a good replacement for gadfly, because:
- the main engine is written in C, so it should be faster than the gadfly implementation in Python
- it's extensible in a very easy way via Python
- it dosn't put all data in memory like gadflay does (yet you can do that if you want, just use ':memory:' as filename
- It's very cool for small databased application, because you do not have to start an external DBMS
- Implements almost all of SQL92
Cons
- Untyped! (this is also a feature)