twit88.com

Other than sqliteadmin, here are some useful open source tools that you can use to administer SQLITE databases. SQLite Studio SQLiteStudio is a SQLite database manager with the following features: Single executable file – no need to install or uninstall. Binary distribution is just the single, ready to use file. Intuitive interface, All SQLite3 and […]

sqlite-manager is an extension for Firefox and other apps to manage any sqlite database. You can manage all your sqlite databases using this lightweight extension for firefox, thunderbird, seamonkey, songbird, komodo etc. (See the complete list of supported applications) This extension will be useful to developers who want to create and play with sqlite databases. […]

SQLite Administrator is a powerful tool if you easily want to create, design or administrate SQLite database files. The SQL code editor helps you to quickly write sql queries with features such as code completion and highlighting. Both major versions of SQLite database files are supported by SQLite Administrator. Create / Modify / Delete Tables […]

ICE combines a columnar database with our Knowledge Grid architecture to deliver a self-managing, self-tuning database optimized for analytics. ICE eliminates the need to create indexes, partition data, or do any manual tuning to achieve fast response for queries and reports. Built on MySQL, ICE lets you load and query large amounts of data easily […]

SQLite Database Browser is a freeware, public domain, open source visual tool used to create, design and edit database files compatible with SQLite. It is meant to be used for users and developers that want to create databases, edit and search data using a familiar spreadsheet-like interface, without the need to learn complicated SQL commands. […]

One of the things that I got when I migrated my C# application from 32 bits machine to 64 bits machine is the driver problem. 1: The ‘OraOLEDB.Oracle’ provider is not registered on the local machine The reason that you could have this problem Your application is running as a 64-bit application and the 64-bit […]

jTDS is an open source 100% pure Java (type 4) JDBC 3.0 driver for Microsoft SQL Server (6.5, 7, 2000, 2005 and 2008) and Sybase (10, 11, 12, 15). jTDS is based on FreeTDS and is currently the fastest production-ready JDBC driver for SQL Server and Sybase. jTDS is 100% JDBC 3.0 compatible, supporting forward-only […]

The Apache Cassandra Project develops a highly scalable second-generation distributed database, bringing together Dynamo’s fully distributed design and Bigtable’s ColumnFamily-based data model. Cassandra was open sourced by Facebook in 2008, and is now developed by Apache committers and contributors from many companies. Cassandra is in use at Digg, Facebook, Twitter, Reddit, Rackspace, Cloudkick, Cisco, SimpleGeo, […]

NoSQL is a fast, portable, relational database management system without arbitrary limits, (other than memory and processor speed) that runs under, and interacts with, the UNIX1 Operating System. It uses the "Operator-Stream Paradigm" described in "Unix Review", March, 1991, page 24, entitled "A 4GL Language". There are a number of "operators" that each perform a […]

I have written on fabFORCE.net DBDesigner – A Handy MySQL Database Designer. However, MySQL has now a better tool, which is a successor to DBDesigner. MySQL Workbench is a visual database design tool that is developed by MySQL. It is the successor application of the DBDesigner4 project. MySQL Workbench is available in two editions, the […]

SQLite2009 Pro Enterprise Manager is a freeware tool that enables you to manage your SQLite3 databases. Features: Blob/Image viewer Built-in FTS3 Extention Built-in LUA Programming Language Encrypted database support Export recordset into excel, csv, xml and html format Import data from Ms Access / MS SQL server Includes SQLite2009 Pro ODBC Driver Includes Additional sqlite3 […]

System.Data.SQLite is the original SQLite database engine and a complete ADO.NET 2.0/3.5 provider all rolled into a single mixed mode assembly.  It is a complete drop-in replacement for the original sqlite3.dll. The provider was written from scratch on VS2005/2008 specifically for ADO.NET 2.0, using all the most recent changes to the ADO.NET framework.  That includes […]

MongoDB is a high-performance, open source, schema-free document-oriented database. MongoDB is written in C++ and offers the following features: Collection oriented storage – easy storage of object-style data Dynamic queries Full index support, including on inner objects Query profiling Replication and fail-over support Efficient storage of binary data including large objects (e.g. videos) Auto-sharding for […]

The Drizzle project is building a database optimized for Cloud and Net applications. It is being designed for massive concurrency on modern multi-cpu/core architecture. The code is originally derived from MySQL. The project is focused on making a database that is:1) Reliable2) Fast and scalable on modern architecture3) Simply design for ease of installation and […]

From Apress at http://www.apress.com/resource/bookfile/1909

This is a common problem often overlooked by Java programmer. Create the following table in your database 1: create table test_table 2: ( 3: field_1 varchar2(10) not null, 4: field_2 varchar2(10) 5: ); 6:  7:  8: insert into test_table values(‘1′,’1’); 9:  10: insert into test_table values(‘2’, null); Do select count(*) from test_table The number of […]

Kexi is a Free/Libre and Open-Source integrated data management application, a long awaited Open Source competitor for products like Microsoft Access. Kexi can be used for creating database schemas, inserting data, performing queries, and processing data. Forms can be created to provide a custom interface to your data. All database objects – tables, queries and […]

Java DB is Sun’s supported distribution of the open source Apache Derby 100% Java technology database. It is fully transactional, secure, easy-to-use, standards-based — SQL, JDBC API, and Java EE — yet small, only 2MB. The Apache Derby project has a strong and growing community that includes developers from large companies such as Sun Microsystems […]

Mnesia is a distributed Database Management System, appropriate for telecommunications applications and other Erlang applications which require continuous operation and soft real-time properties. It is one section of the Open Telecom Platform (OTP), which is a control system platform for building telecommunications applications. From the documentation, The management of data in telecommunications system has many […]

In every application, no matter Java, .NET or PHP, most probably you need to interact with databases. For every domain your application is used for, the database design is definitely different, though basic database design principles are still the same. Every domain requires different database models and unless you are the domain expert, most of […]