TechArena Community

TechArena Community (
-   Software Development (
-   -   Lighter database required (

cobra2008 31-08-2009 11:59 PM

Lighter database required
I want to create a small interface for my office. It will not include a larger entries, just small information about our work and it will be managed (which includes deletion of unwanted data) on regular basis. So I am in search of some lighter database. I don't want to use MYSQL whose maintenance requires and expertise. I even don't want to use Access since because it gets slower with database. Does anyone know some lighter database?

Katty 01-09-2009 12:03 AM

Re: Lighter database required
Oracle Database Lite provides mobile workers the experience of continuous access to data unconstrained by network bandwidth and coverage. It extends the grid environment to mobile devices, allowing mobile workers to access enterprise data even in the absence of a network connection.

Oracle Database Lite 10g is an integrated and complete solution for rapid development and deployment of high-impact applications for mobile environments. Oracle Database Lite provides a small footprint, SQL-enabled client database for local access to enterprise data by applications on the mobile device. In addition, it features the Mobile Server middleware component that supports scalable data synchronization and centralized management of mobile resources. The Mobile Server provides secure, bi-directional data synchronization in addition to providing administrators with tools to remotely manage users, devices and applications.

$tatic 01-09-2009 12:05 AM

Re: Lighter database required
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.

SQLite 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.
  • A complete database is stored in a single cross-platform disk file.
  • Supports terabyte-sized databases and gigabyte-sized strings and blobs.
  • Small code footprint: less than 300KiB fully configured or less than 180KiB with optional features omitted.
  • Faster than popular client/server database engines for most common operations.
  • Simple, easy to use API.
  • Written in ANSI-C. TCL bindings included. Bindings for dozens of other languages available separately.
  • Well-commented source code with 100% branch test coverage.
  • Available as a single ANSI-C source-code file that you can easily drop into another project.
  • Self-contained: no external dependencies.
  • Cross-platform: Unix (Linux and Mac OS X), OS/2, and Windows (Win32 and WinCE) are supported out of the box. Easy to port to other systems.
  • Sources are in the public domain. Use for any purpose.
  • Comes with a standalone command-line interface (CLI) client that can be used to administer SQLite databases.

opaper 01-09-2009 12:10 AM

Re: Lighter database required
SQL Server Compact 3.5 is a free, easy-to-use embedded database engine that lets developers build robust Windows Desktop and mobile applications that run on all Windows platforms including Windows XP, Vista, Pocket PC, and Smartphone. SQL Server Compact Edition addresses the new application development challenges by providing for faster results and increased productivity, better decision making support and a trusted platform.

All times are GMT +5.5. The time now is 03:53 AM.