![]() SQLite Administrator also includes additional functionality to write SQL queries, export data to Excel, and migrate SQLite 2 databases to the SQLite 3 format. SQLite Administrator is an open source application that fills this gap by giving you the ability to create, modify, and delete tables, views, indexes, and triggers. One of the few downsides of SQLite is the lack of a good administration tool: it doesn’t come packaged with a tool comparable to SQL Server’s Enterprise Manager. Key features include: Support for all SQLite versions 2.8. It’s perfect as a location for client-side caching or offline support in Windows Forms and Windows Mobile applications. SQLite Maestro is the premier SQLite admin tool for database management, control and development. Because all of this functionality is wrapped up in a small library, SQLite is an ideal candidate for embedded databases. This small database includes ACID (atomic, consistent, isolated, and durable) transactions, SQL92 implementation, a 2 terabyte database limit, and much more. SQLite is an open source SQL database engine packed into a tiny 250 KB C library. ![]() If you wish to use commercial alternative sqlite admin then SQLite maestro is very good and efficient alternative.20.3 Administering SQLite Databases with the SQLite Administrator I wish SQLite administrator developers update this software regularly. You’ll find that it’s good software but due to lack of updates it’s not worth to use for the production software development. First tab SQL Query allows you to type sql query and execute against the command line. In comparison to SQLite maestro there are very less feature from this software. SQLite administrator offers you to control the data with help of 3 tabs. SQlite Administrator provides a forthright method to work with SQLite databases and. There is also data import option available in data menu. Review by Mihaela Teodorovici on June 3, 2014. DB4S uses a familiar spreadsheet-like interface, and complicated SQL commands do not have to be learned. DB4S is for users and developers who want to create, search, and edit databases. This feature is useful if you wish to make your database available in csv or excel format. What it is DB Browser for SQLite (DB4S) is a high quality, visual, open source tool to create, design, and edit database files compatible with SQLite. There is also option for exporting the data in excel format. You can also export your data in format available. You can also save your database in folder of your choice which is good feature if you wish to save your database in folder where your application resides. You’ll find this option saving lot of your time. ![]() Right clicking on table or database gives you menu options for creating: table, index and trigger. If you wish to manipulate table manually then “Edit” tab is useful. You’ll find the result of SQL query in “Results” tab. First tab “SQL Query” allows you to type sql query and execute against the command line of SQLite. SQLite administrator offers you to control the data with help of 3 tabs. But if you’re looking for gui interface for your sqlite database that has no issue with old version of sqlite then this tool is beneficial for you. If you already know the DSN name, or know how to create a new DSN now, you can skip the rest of this page. A DSN is the saved collection of settings required to connect to an ODBC data source. You’ll notice that this version is old and you’re having trouble using new version of sqlite with this tool. Provide a DSN (data source name) that already exists or that you create with the ODBC Data Source Administrator applet. SQLite administrator is shipped with SQLite version 3.4. You can download SQLite administrator from this site. Few tools are either discontinued or are still packaged with old version of sqlite. There are some 3rd party gui tools for sqlite. There is no official GUI tool for manipulating SQLite database. If you’re using SQLite for your small apps then using GUI interface for database creation can be handy.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |