SQLitePlus Database Explorer and COM DLL v.1.0

Advertisement
Advertisement

It consists of 3 tools: SQLitePlus Database Explorer, the SQLitePlus COM DLL and the SQLitePlus Grid ActiveX component (free tool). SQLitePlus Explorer is a program for viewing and administering your SQLite databases. The SQLitePlus COM DLL is for use by your programs to easily access SQLite databases programmatically. This COM DLL gives you lightning speed access to SQLite database files from your Windows language of choice - C#, VB6, C++, VB.NET, Delphi, etc. Here is what the sqlite.org website says about SQLite:"SQLite is a small, fast, embeddable SQL database engine that supports most of SQL92, including transactions with atomic commit and rollback, subqueries, compound queries, triggers, and views. A complete database is stored in a single cross-platform disk file."SQLite is written in C and therefore not accessible from many high-level languages. We have created an "ADO-like" wrapper COM DLL for the SQLite C library, making it possible (and easy) to use this powerful SQL database engine from higher level languages, such as Visual Basic, Delphi, C#, etc., but with NO ODBC/OLEDB drivers or ADO required. The SQLitePlus COM DLL and Database Explorer extend the functionality of SQLite to add these important features: * COM DLL, which can be used from almost any high level language * Separate Database Explorer * Stored Scripts (like Stored Procedures) * On-the-fly Encryption and Compression * ADO-like object model * Built-in RegEx function * Ease of useIdeal Access Database Replacement"We are using MS Access & ADO and the overhead is huge. Our installation program can't be downloaded from the web because the DB and components require about 15MB. SQLitePlus solves this and is faster to boot."One of the biggest dilemmas for distributed commercial application developers is, "what database do I use?". If you have ever needed a small, robust and powerful desktop SQL database to ship with your Windows applications, SQLitePlus is the answer you have been looking for.SQLitePlus Database Explorer Use SQLitePlus Database Explorer to view your SQLite databases. You can create/drop/view Tables, Views, Stored Scripts, Triggers, and Indexes, and also perform SQL queries and commands to view and otherwise manipulate your data. The data is displayed in a grid control, allowing you to copy the data to files or other programs. You can open multiple databases at the same time, and open any number of Query windows.SQLitePlus COM DLLThe SQLitePlus COM DLL is a "wrapper" around the SQLite C library. You use this DLL to access SQLite databases from your Windows programs. Since it s a COM DLL, it is usable by most common Windows programming languages (eg. VB, C++, Delphi, .NET languages, etc.). SQLitePlus Admin uses the COM DLL for all of its database access, so you can see just how powerful it is. And best of all, YOU DON'T NEED MDAC or any other database install.Stored ScriptsWe have integrated the Microsoft Scripting Engines - VbScript and JScript - into SQLitePlus. This is an amazing feature that you really should check out (samples included in the download). Click here for more info on Stored Scripts.CSV File featuresMany people today still work with CSV and TAB-delimited files daily. SQLitePlus can easily import and export these files formats directly to/from SQLite database files. This can be done both with the SQLitePlus Database Explorer and with the SQLitePlus COM DLL (the SQLitePlus Database Explorer actually uses the COM DLL's SqliteDb.Import and SqliteDb.Export functions). All file formats are supported:- UTF-8- UTF-16- CodePageWhat this means for you is that you can suck a CSV file into a SQLite database using the Import facility and immediately begin working with it using SQL. Or you can very easily export any data to a CSV/delimited file using the Export facility. No ODBC/OLEDB drivers needed (or wanted)The SQLitePlus object model is very similar to ADO (Microsoft ActiveX Data Objects). But SQLitePlus IS NOT A ODBC/OLEDB DRIVER. There are a couple of good reasons for this: 1) This product is designed for applications that need to store its data in a local database and DO NOT want the overhead of installing ODBC/OLEDB drivers nor requiring ADO to be installed, and 2) SQLite is extensible (things like user-defined C functions), and SQLitePlus will provide a means of allowing higher level programming languages access these "hooks". This could not be done if implemented as an OLEDB database driver. Another good reason is performance: SQLitePlus has very little overhead because it is a very thin wrapper around the SQLite C library.

It consists of 3 tools: SQLitePlus Database ...

database, explorer, databases, access, languages, files, stored, windows, programs, easily, delphi, powerful, level, dll, database explorer

 
  • SQLitePlus Database Explorer and COM DLL
  • 1.0
  • EzTools Software
  • WinXP, Win2003, Win2000, Win Vista, Windows 7
  • Freeware
  • 3.85 Mb
  • 312
  • Free
 
 

Review SQLitePlus Database Explorer and COM DLL

  • captcha
 

Other software of EzTools Software

New Puzzle software
  • Color Bricks  v.1.93Logic game, explosive mix of match-3 and *tris-like games.
  • SudoKoach  v.2.4SudoKoach makes solving Sudoku puzzles more fun. It does the tedious work of figuring which numbers are possible in each unsolved cell, so you can get right to the more enjoyable aspects of solving the puzzle. Helps you learn solving strategies, too!
  • Hangman Pro for the Macintosh  v.4.0.2Hangman Pro is a modern take on the classic hangman word-guessing game. It features colorful, non-violent graphics, digitized sounds, dozens of built-in word categories, thousands of words, unlimited custom lists, timed games and photo fun.
  • Stix (Mac)  v.5.0.1Destroy challenging structures while avoiding alien patrols. But be careful; a single mistake and one of these structures could become your grave.
  • Lucy's Globe  v.3.01Multilingual globe; Game dialogs for states/capitals (like puzzle game) ...
  • Super Stamp  v.1.0Have fun collecting a wide variety of stamps by matching shapes in Super Stamp.