"This article explores the power and simplicity of sqlite3, starting with common commands and triggers. It then covers the attach statement with the union operation, introduced in a way that allows multiple tables, in separate databases, to be combined as one virtual table, without the overhead of copying or moving data. Next, I demonstrate the simple sign function and the amazingly powerful trick of using this function in SQL select statements to solve complex queries with a single pass through the data, after making a brief mathematical case for how the sign function defines the absolute value and IF conditions. "
"SQLite http://www.sqlite.org is a small, easy-to-use, open-source SQL database engine. SQLite for Excel is a lightweight wrapper to give access to the SQLite3 library from VBA. It provides a high-performance path to the SQLite3 API functions, preserving the semantics of the SQLite3 library calls and allowing access to the distributed SQLite3.dll without recompilation."
Lita is a SQLite database administration tool developed using Adobe AIR
Article describing the use of SQLite with Adobe AIR
"You found it! The quick and dirty guide to setting up SQLite with .Net in 3 minutes. Small, fast, and ass-kicking like a transactional Jackie Chan. At least that’s what this campy image created just for this post says."
William J. Francis walks Android developers through a SQLite tutorial on how to implement a no-frills contacts browser.
Working with the SQLite dll file
Howto guide on working with sqlite3.dll
" The SQLite Database Engine provides a lightweight C library to access database files using a large subset of SQL92 without the overhead of RDBMS server processes. In order to use that functionality as a desktop database I wrapped the SQLite library into an ODBC driver.
So far it has been tested with SQLite 2.8.17 and SQLite 3.8.0.2 on Windows NT/2000 in MS Excel 97 (MSQUERY) with SQLite database files created on Linux. Support for Win64 exists for both SQLite 2.x and SQLite 3.x versions of the driver, but this has been only partially tested. It also runs on Linux with unixODBC 2.[0-2].x and with libiodbc 3.[05].x.
Another recent experimental project is a Java binding for the SQLite database engine, which can be found here. "
"Most SQL database engines (every SQL database engine other than SQLite, as far as we know) uses static, rigid typing. With static typing, the datatype of a value is determined by its container - the particular column in which the value is stored.
SQLite uses a more general dynamic type system. In SQLite, the datatype of a value is associated with the value itself, not with its container. The dynamic type system of SQLite is backwards compatible with the more common static type systems of other database engines in the sense that SQL statements that work on statically typed databases should work the same way in SQLite. However, the dynamic typing in SQLite allows it to do things which are not possible in traditional rigidly typed databases."
"This Tutorial should guide you through the steps to connect OpenOffice to a SQLite database file. "
17 items | 3 visits
SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. SQLite is the most widely deployed SQL database engine in the world. The source code for SQLite is in the public domain.
Updated on Mar 15, 17
Created on Dec 31, 11
Category: Computers & Internet
URL:
