sqlite tool
SQLite Expert Personal 2.2.8
SQLite Expert Personal is a powerful visual tool that enables you to easily administer your SQLite3 databases and gain significantly better visibility into how your databases are operating. more>>
SQLite Expert Personal is a powerful visual tool that enables you to easily administer your SQLite3 databases and gain significantly better visibility into how your databases are operating. SQLite Expert integrates database management and maintenance into a single, seamless environment, with a clear and intuitive graphical user interface.
By using SQLite Expert you will be able to:
- Edit tables and views visually, without writing a line of SQL. Easily restructure fields, indexes without losing data already existing in the tables.
- Create SQLite3 databases, view and change database parameters, check database integrity and vacuum (compact) databases.
- Display and edit data in the grid, including BLOB and image fields. Currently supports BMP, JPG and PNG image formats. BLOB fields can be edited with the integrated hex editor.
- Execute SQL queries and display results in the grid or as text.<<less
SQLite Expert Personal is a powerful visual tool that enables you ... By using SQLite Expert you will be able to: - Edit tables and views visually, without writing aLicense:Freeware
SQLite Expert Personal is a powerful visual tool that enables ... By using SQLite Expert you will be able to: - Edit tables and views visually, without writing aLicense:Freeware
License:Freeware
SQLite Expert Personal is a powerful visual tool that enables ... By using SQLite Expert you will be able to: * Edit tables and views visually, without writing aLicense:Freeware
Bogdan Ureche - SQLite Expert Personal is a powerful visual tool that enablesLicense:Freeware
SQLite Expert integrates database management and maintenance into a single, seamlessLicense:Freeware
Bogdan Ureche - youLicense:Freeware
License:Freeware
SQLiteSpy 1.8.1
A fast and compact GUI database manager for SQLite more>> A fast and compact GUI database manager for SQLite
SQLiteSpy was designed to be a fast and compact GUI database manager for SQLite. It reads SQLite3 files and executes SQL against them. Its graphical user interface makes it very easy to explore, analyze, and manipulate SQLite3 databases.
Main features:
- Database at a Glance ? The schema treeview displays all items contained in a database, including tables, columns, indexes and triggers. Press F5 to update the schema tree, double-click a table or view to display its data, use the context menu for frequently used commands.
- Grid Cell Editing ? Table cells are editable in the grid: Display a table via the schema treeview, select a cell and press F2 to invoke the editor. Then modify and confirm to write your changes back to the table.
- Data Type Display ? The native SQL data types are displayed with different background colors to help detect type errors. Type errors can cause performance degradation or wrong SELECT result sets if NULL values are confused with empty strings.
- Full Unicode ? SQLiteSpy fully supports SQLites Unicode capabilities. Data display and entry is completely realized as Unicode, including SQL commands.
- Multiple SQL Edits ?Modern tabs are used to edit and display multiple SQL queries for easy comparison of query statements and results. SQL queries are executed by typing or loading them into the SQL edit. Then press F9 to run the query, or CTRL+F9 to run the current line or selection only.
- Time Measurement ? SQL execution time is automatically measured and displayed to help optimize queries.
- Regular Expressions ? The SQL keyword REGEXP is supported and adds the complete regular expression syntax of Perl 5.10 to SQLiteSpy. The implementation was realized using the DIRegEx library.
- Mathematical SQL Functions ? The following mathematical SQL functions are available in addition to the SQLite default: ACOS(), ASIN(), ATAN(), ATAN(), ATAN2(), CEIL(), CEILING(), COS(), COT(), DEGREES(), EXP(), FLOOR(), LN(), LOG(), LOG(), LOG2(), LOG10(), MOD(), PI(), POW(), RADIANS(), SIGN(), SIN(), SQRT(), TAN(), TRUNCATE().
- Data Compression ? The SQL functions COMPRESS() applies zlibs deflate to any text or BLOB value. The raw deflate data stream is returned. UNCOMPRESS() inflates this stream back to the original. Integers, Doubles, and Nulls are returned unchanged.
- Compact Result Storage ? The internal data storage mechanism uses SQLites native data types for optimal compatibility. As a result, SQLiteSpy uses far less memory than other SQLite managers and handles large tables much more efficiently.
- Built in SQLite Engine ? SQLiteSpy comes as a single file executable with the SQLite database engine already build into the application. There is no need to distribute any DLLs, which makes SQLiteSpy easy to deploy with customers.
- Encryption Support ? SQLiteSpy can read and modify encrypted database files generated by DISQLite3. DISQLite3 implements its own native AES encryption which is not compatible with the commercial SQLite Encryption Extension (SSE) or any such implementation offered by other 3rd parties.
- Easy Install & Uninstall ? To run SQLiteSpy, just extract the SQLiteSpy.exe file to any directory and execute the file. No installation is needed ? when first started, the program creates a single file SQLiteSpy.db3 (a SQLite3 database) to store options and settings. It does not write any other files or to the registry. Uninstalling is as simple as deleting two files only: The applications executable and its options database file.
NOTE: SQLiteSpy is Freeware for personal and educational use
Enhancements:
- Update built-in DB engine to SQLite 3.6.1 (DISQLite3 1.6.1).
- Schema treeview: Show triggers even if the trigger table name case differs from the original table name case.
SQLite PHP Generator 8.1
A Windows GUI utility for SQLite PHP programming. more>> SQLite PHP Generator is a freeware but powerful SQLite GUI frontend that allows you to generate high-quality SQLite PHP scripts for the selected tables, views and queries for the further working with these objects through the web. Key features include: data management abilities (adding, editing and deleting records), customization of the HTML appearance, filtering and sorting abilities, support for images and hyperlinks, data protection with a lot of security settings, integrated script navigation and ability to create multilingual web apps.<<less
SQLite PHP Generator is a freeware but powerful SQLite GUI frontend that allows to generate ... useful SQLite GUI frontend that allows to generate high-quality SQLite PHP scripts for theSQLite PHP Generator is a powerful SQLite GUI frontend that allows ... SQLite PHP Generator is a FREEWARE but powerful SQLite GUI frontend that allows to generate
SQLite PHP Generator is a freeware but powerful SQLite GUI frontend that allows to generate ... With SQLite PHP Generator will have a very professional web database application ready
SQLite for Windows 3.5.4
an ACID-compliant relational database management system more>> SQLite is a in-process library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. The code for SQLite is in the public domain and is thus free for use for any purpose, commercial or private. SQLite is currently found in more applications than we can count, including several high-profile projects.
SQLite is an embedded SQL database engine. Unlike most other SQL databases, SQLite does not have a separate server process. SQLite reads and writes directly to ordinary disk files. A complete SQL database with multiple tables, indices, triggers, and views, is contained in a single disk file. The database file format is cross-platform - you can freely copy a database between 32-bit and 64-bit systems or between big-endian and little-endian architectures. These features make SQLite a popular choice as an Application File Format. Think of SQLite not as a replacement for Oracle but as a replacement for fopen()
SQLite is a compact library. With all features enabled, the library size can be less than 250KiB, depending on compiler optimization settings. (Some compiler optimizations such as agressive function inlining and loop unrolling can cause the object code to be much larger.) If optional features are omitted, the size of the SQLite library can be reduced below 180KiB. SQLite can also be made to run in minimal stack space (16KiB) and very little heap (100KiB), making SQLite a popular database engine choice on memory constrained gadgets such as cellphones, PDAs, and MP3 players. There is a tradeoff between memory usage and speed. SQLite generally runs faster the more memory you give it. Nevertheless, performance is usually quite good even in low-memory environments.<<less
SQLiteSheet 00.05
SQLiteSheet is a tool for administration of SQLite databases more>>
The program works:
- SQL commands mode
- GRID mode.
Main features:
- Modify database (create table, drop table, vacuum, etc.)
- Execute SQL requests (insert delete, update, select, etc.)
- Import DBF files
- Export DBF files
- Support function (UpperAnsi, LowerAnsi, TrimLeft, Trim, TrimRight, PadLeft, PadRight, Replace, Translate, Instr, Mod, Div, Sign)
- Append plugins
- Append internal functions and more others.
PhpSQLiteAdmin 0.1
PhpSQLiteAdmin is a highly-efficient, high-quality application which provides Web based management and administration for SQLite databases. more>>
PhpSQLiteAdmin 0.1 is a highly-efficient, high-quality application which provides Web based management and administration for SQLite databases. Much in the same vain as phpMyAdmin of course. Provides functionality to view data, add/drop tables, views and indexes, export data, add/delete rows, query the database.
Requirements:
- Windows Me/NT/2000/XP/2003 Server/Vista
provides web based management and administration for SQLite databases. phpSQLiteAdmin 0.1
SQLite Database Browser 1.3
SQLite Database Browser provides you with an ideal, freeware, public domain, open source visual tool used to create, design and edit database files compatible with SQLite. more>>
SQLite Database Browser 1.3 provides you with an ideal, 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.
Major Features:
- Create and compact database files
- Create, define, modify and delete tables
- Create, define and delete indexes
- Browse, edit, add and delete records
- Search records
- Import and export records as text
- Import and export tables from/to CSV files
- Import and export databases from/to SQL dump files
- Issue SQL queries and inspect the results
- Examine a log of all SQL commands issued by the application
CDSITE 1.1
Installer of last version Apache, MySQL, PHP and CRON for Windows. more>>
CDSITE - installer of last version Apache, MySQL, PHP and CRON for Windows. CDSITE runs from any location, including directories with names containing spaces, CD or DVD.
It works fine from read-only media like compact discs (CDs), DVD disks.
SQLite Manager 0.3.10
Firefox extension that will allow you to easily manage the SQLite databases on your computer from your browser more>> Firefox extension that will allow you to easily manage the SQLite databases on your computer from your browser
SQLite Manager is an extension that will allow you to manage any SQLite database on your computer.
Manage any SQLite database on your computer. Helpful dialogs to create tables, indexes, to browse and search the tables and the facility to execute any sql query. A dropdown menu helps with the sql syntax thus making writing sql easier.
System requirements:
- Firefox: 2.0 - 3.1a2pre
Enhancements:
- Issue #166: DB Objects Panel is often too small and does not expand. Fixed.
- Issue #167: Support Sunbird 0.9
to easily manage the SQLite databases on r computer from r browser. SQLite Manager 0.2 ...Firefox extension that will allow to easily manage the SQLite databases on
SQTView 0.53
SQTView is a small utility for displaying SQLite files. more>> SQTView is completly free of charge and provided without any warranty. Feel free to download it now.
If you really like it and want us to continue improving it and releasing similar products in the future, you might consider a small donation.
reads SQLite 2.x and 3.x files (autodetect)
shows any SELECT
export to clipboard
auto refresh<<less
SQTView is a free and small utility which will display SQLite files. SQTView 0.52 (b72) - Axel ... It reads SQLite 2.x and 3.x files (auto-detect) and shows any select in a list view. Results can
SQTView provides with a ultimate solution for displaying SQLite files. SQTView 0.51 (b69 ... SQTView 0.51 (b69) provides with a ultimate solution for displaying SQLite files. It readsLicense:Freeware
BiblioteQ 6.34
A complete and thorough library management suite more>>
BiblioteQ 6.34 is a useful and multi-featured library management suite which provides a mechanism for querying the Library of Congress, or any other Z39.50-capable system, via the standard Z39.50 protocol; thus simplifying the data-entry process. As for database support, BiblioteQ allows for connectivity to both PostgreSQL and SQLite database engines.
Major Features:
- Cataloging of Books, DVDs, Journals, Magazines, Music CDs, and Video Games.
- Patron information.
- Rich search capabilities, including custom SQL queries.
- Cover images with drag and drop support.
- PostgreSQL accounts with various privileges.
- Administrator roles.
- Full PostgreSQL and SQLite support.
- Transactional database queries.
- Threaded data retrieval via the Library of Congress for Books, Journals, and Magazines.
- Print support.
- Support for requesting unavailable items.
- Item reservation.
- Listings of overdue items, requested items, and reserved items.
- Customizable item data, pricing information, and currencies.
- Item reservation histories for patrons.
- Offsystem URL support.
- Customizable displays.
- Embedded hyperlinks for localized searches of similar items.
- Front cover image retrieval via Amazon.
- Uniform functionality across various platforms.
ABC Amber SQLite Converter 1.05
utility helps you convert your SQLite databases to any format you wish more>> ABC Amber SQLite Converter is an advanced utility which helps you convert your SQLite databases to any format you wish (MDB, XLS, DBF, CSV, XML, SQL, PDF, HTML, CHM, RTF, HLP, DOC) easily and quickly.
Important note: The program is free and doesnt require external libraries.
- reads SQLite databases
- exports to XLS, CSV, DBF, XML, PDF (does not require Adobe Acrobat to be installed), HTML, CHM, RTF (MS Word does not need to be installed), DOC (MS Word), MDB (MS Access)
- easy to use and easy to set up
- supports advanced PDF export options (document information, 40/128 bits PDF encryption, PDF security options, page size, page orientation and page margins, resolution mode, compression mode, viewer options)
- supports multiple CHM and HLP export options
- multi-language support, skin support
export r SQLite databases to the formats need. ABC Amber SQLite Converter is an advanced ... convert r SQLite databases to any format wish (MDB, XLS, DBF, CSV, XML, SQL, PDF, HTMLSokkit 4.0
Apache/PHP/MySQL/Perl server more>> Sokkit is a web server toolkit for Windows that provides everything you need to get started as a PHP developer:
- A Web server - the award winning Apache web server
- Up to date PHP interpretor
- Sokkit Control Panel for managing your server painlessly
- Regular upgrades to keep your server up to date
- SQLite - file-based database INCLUDED and enabled by default.
- MySQL database (free add-on module)
- SSL for serving secure pages (free add-on module)
- Modular architecture for easy future expansion
dotConnect for SQLite Standard Edition 2.50
dotConnect for SQLite Standard Edition is a free of charge database connectivity solution built over ADO.NET architecture. It offers basic functionality for developing database-related applications, web sites. more>>
dotConnect for SQLite Standard Edition is a free of charge database connectivity solution built over ADO.NET architecture and a development framework with number of innovative technologies. It offers basic functionality for developing database-related applications and web sites. It introduces new approaches for designing applications and boosts productivity of database application development.
Key Features:
- Direct access to SQLite database
- 100% managed code
- High performance
- Easy to deploy
- Supports the latest versions of SQLite database
- All SQLite data types support
- Operates in both connected and disconnected models
- Extra data binding capabilities
- Cross-form components cooperation
- Licensed royalty-free per developer, per team, or per site
- Free of charge
dotConnect for SQLite supports SQLite engine version 3 and higher. The provider works with .NET Framework 2.0, 3.0, and 3.5. dotConnect for SQLite Standard Edition can be used with the following integrated development environments:
- Microsoft Visual Studio 2010
- Microsoft Visual Studio 2008
- Microsoft Visual Studio 2005
- Delphi 2007
Delphi for .NET and RAD Studio 2007 are supported in run time only as these environments have no WinForms designers.
System Requirements: .NET Framework
Enhancements: Added support for user-defined finctions LINQ to SQLite: Suported DeleteOnNull attribute of association and changed default behaviour (DeleteOnNull=false now) Entity Developer: Added support for EF Precision and Scale facets; Improved MS EDM Designer compatibility
<<less
dotConnect for SQLite Standard Edition is a free ... per site - Free of charge dotConnect for SQLite supports SQLite engine version 3 and higher. TheLicense:Freeware
Devart - dotConnect for SQLite Standard Edition is a freeLicense:Freeware
native connectivity to the SQLite database and a number of innovative development tools a ... number of innovative development tools and technologies. dotConnect for SQLite introducesLicense:Freeware
dotConnect for SQLite Standard 2.0
dotConnect for SQLite Standard is launched as a free yet powerful charge database connectivity solution built over ADO.NET architecture and a development framework with number of innovative technologies. more>>
dotConnect for SQLite Standard 2.0 is launched as a free yet powerful charge database connectivity solution built over ADO.NET architecture and a development framework with number of innovative technologies. It offers basic functionality for developing database-related applications and web sites. It introduces new approaches for designing applications and boosts productivity of database application development.
