DbcH SQLite
SQLite database manager
Download:
- DbcH_SQLite 0.92 ( Windows )
- DbcH_SQLite 0.92 ( Debian 7 )
The project itself is hosted in https://github.com/alkresin/dbc_sqlite.
There is a number of tools to manage SQLite databases, so the first question is:
Why to develop yet another ?
First of all, I want to learn SQLite features more, and writing a database manager is a good method, I think.
Secondly, I'm not satisfied with an interface of most existing tools. When I open some database, the main thing that interests me, is a data in it. What tables it contains and what data are contained in these tables. The indexes, views and triggers are a secondary type of a database contents and I don't want to see them immedeately after the database is opened for they do not distract attention from the main. I need only to have the possibility to look at them separately, if this will be necessary.
Thirdly, at the moment I begin to develop it (December 2014), most of existing tools didn't include support of some new sqlite features. For example, they didn't open databases, which had tables "WITHOUT ROWID" at all!
And, at least, I want to have a possibility to add any feature when I will need it.
Current version of DbcH_SQLite (0.92) includes the following possibilities:
- list of tables of opened database;
- view/modify the data in any table;
- view the structure and other information about the table;
- view the full structure (schema) of a database;
- dump of a database;
- view/modify parameters (pragmas) of a database;
- creating of new tables and indexes;
- deleting of tables and indexes;
- input, editing and execution of SQL queries;
- syntax highliting of SQL queries;
- autocompletion while editing the SQL queries (using the TAB key);
- saving the SQL query in a separate file and loading from it;
- the history of SQL queries separately for each database;
The length of a comment - no more than 4000 characters.
Your name:
Email address:
(not be shown publicly)
Input text from an image:
Your name:
Email address:
(not be shown publicly)
  |