Free sqlite 3.3.x c api. software for linux

SQLiteJDBC is a JDBC driver for SQLite which is written as a Java JNI layer over the SQLite 3.3.x API.

SQLiteJDBC supports the most commonly used features of JDBC that can be efficiently implemented on top of SQLite. Only a single native JNI library is required, and SQLite is compiled in.

Binaries are provided for Linux, Mac OS X, and Windows.

SQLite is a small C library that implements a self-contained, embeddable, zero-configuration SQL database engine.
Main features:
- Transactions are atomic, consistent, isolated, and durable (ACID) even after system crashes and power failures.
- Zero-configuration - no setup or administration needed.
- Implements most of SQL92. (Features not supported)
- A complete database is stored in a single disk file.
- Database files can be freely shared between machines with different byte orders.
- Supports databases up to 2 terabytes (241 bytes) in size.
- Sizes of strings and BLOBs limited only by available memory.
- Small code footprint: less than 30K lines of C code, less than 250KB code space (gcc on 486)
- Faster than popular client/server database engines for most common operations.
- Simple, easy to use API.
- TCL bindings included. Bindings for many other languages available separately.
- Well-commented source code with over 95% test coverage.
- Self-contained: no external dependencies.
- Sources are in the public domain. Use for any purpose.
The SQLite distribution comes with a standalone command-line access program (sqlite) that can be used to administer an SQLite database and which serves as an example of how to use the SQLite library.
Create A New Database:
- At a shell or DOS prompt, enter: "sqlite3 test.db". This will create a new database named "test.db". (You can use a different name if you like.)
- Enter SQL commands at the prompt to create and populate the new database.
Write Programs That Use SQLite
Below is a simple TCL program that demonstrates how to use the TCL interface to SQLite. The program executes the SQL statements given as the second argument on the database defined by the first argument. The commands to watch for are the sqlite3 command on line 7 which opens an SQLite database and creates a new TCL command named "db" to access that database, the invocation of the db command on line 8 to execute SQL commands against the database, and the closing of the database connection on the last line of the script.
#!/usr/bin/tclsh
if {$argc!=2} {
puts stderr "Usage: %s DATABASE SQL-STATEMENT"
exit 1
}
load /usr/lib/tclsqlite3.so Sqlite3
sqlite3 db [lindex $argv 0]
db eval [lindex $argv 1] x {
foreach v $x(*) {
puts "$v = $x($v)"
}
puts ""
}
db close

WebService::Geograph::API is a Perl interface to the Geograph.co.uk API.

SYNOPSIS

use WebService::Geograph::API;

my $api = new WebService::Geograph::API ( { key => your_api_key_here} ) ;

my $rv = $api->lookup ( csv, { i => 12345,
ll => 1,
thumb => 1,
}) ;

my $data = $rd->{results} ;

This module provides a simple interface to using the geograph.co.uk API service.

The actual core class, WebService::Geograph::API is a subclass of LWP::UserAgent so all the usual parameters apply.

Amazon API Search is the beginnings of a perl script to search Amazon.

It interfaces with Amazons API interface and performs whatever search the user desires, it then parses the data returned and inserts it in to an MySQL table.

Currently the script only deals with basic returned data, and does not have a user interface. In future releases I hope to correct this.

The script is certainly worth a look for anyone interested in using Amazons API interface.

WWW::Facebook::API::REST::Client::Events is a Perl module with events for Client.

SYNOPSIS

use WWW::Facebook::API::REST::Client;

Methods for accessing events with WWW::Facebook::API::REST::Client

SUBROUTINES/METHODS

base

The WWW::Facebook::API::REST::Client::Base object to use to make calls to the REST server

get_in_window

The events.getInWindow method of the Facebook API

DIAGNOSTICS

This module is used by WWW::Facebook::API::REST::Client and right now does not have any unique error messages.

FEAR::API is a tool that helps reduce the time you spend creating site scraping scripts and helps you do it in a much more elegant way.
FEAR::API combines many strong and powerful features from various CPAN modules, such as LWP::UserAgent, Template::Extract, WWW::Mechanize, Encode, HTML::Parser, etc.
Enhancements:
- This release adds allow_domains() and deny_domains().

Clickatell SMS API provides a tool for sending SMS messages using the Clickatell gateway.
It provides support to authenticate to this service and query for the current account balance.
This class use the fopen or CURL module to communicate with the gateway via HTTP/S.
Enhancements:
- Fixed bug in function encode_message (tnx Neil)