SQLite Workbench
Frequently Asked Questions
Welcome to our FAQ section. Please read them carefully to find the optimal way to use our workbench.
Click on the question(s) to show its aswer.
- What is SQLite Workbench ?
- SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. SQLite is the most widely deployed SQL database engine in the world. The source code for SQLite is in the public domain.
SQLite Workbench is a simple GUI to manage SQLite databases.
Through SQLite Workbench you can completly manage your data, and your database settings.
Rules and settings are used everytime you perform an operation on the database, making SQLite Workbench work like an application server for SQLite database handling. - How much does SQLite Workbench cost ?
- SQLite Workbench is free, for personal and commercial use.
We rely on ads to keep it free, so visiting our sponsor is the best way to support us. - Can I use SQLITE Workbench for commercial projects ?
- Yes, SQLite Workbench is free, for personal and commercial use.
Anyway the software is provided "as is" and the author disclaims all warranties with regard to this software including all implied warranties of merchantability and fitness. In no event shall the author be liable for any special, direct, indirect, or consequential damages or any damages whatsoever resulting from loss of use, data or profits, whether in an action of contract, negligence or other tortious action, arising out of or in connection with the use or performance of this software. - Can I access the same database with different accounts ?
- No, databases are user-related, this means that each database is considered property of the user who uploads or creates it.
SQLITE Workbench is not thought for enterprise use, anyway multiple logins at the same time are allowed, giving the possibility to access and edit same data at same time. No informations about who edit the data is kept or avalaible. - Does SQLITE Workbench support mysql/oracle/postgre/... ?
- No
SQLITE Workbench is designed and thought to manage SQLite databases, no functionality nor support is provided for other databases nor database engines. - How many databases can I manage ?
- There is no limit for databases, this means you can upload and/or create as many databases you need.
- How big can my database be ?
- There is no limit size for database once upload or created, Upload is limited to five megabytes(5MB) per file, so for uploading big databases consider to import data through queries using our API.
- Why cannot I edit tables without ROWID ?
- Editor relies on ROWID to edit data. Tables without ROWID give no unique reference to our system. They can be edited through sql commands only.
- Is there a data limit per table ?
- SQLITE Workbench does not limit the number of records of a table, nor the number of tables. Any limit may depend on database or language limit.
Please refer to SQLite online documentation for further informations about data limit.
SQLITE Workbench data editor is disabled for tables with more than 10000 rows, because many browsers may slow down your system and 10000 rows is an acceptable limit.
This limit may be increased in future. - How can I use APIs ?
- To access your data through API you must perform a POST request to your personal api url, which is
http://www.sqlite-workbench.com/api/USERNAME/DB/
where USERNAME is the username used for access and DB is your database name as displayed in the workbench.
The request must contain following parameters:
Where
- query is the query to be executed;
- check is a MD5 hash string obtained from your query with no space in it surrounded by your API secret code, found in the Settings ⇛ Api code area which can be found on the top right of the workbench, near the Logout button; and
- responseType(optional) is the output format of the response, which can be either JSON or CSV (JSON as default)
The following PHP code example shows how to perform a request using cURL.
/*
*
* Parameters
*
*/
$user = 'myUserName';
$secret ='bgdzfghzdf5543565367sdhgfdfr5s6w67457456';
$db = 'myDbName';
$query = "SELECT * FROM __Text LIMIT 10";
/*
*
* Allowed values are 'JSON' and 'CSV'
*
*/
$responseType = 'JSON';
/*
*
* Url creation
*
*/
$url = 'https://www.sqlite-workbench.com/api/' . $user .'/' . $db . '/';
/*
*
* Hash generation
*
*/
$check = md5(preg_replace('/s+/', '', $secret . $query . $secret));
/*
*
* Parameters for POST request
*
*/
$fields = array(
'query' => urlencode($query),
'responseType' => $responseType,
'check' => urlencode($check)
);
$fields_string = '';
foreach ($fields as $key => $value) {
$fields_string .= $key . '=' . $value . '&';
}
rtrim($fields_string, '&');
/*
*
* cURL execution
*
*/
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, $url);
curl_setopt($ch, CURLOPT_FOLLOWLOCATION, true);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
curl_setopt($ch, CURLOPT_POST, true);
curl_setopt($ch, CURLOPT_POSTFIELDS, $fields_string);
$result = curl_exec($ch);
curl_close($ch);
