To alter the database later simply drop it into the view. You can, for instance, create a new database on your browser memory and then download it to the local hard disk. One other important feature of this web application is data exporting functionality. Note that like other functions, you can first use the Math.js to manipulate the data and then plot it. Use the "Chart.js" menu item to see examples. Currently "Pie", "Chart", "Bar", "Time", "Scatter", "Doughnut" charts are supported. This web app is connected to a powerful offline plotting tool that can be used to plot almost any data. One other frequently needed feature in a database that is missed in the most SQLite applications is the plotting functionality. To access the documents use the "Open Math.js help" entry in the "File" menu. You can simply port the portion of the table that is needed to the Math.js environment and then use the built-in average function or even write your handwritten function to do so! Make sure to review the Math.js documentation for more info. For instance, say you have a table in your database and you want to find the average value of a column or a row. Note that it is also possible to use Math.js and JavaSvript directly to simplify the math conversions. To ease the usage, this web application has several menu items to help you to prepare the statements. It is well-known that manipulating a database in SQLite is pretty complex. Since this web application uses Web Worker technology, you can run multiple commands at the same time. While the SQLite statement is being executed, you can write and execute a new statement on the next box. To write multiline statements, use Shift + Enter to move to a new line without executing the box. To write a new SQLite statement, focus on a text area and then press the "Enter" key. The active database is the one that is used to execute your SQLite statements. You can always use the drop-down menu to change the active database. This id can be used later to download the database. When a new database is added, the top-right drop-down menu displays then name as well as a unique id. ![]() ![]() Simply drop one or more databases to the view. If you need more space, use the "Toggle Fullscreen" context item in the "File" menu. It is recommended to download the databases to your machine and then drop them into the UI. Note that since this page does not have any remote access, the "Download active Database" method might not work if the "X-Frame-Options" is not set properly. You can use the "File" menu item to load a database or just drop the database into the viewport. SQLite Manager can handle multiple SQLite databases at the same time. You can even run the application when there is no internet access if you have let the to first fully load. Your database is not being sent to any remote servers. Note that this web application works offline if all resources are first loaded. The web application uses the official SQLite code which is compiled to JavaScript and hence can be run on your browser without the need to access any remote resources to compute your commands. This web application should work just fine in all modern web browser. ![]() The idea is to manipulate multiple SQLite databases without the need to install a native application. ![]() SQLite Manager is a port of a well-known browser extension with its author permission. SQL builder for select, create, drop, delete. Save all unique executed sql i table (aSQLiteManager) Open a database list tables, views and indexes (triggers later) Progress bar during export of databases and export bug hopefully solvedĬurrent SQL now saved on exit and reloaded on startĮditing and insert of records from Table viewerĬorrect scaling of large devices (Samsung Galaxy) Support for tables and field names with spacesĮditing of system databases on rootet phones using aShellīug fixes (if you report them I get fine messages from Market) Table browser now with color codes for field type Now check if database exists before trying to open recently opened databases and removes deleted databases from the list Sort data in table viewer by clicking on title of columįont size in directory and table lists follow the font size of data grids You can execute any valid SQLite SQL so be careful data can be deleted - no regret!Ī new CREATE TABLE wizard where entered fields can be edited / deletedĭata entry / editor tool allow insert, update and delete on views with instead of insert, update and delete triggers If the database is stored on the SDCard you can browse the data, change records and query the data. You can execute any valid SQLite SQL so be careful data can.ĪSQLiteManager - a SQLite manager for the Android platform. ASQLiteManager - a SQLite manager for the Android platform.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |