Lita - SQLite Administration Tool. This project was discontinued. You can grab the source here. Lita is a free and open source SQLite database administration tool for Windows, MacOSX and Linux. Download Now | Screenshots | FAQ | Help | Get Satisfaction ! Important It is strongly recommended to make backups of your databases on a regular basis. Lita is developed with the help of Paul Robertson. Screenshots Q: What is Lita ? A: Lita is an administration interface for SQLite databases. Q: How can I install Lita? Q: What is Adobe AIR ? A: You can learn about Adobe AIR here. Q: I can't download / install it it using the install badge. A: The direct link to the AIR file is here, but you'll need the AIR runtime to install it.
Q: Can I use Lita with non-AIR SQLite databases ? A: While most of its features are compatible with any sqlite database, it was primarily designed to administrate AIR application databases. Q: Why did you create another AIR sqlite admin ? Q: How can I get the latest news about Lita ? Q: How can I help or thank you ? Lita - SQLite Administration Tool.
This project was discontinued. You can grab the source here. Lita is a free and open source SQLite database administration tool for Windows, MacOSX and Linux. Download Now | Screenshots | FAQ | Help | Get Satisfaction ! Important It is strongly recommended to make backups of your databases on a regular basis. Always assume that Lita can break your database. Lita is developed with the help of Paul Robertson. Screenshots Q: What is Lita ? A: Lita is an administration interface for SQLite databases. Q: How can I install Lita? Q: What is Adobe AIR ? A: You can learn about Adobe AIR here. Q: I can't download / install it it using the install badge. A: The direct link to the AIR file is here, but you'll need the AIR runtime to install it. Q: Can I use Lita with non-AIR SQLite databases ?
A: While most of its features are compatible with any sqlite database, it was primarily designed to administrate AIR application databases. Q: Why did you create another AIR sqlite admin ? Q: How does encryption work ? Del.icio.us backup [ruby] [sqlite] [del.icio.us] [backup] SQLite Home Page. Finisar.SQLite. Free download ABC Amber SQLite Convertor, convert SQLite databases to MDB, DBF, CSV, XML, XLS, PDF, DOC, HTML. ABC Amber's award winning conversion utility software has the answer to just about any need you may have...even conversion to any of 50 languages! Convert text, images, databases, e-mail and more! Powerful, yet easy to use. Use the menu to the left to find out more detail on each product, download trial versions or purchase any of our programs! All programs tested successfully in: Windows Vista/7/XP/2000/2003/NT/Me/98/95 Featured Products: Frequently Asked Questions: Check our FAQ page before contacting technical support, the answer you need may already be there.
Contact: Technical Support: click here (Please write in English only - sorry, but requests in any other language may be ignored.) Partnership Opportunity: We are always open for contacts and partnership. New Amber Converter: If you want us to develop a new converter, don't hesitate to drop us an e-mail. What our customers are saying: "Your prices are the lowest on the software market, your products are excellent! " back to top. ADO.NET 2.0 Provider for SQLite. Simple C# Wrapper for SQLite. Free source code and programming help.
Introduction This article describes a very simple wrapper class for SQLite. This class provides only few simple functions: opening and closing database, returning the list of tables and executing queries. Although these are basic functions, they are enough for someone who needs only a storage engine for his/her program. Background While writing this class, I've been using ADO.NET Data Provider for SQLite as a reference, which I found here. Using the Code Using this class is very easy: add a reference to this DLL (Project->AddReference...) in your project and a line to your code: using SQLWrapper; Now you can start using database functions in your program. Example: SQLiteBase db = new SQLiteBase("test.db"); DataTable table = db.ExecuteQuery("SELECT * FROM table1 WHERE id = 1;"); db.CloseDatabase(); Source Code There are two constructors and and five public functions: OpenDatabase CloseDatabase GetTables ExecuteNonQuery ExecuteQuery.
Convert SQL Server DB to SQLite DB. Free source code and programming help. Introduction I needed to convert the existing SQL server databases to SQLite databases as part of a DB migration program and did not find any decent free converter to do the job. This is my attempt to solve the problem. I should warn you though that I did not have much time to test it on too many databases. In any case - the source code is very well documented and easy to understand, so if you do have a problem it should be relatively easy to fix. (Please send me the fixed source code. If you do so, I can update the software so that everybody can enjoy it.) Using the Code The code is split between a dataaccess project (class library) that contains the conversion code itself and a converter project (WinForms) that drives the conversion code and provides a simple UI for user interaction.
The main class that performs the conversion is the sqlservertosqlite class. Basically, that's it! Points of Interest History. Using SQLite in your C# Application. Free source code and programming help. Introduction SQLite is a small, fast and embeddable database where the database engine and the interface are combined into a single library. It also has the ability to store all the data in a single file. So if your application requires a standalone database, SQLite is perhaps the perfect choice for you. There are, of course, other reasons for choosing SQLite including: SQLite has a small memory footprint and only a single library is required to access databases, making it ideal for embedded database applications.
SQLite has been ported to many platforms and runs even on Windows CE and Palm OS. SQLite is ACID-compliant, meeting all four criteria - Atomicity, Consistency, Isolation, and Durability. Using the Code To use SQLite in your C# application, you need to download a third party free ADO.NET data provider (SQLite.NET.0.21_x68_dll.zip) from here. Fig 1: Demo C# SQLite application. To administer SQLite database, an open-source SQLite GUI Database Browser utility is of much use. SQLite - Ashutosh Nilkanth's .NET Blog.