sqlite
SQLite 2.8.16
SQLite - SQL database connection development library more>>
The distribution comes with a standalonecommand-line access program (sqlite) that can be used to administer anSQLite database and which serves as an example of how to use the SQLitelibrary.
SQLite is not a client library used to connect to a big databaseserver. SQLite is the server. The SQLite library reads and writesdirectly to and from the database files on disk.
SQLite is used by Mac OS X software such as NetNewsWire and SpamSieve.
When you download SQLite and build it on a stock Mac OS X system, thesqlite tool has a very primitive command-line editing facility. Thisbuild of sqlite uses the GNU readline library, which provides fancycommand-line editing (using, e.g. Emacs key bindings) as well as acommand history. Software built using the included libsqlite.a librarydoes not link with readline and thus is not tainted by the GPL.
Enhancements:
- Fix a bug that can lead to database corruption if there are two open connections to the same database and one connection does a VACUUM and the second makes some change to the database.
- Correctly handle quoted names in CREATE INDEX statements.
- Fix a naming conflict between sqlite.h and sqlite3.h.
- Avoid excess heap usage when copying expressions.
- Other minor bug fixes.
SqliteQuery 0.7.2
SqliteQuery - Edit/maintain SQLite databases, create new ones more>>
The main purpose of SqliteQuery is to execute SQL statements and watch the result on SELECT statements in a tableview. Choose which of the typed SQL statement to be executed by selecting or simply execute all if no selection is made.
The SqliteQuery user-interface is separated in four parts.
1. setting the database path (defining a not existing path will create a new database - you will actualy be asked before creating it
2. input of SQL statements
3. showing result of SELECT statements in a tableview
4. showing a log output
Enhancements:
- added menu item for manually checking updates
- added menu item for giving feedback via email
- added menu item for visiting the SqliteQuery website.
SQLite Manager 0.3.12
Firefox add-on that allows you to manage any database you want. more>> Firefox add-on that allows you to manage any database you want.
Manage any SQLite database on your computer. An intuitive heirarchical tree showing database objects. Helpful dialogs to manage tables, indexes, views and triggers. You can browse and search the tables, as well as add, edit and delete the records.
Facility to execute any sql query. A dropdown menu helps with the sql syntax thus making writing sql easier. Easy access to common operations through menu, toolbars, buttons and context-menu.
SQLite Manager allows you to export tables/views in csv or xml format.
SQLite is a small C library that implements a self-contained, embeddable, zero-configuration SQL database engine. An SQLite database is a single ordinary disk file that can be located anywhere in the directory hierarchy. It is likely that most of the storage in Mozilla applications, in near future, will use SQLite.
Note: The SQLite Manager add-on is cross-platform and it works on Mac OS X, Windows and Linux.
Main features:>
- dialogs for creation, deletion of tables, indexes, views and triggers
- ability to rename, copy, reindex tables
- ability to add and drop columns
- create new db, open any existing db, copy an existing db
- a tab for database settings (no need to write the pragma statements) where you can view and change the sqlite library settings
- export tables as csv files
- a dropdown menu showing all profile db (*.sqlite)
- an intuitive hierarchical tree showing all tables, indexes, views and triggers
- ability to browse data from any table
- dialogs to allow searching in a table
- allows editing and deleting selected record while browsing a tables data
- an extensive menu that helps with writing sql by hand and then executing it
- remembers the last used db across sessions
System requirements:
-
Enhancements:
- Issue #178 : Enhance new database to allow creation of in-memory database. Done. To open an in-memory db, go to Database menu -> New In-Memory Database. If the db opens successfully the title displays "in-memory database", in the left sidebar "in-memory" is displayed instead of db name and the statusbar displays "Memory" instead of Shared/Exclusive.
- Issue #180 : alert the user if a file from MRU could not be opened and remove the failed entry from MRU. Fixed.
Mrinal Kant - Firefox add-on that allows you to manage any database you want. SQLite Manager. Firefox add-on that allows you toLicense:Freeware
SQLite Manager for Firefox 0.5.1
SQLite Manager for Firefox 0.5.1 offers you an useful and easy-to-use program which can manage all your sqlite databases using this lightweight extension for firefox, thunderbird, sunbird, seamonkey, songbird, komodo, flock etc. more>> <<less
SQLite Manager for Firefox 0.5.0 Beta 5 provides you with a powerful application which can help you manage all yourLicense:MIT
SQLite Manager for Firefox is an all-in-one and very useful application which can manage all your sqlite databasesLicense:MIT
SQLite Manager for Songbird 0.5.1
SQLite Manager for Songbird 0.5.1 offers you a professional and very useful application which can manage all your sqlite databases using this lightweight extension for firefox, thunderbird, sunbird, seamonkey, songbird, komodo, flock etc. more>> <<less
SQLite Manager for Songbird provides you a powerful and easy-to-use program which can manage all your sqlite databasesLicense:MIT
Songbird add-on that helps you manage your SQLite databases from your computer. SQLite Manager for Songbird 0.3.11 - MrinalLicense:Freeware
SQLite Manager for Thunderbird 0.5.1
SQLite Manager for Thunderbird 0.5.1 is an excellent and extremely useful product which offers you an easy way to manage all your sqlite databases using this lightweight extension for firefox, thunderbird, sunbird, seamonkey, songbird, komodo, flock etc. more>> <<less
SQLite Manager for Thunderbird 0.5.0 Beta 5 offers you an excellent and must-have product which can helpLicense:MIT
SQLite Manager for Thunderbird offers you an all-in-one and very useful application which can manage allLicense:MIT
QuickLite 1.5.6
QuickLite - Cocoa wrapper for SQLite more>>
It provides the developer with a SQL database without running a separate RDBMS process.
QuickLite is not a client library used to connect to a big database server. QuickLite is the server, reading and writing directly to and from the database files on disk.
Main features:
- Updated with SQLite 3.2.2
- Data integrity check provided by SQLite
- Datatype support includes QLString, QLNumber, QLBoolean, QLDateTime, and QLContainer
- Better data caching: CacheAllData, CacheOnDemand, or DoNotCacheData
- QuickEdit: insert, edit, and remove rows without a single SQL statement, the OOP-way
- In-cursor data matching
- Set operations on cursors
- Support for attached databases
- Save and revert supported, database-wide and on a cursor-by-cursor basis
- Distributed notifications, Fast User Switching-aware, sent when a commit action takes place
- Debugging facilities to observe all SQL statements executed, as well as tracing QuickLite methods.
Enhancements:
QuickLiteDatabase
- New: Added a new convenient class method + (NSString*)escapeQuotesFromString:(NSString*)string;
- Modified: Removed the following methods:
- - (NSArray*)columnsForTemporaryTable:(NSString*)table;
- - (NSArray*)indexedColumnsForTemporaryTable:(NSString*)table;
Now theyre merged with the following calls:
- - (NSArray*)columnsForTable:(NSString*)table
- - (NSArray*)datatypesForTable:(NSString*)table
- - (NSArray*)indexedColumnsForTable:(NSString*)table
- - Bug fix: - (BOOL)updateValues:(NSArray*)values forColumns:(NSArray*)columns withRowUID:(NSNumber*)rowUID inTable:(NSString*)table now accepts NSNull as a possible value
QuickLiteCursor
- - Modified: - (NSString*)description display a brief summary of the cursor
- - New: - (NSString*)fullDescription shows a more detailed report about the entire cursor
- - New: - (NSString*)fullDescription:(unsigned long)numberOfRows shows a more detailed report for the first n rows
- - Bug fix: The cursor always registered itself as modified when calling - (BOOL)setValue:(id)value forColumn:(NSString*)tableAndColumn, even though no changes may have occurred.
Other
- - Better error checking
- - More code cleanup.
PyDbLite 2.3
A pure-Python in-memory database engine, using Python list comprehensions as query language, instead of SQL more>>
PyDbLite 2.3 provides you a powerful and very helpful pure-Python in-memory database engine which uses Python list comprehensions as query language, instead of SQL. PyDbLite is a free, open source, small, and fast in-memory database management program.
The database object supports the iterator protocol, so that requests can be expressed with list comprehensions or generator expressions instead of SQL. The module stores data in a cPickled file. Records are indexed by a unique record identifier, that can be used for direct access.
Since operations are processed in memory they are extremely fast, nearly as fast as SQLite in the few tests that were made by the developer. Also, an index can be created on a field to speed up selections.
Enhancements: Bug fixes, name and interface changes to SQLite and MySQL adapters.
TimeSlice 4.4
TimeSlice is a very flexible and effective time-tracking & billing application for consultants, attorneys, graphic and web designers, or anyone who bills for time, or just wants to keep track of time events. more>>
TimeSlice 4.4 is a very flexible and effective time-tracking & billing application for consultants, attorneys, graphic and web designers, or anyone who bills for time, or just wants to keep track of time events. TimeSlice has been helping people track time since 1994, when it was first sold as TimeTracker.
Major Features:
- Ability to automatically track time as you switch between other applications and windows.
- Easy-to-use. Click a button to start tracking, click another to stop.
- Budgets, Statistics, Summary, Invoice and Expense reports.
- Assign categories, clients, projects, tasks, colors, and more.
- All data are stored to a fast-access SQLite database.
- Define Filters to allow displaying only the data of interest.
- iCal and Address Book integration.
- Import TimeSlice iPhone and iPod Touch data.
KeyMaster 1.0
KeyMaster - password storing tool more>>
KeyMaster provides an easy and single place to store all of your passwords for websites, programs, or any other use requiring a password.
KeyMaster also allows you to lock the application so that if you step away for a moment, no one can view your passwords. As an additional security feature, KeyMaster will auto lock itself after 20 minutes of inactivity.
KeyMaster uses SQLite and Blowfish encryption technology so that none of your passwords, usernames and sites are stored on the computer as plain text that can be harvested by hackers or malicous software.
iAuxSQL 1.1.639
iAuxSQL functions as a high-quality cross-platform C++ SQL database API library giving common unified programmer-friendly interface to the popular database engines, such as: MySQL, PostgreSQL, SQLite. more>> <<less
Freaky SQL 2.0a2
Freaky SQL allows the creation, viewing, and modification of REAL SQL Databases more>>
Main features:
- Full Table and Field Schema Modification
- Data Viewing, Querying, and Editing
- Indexing and Encoding Support
- Conversion from the Old Database Format
- Conversion Between Folders and Virtual Volumes
- XML and CSV Import and Export.
Enhancements:
- Fixed some things..... creating RSD databases isnt really a wise idea yet.
- Opens RDB folders now.
- Cant rename stuff..... not supported in SQLite, the workaround is annoying.
WikityWidget 1.1
WikityWidget - A personal wiki. Stickies on steroids more>>
Winner of the first Apple Dashboard Widget Contest:
WikityWidget is a personal notepad with automatic linking. Using a simple notebook-style interface, WikityWidget lets you easily jot down and organize notes with hypertext links so theyre easy to find and instantly available via the Mac OS X Tiger Dashboard. It applies Wiki technology in a new and interesting way on the Mac and demonstrates the powerful potential of widgets to leverage technologies in Tiger.
WikityWidget uses a native code plug-in to create a Javascript bridge to SQLite in Mac OS X Tiger, which ensures reliability, high performance, large capacity, and adds functionality such as Search As You Type. The user interface is rendered using the advanced CSS features of WebKit, and takes advantage of the built-in, high quality, anti-aliased fonts in Tiger. Its strong technical execution, clean interface design and interesting use of Tiger technologies demonstrates the unlimited potential of Dashboard widgets.
LDS iClerk 1.0.02
LDS iClerk is released to be an effective utility which simplifies the tracking of which members have prayed or spoken during Sacrament meeting, and keeps the data in an SQLite database. more>>
LDS iClerk 1.0.02 is released to be an effective utility which simplifies the tracking of which members have prayed or spoken during Sacrament meeting, and keeps the data in an SQLite database. Ward leaders within the Church of Jesus Christ of Latter-Day Saints have a heavy task keeping up with all the individual members of their congregations. Since worship services involve all members, it can become burdensome to keep track of who has participated most recently, and who still needs an opportunity to do so.
