{"id":526,"date":"2019-05-18T12:21:13","date_gmt":"2019-05-18T19:21:13","guid":{"rendered":"http:\/\/www.icetips.com\/blog_wp\/?p=526"},"modified":"2019-05-18T12:21:13","modified_gmt":"2019-05-18T19:21:13","slug":"tools-for-sqlite","status":"publish","type":"post","link":"http:\/\/www.icetips.com\/blog_wp\/2019\/05\/18\/tools-for-sqlite\/","title":{"rendered":"Tools for SQLite"},"content":{"rendered":"

SQLite databases came up on one of the newsgroups this week.\u00a0 I have not used the SQLite driver in Clarion, so I don't have any experience with it - yet.<\/p>\n

For many years I have used HeidiSQL with MySQL and MariaDB databases and it works great.\u00a0 But it can only work with MySQL, MariaDB and MS-SQL.\u00a0 So I wondered what tools there might be out there to use to browse and work with SQLite databases.\u00a0 Both are open source and free and both work with Windows, MacOS and Linux.<\/p>\n

I found two that looked interesting!<\/p>\n

SQLite Database Browser<\/strong><\/a><\/p>\n

This program has been around since 2003 and the last release was in April of 2019 so it's being fairly actively developed.\u00a0 It is available for Windows, MacOS, Linux (several variations) and FreeBSD.\u00a0 This tool is primarily a database browser and based on the few screenshots I've found it looks a bit limited.<\/p>\n

SQLite Studio<\/strong><\/a><\/p>\n

This program has also been around since 2007 and the last release was in July 2018.\u00a0 This program looks like HeidiSQL and you can view data, enter your own queries etc.\u00a0 It is available for Windows, MacOS and Linux.<\/p>\n

In my experience one of the most important tools when dealing with database is a good, solid interface to execute queries and statements.<\/p>\n

<\/div>\n

<\/path><\/svg><\/i> \"Loading\"<\/p>\n

<\/div>\n","protected":false},"excerpt":{"rendered":"

SQLite databases came up on one of the newsgroups this week.\u00a0 I have not used the SQLite driver in Clarion, so I don't have any experience with it - yet. For many years I have used HeidiSQL with MySQL and MariaDB databases and it works great.\u00a0 But it can only work with MySQL, MariaDB and ...continue reading Tools for SQLite<\/span><\/a><\/p>\n

<\/div>\n

<\/path><\/svg><\/i> \"Loading\"<\/p>\n

<\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"footnotes":""},"categories":[223,5],"tags":[],"class_list":["post-526","post","type-post","status-publish","format-standard","hentry","category-databases","category-technical"],"_links":{"self":[{"href":"http:\/\/www.icetips.com\/blog_wp\/wp-json\/wp\/v2\/posts\/526","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.icetips.com\/blog_wp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.icetips.com\/blog_wp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.icetips.com\/blog_wp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.icetips.com\/blog_wp\/wp-json\/wp\/v2\/comments?post=526"}],"version-history":[{"count":1,"href":"http:\/\/www.icetips.com\/blog_wp\/wp-json\/wp\/v2\/posts\/526\/revisions"}],"predecessor-version":[{"id":527,"href":"http:\/\/www.icetips.com\/blog_wp\/wp-json\/wp\/v2\/posts\/526\/revisions\/527"}],"wp:attachment":[{"href":"http:\/\/www.icetips.com\/blog_wp\/wp-json\/wp\/v2\/media?parent=526"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.icetips.com\/blog_wp\/wp-json\/wp\/v2\/categories?post=526"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.icetips.com\/blog_wp\/wp-json\/wp\/v2\/tags?post=526"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}