Free select software for linux

This is a small application (using GTK+) which lets you select your window manager. It looks for a file named .selectwmrc in the users directory which contains a list of window managers.

When you start X it should show a list which lets you choose your window manager (by double clicking on it with the mouse or with the arrow keys and the return or space key).

Gentoo Category Select is a graphical tool for selecting Gentoo Package Categories to exclude from your local package repository.

It does so by weaning information from multiple directories and files for convenience, as well as providing warning about categories that should not be excluded due to currently installed packages.

This is achieved without the addition of a configuration file. Currently only the Qt front-end is finished. It is modularly designed for ease in creating front-ends based on other toolkits.

The advantages are saved disk space (small/MMV), quicker rsync time (small/MMV), and a lessening of bandwidth requirements by gentoo.org and its mirrors.

SQLitepp is a C/C++/Python wrapper to sqlite library for database management. It implements an object oriented way to manipulate the database in every supported language.

SQLitepp supports selfupdatable queries and a straight SQL code query system without using strange things for querying the database, letting you manipulate it directly in SQL but also exposing simple object oriented methods to manipulate the result of the queries and updating them.

Python EXAMPLE:

db = SQLDatabase("database.db")
q = db.query("Tablename", "SELECT Name,Id FROM %t")
if len(q):
tuple1 = q[0]
tuple1["Name"] = "Foobar"
tuple1.commit()
del db

C++ EXAMPLE:

SQLDatabase db("database.db");
SQLQuery *q = db.query("Tablename", "SELECT Name,Id FROM %t");
if(q->numberOfTuples()) {
SQLRow *tuple1 = q->getRow(0);
tuple1->set("Name", "Foobar");
tuple1->commit();
}
delete q;

C EXAMPLE:

void *db = new_SQLDatabase("database.db");
void *q = SQLDatabase_query(db, "Tablename", "SELECT Name,Id FROM %t");
if(SQLQuery_numberOfTuples(q)) {
void *tuple1 = SQLQuery_getRow(q, 0);
SQLRow_set(tuple1, "Name", "Foobar");
SQLRow_commit(tuple1);
}
delete_SQLQuery(q);
delete_SQLDatabase(db);

SQLizer is a Java utility library intended for generating sql from the search input.

Synopsis:

import stanford.netdb.utils.*;

String sql_1 = Feild2SQL.parseField(type,table, column, input_str, field_display_name, post_filter);

String sql_2 = Feild2SQL.parseStringField(table, column, input_str, field_display_name);

String sql_3 = Feild2SQL.parseIntField(table, column, line, field_display_name);

Given an input string it builds SQL select statement. It supports two types of inputs, numeric and string. The catch is that this library allows usage of operators in the input string. Supported operators are and, or and not. It also supports wildcards *, %, ? and _ in string searches. In case of numeric searches no wildcards are supported.

To accommodate searches by strings, which have wildcards in them, backslashes can be used to escape appropriate characters. Obviously to search for it needs to be escaped as well. Strings with spaces needs to be enclosed in double quotes. The other possibility is to do a regex search, which is accomplished by enclosing string in forward slashes. The resulting SQL is targeted toward Oracle regex expressions. For example, following input strings will be appropriately evaluated.

a or b
-> ( ( select id from Record where name = a ) UNION ( select id from Record where name = b ) )

not a and not b
-> ( ( select id from Record MINUS ( select id from Record where name = a ) ) INTERSECT ( select id from Record MINUS ( select id from Record where name = b ) ) )

"a b c" or a\*
-> ( ( select id from Record where name = a b c ) UNION ( select id from Record where name LIKE a\% ESCAPE ) )

/^.*[[:digit:]]$/
-> ( select id from Record where REGEXP_LIKE(name, ^.*[[:digit:]]$, i) )

We use unions and intersects in order to accomodate searches for objects with multi-value attributes.