|
Size: 1357
Comment:
|
Size: 1454
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 18: | Line 18: |
| Python versions:: 2.1 - 2.2 | Python versions:: 2.1 - 2.3 |
| Line 24: | Line 24: |
| * autocommit mode | |
| Line 42: | Line 43: |
| * Roundup * PyPI |
|
| Line 48: | Line 52: |
| * 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 |
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
- Python Licence
- platforms
- Windows 95/98/2000, POSIX
- Python versions
- 2.1 - 2.3
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
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)