Thanks to its plain looks and the clear functions, even beginners can use it to create a new database or browse the records of an existing one. Trying to keep things as simple as possible, SQlite Administrator is a handy tool for those who are working with SQLite databases. There are filtering options that enable you to exclude certain entries from the query before executing it. SQlite Administrator also comes with an integrated SQL query execution tool, where you can type in or paste a command and run it with just a click. Their content can be exported to CSV format and saved locally for later viewing. You can easily create new tables containing custom records and save your new database on the local hard drive, as well as delete or rename tables as you feel consider fit.Īll the database tables are displayed in a list, allowing one-click access to the records, which are neatly displayed within an organized table in the right pane. Of course, the latter function requires you to have prior knowledge related to SQL commands, their syntax and usage. Create tables, export records and execute queries SQlite Administrator can be used either for exploring the contents of an existing database or creating a new database from scratch. This particular utility is somewhere in the middle of these two categories, standing out through the simple look and the straightforward GUI that makes database handling a lot easier. The number of similar applications out there is not negligible at all, ranging from simple database viewers to more complex software solutions that provide extensive data manipulation functions. Focusing on functionality and ease of use, it enables you to explore the contents of such as database, while also bundling tools for executing queries and editing tables. If you wish to use commercial alternative sqlite admin then SQLite maestro is very good and efficient alternative.SQlite Administrator provides a forthright method to work with SQLite databases and manipulate their content. ![]() 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. ![]() In comparison to SQLite maestro there are very less feature from this software. There is also data import option available in data menu. This feature is useful if you wish to make your database available in csv or excel format. There is also option for exporting the data in excel format. Key features include: Support for all SQLite versions 2.8. You can also export your data in format available. SQLite Maestro is the premier SQLite admin tool for database management, control and development. 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. You’ll notice that this version is old and you’re having trouble using new version of sqlite with this tool. 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 |