Free c api mysql software for linux

Memcache Engine for MySQL project allows memcache to work as a storage engine to MySQL.
This means that you can SELECT/UPDATE/ INSERTE/DELETE from it as though it is a table in MySQL. This is very experimental.
This is still very experimental.
Memcached is a high-performance, distributed memory object caching system, generic in nature, but intended for use in speeding up dynamic web applications by alleviating database load.
Enhancements:
- Support for discovery of tables was added.
- Row level locks were implemented.
- A major bug in duplicate keys was fixed, along with phantom rows for updates.
- The server status has been updated.

MaxDB is a heavy-duty, SAP-certified open source database for OLTP and OLAP usage which offers high reliability, availability, scalability and a very comprehensive feature set. MaxDB by MySQL is targetted for large mySAP Business Suite environments and other applications that require maximum enterprise-level database functionality and complements the MySQL database server.
Today, about 6,000 customer installations are using MaxDB technology globally, including Toyota, Intel, DaimlerChrysler, Braun-Gillette, Bayer, Colgate, Yamaha, and Deutsche Post (the German Post Office).
Enhancements:
- Bugs were fixed.

Qt MySQL Budget project is a GUI that allows the creation of a personal budget.

The basic layout is a month selector, a tab for your allocations (budget), a tab for your expenses, and a tab showing the totals.

It has a very simple design allowing the quick creation and updating of budgets to help individuals plot and track their monthly sending.

DBD::mysql is a Perl module with MySQL driver for the Perl5 Database Interface (DBI).

SYNOPSIS

use DBI;

$dsn = "DBI:mysql:database=$database;host=$hostname;port=$port";

$dbh = DBI->connect($dsn, $user, $password);


$drh = DBI->install_driver("mysql");
@databases = DBI->data_sources("mysql");
or
@databases = DBI->data_sources("mysql",
{"host" => $host, "port" => $port});

$sth = $dbh->prepare("SELECT * FROM foo WHERE bla");
or
$sth = $dbh->prepare("LISTFIELDS $table");
or
$sth = $dbh->prepare("LISTINDEX $table $index");
$sth->execute;
$numRows = $sth->rows;
$numFields = $sth->{NUM_OF_FIELDS};
$sth->finish;

$rc = $drh->func(createdb, $database, $host, $user, $password, admin);
$rc = $drh->func(dropdb, $database, $host, $user, $password, admin);
$rc = $drh->func(shutdown, $host, $user, $password, admin);
$rc = $drh->func(reload, $host, $user, $password, admin);

$rc = $dbh->func(createdb, $database, admin);
$rc = $dbh->func(dropdb, $database, admin);
$rc = $dbh->func(shutdown, admin);
$rc = $dbh->func(reload, admin);

EXAMPLE

#!/usr/bin/perl

use strict;
use DBI();

# Connect to the database.
my $dbh = DBI->connect("DBI:mysql:database=test;host=localhost",
"joe", "joes password",
{RaiseError => 1});

# Drop table foo. This may fail, if foo doesnt exist.
# Thus we put an eval around it.
eval { $dbh->do("DROP TABLE foo") };
print "Dropping foo failed: $@n" if $@;

# Create a new table foo. This must not fail, thus we dont
# catch errors.
$dbh->do("CREATE TABLE foo (id INTEGER, name VARCHAR(20))");

# INSERT some data into foo. We are using $dbh->quote() for
# quoting the name.
$dbh->do("INSERT INTO foo VALUES (1, " . $dbh->quote("Tim") . ")");

# Same thing, but using placeholders
$dbh->do("INSERT INTO foo VALUES (?, ?)", undef, 2, "Jochen");

# Now retrieve data from the table.
my $sth = $dbh->prepare("SELECT * FROM foo");
$sth->execute();
while (my $ref = $sth->fetchrow_hashref()) {
print "Found a row: id = $ref->{id}, name = $ref->{name}n";
}
$sth->finish();

# Disconnect from the database.
$dbh->disconnect();

DBD::mysql is the Perl5 Database Interface driver for the MySQL database. In other words: DBD::mysql is an interface between the Perl programming language and the MySQL programming API that comes with the MySQL relational database management system. Most functions provided by this programming API are supported. Some rarely used functions are missing, mainly because noone ever requested them.

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)

MySQL wrapped is a C++ wrapper for the MySQL database C application programming interface.
Examples:
The following example should be linked with the mysqlclient library from the MySQL distribution / build.
#include
#include
#include
#include
#include "Database.h"
#include "Query.h"
int main()
{
Database db("localhost","dbuser","","testdb");
Query q(db);
q.execute("delete from user");
q.execute("insert into user values(1,First Person)");
q.execute("insert into user values(2,Another Person)");
q.get_result("select num,name from user");
while (q.fetch_row())
{
long num = q.getval();
std::string name = q.getstr();
printf("User#%ld: %sn", num, name.c_str() );
}
q.free_result();
}
Enhancements:
- This release adds methods to access fields by name.

Wikipedia API is a simple API to embed Wikipedia content dynamically on a Web site.

Wikipedia is an online encyclopedia in which the user community is encouraged to submit information for its entries. Wikipedia is unique in that it is free to the public, the content is fairly well moderated, and its content is licensed under the GFDL (GNU Free Documentation License); therefore, all of its text can be copied, modified, and used any way you see fit.

The only stipulation to using its text, is that the names of the original authors must remain intact. KillerTux.com is currently embedding some of the relevant entries in its own site and has decided to make the API open for public use. It is a simple implementation and should be easy to use. If you are a webmaster and would like to use KillerTux.coms Wikipedia API, this is the place to learn how to do it.

What is an API

An API is an application programming interface with which external applications can communicate with. The syntax and usage of the API dictates the type of data, format, and other specifics of the information to be exchanged. In this case, the API is a simple call to KillerTux.coms web server via the HTTP protocol.

Wikipedia API usage

The URL for the API is "http://scrapers.killertux.com/wikipedia-api.php". It uses the get request method and only has 3 parameters. These parameters are as follows:

wikititle=
wikiformat=[html | text]
wikiimages=[yes | no ]

The wikititle value is the name of the Wikipedia entry you are looking for, in Wikipedias variable entry. This can be found by going to Wikipedia.org and finding an entry. The name is the last part of the URL. For instance, the Wikipedia entry for "Computer Program" is "http://en.wikipedia.org/wiki/Computer_Program". Notice the space is an underscore in the URL. Defining the wikititle value for this API would look like this: wikititle=Computer_Program. This value must be specified. A sample API call would be "http://scrapers.killertux.com/wikipedia-api.php?wikititle=Computer_Program". The wikiformat value currently has two possible values: html and text. html is the default if no value is specified. If you use HTML format, it is recommended that a style sheet be used, although it may not be necessary.

A sample CSS is provided here. The text format option strips all HTML code from the document and returns plain text formatted at 80 characters per column. A sample API call would be "http://scrapers.killertux.com/wikipedia-api.php?wikititle=Computer_Program&wikiformat=html". The wikiimages value is only valid for HTML format; images for the text format are disabled. Image source locations are preserved and images are loaded from Wikipedia, not KillerTux.com. If wikiimages=no is selected, all images and captions will be striped from the document, while other HTML code should remain intact such as links to other articles. A sample API call would be "http://scrapers.killertux.com/wikipedia-api.php?wikititle=Computer_Program&wikiimages=no".

MySQLfs is Linux userspace filesystem which stores data in a MySQL database. The project uses FUSE to interface with the kernel.