{"id":41197,"date":"2023-11-22T15:46:57","date_gmt":"2023-11-22T20:46:57","guid":{"rendered":"https:\/\/mjtsai.com\/blog\/?p=41197"},"modified":"2023-11-22T15:49:10","modified_gmt":"2023-11-22T20:49:10","slug":"ducklet-1-0-1","status":"publish","type":"post","link":"https:\/\/mjtsai.com\/blog\/2023\/11\/22\/ducklet-1-0-1\/","title":{"rendered":"Ducklet 1.0.1"},"content":{"rendered":"<p><a href=\"https:\/\/ducklet.app\/\">ohoj Software<\/a>:<\/p>\n<blockquote cite=\"https:\/\/ducklet.app\/\"><p>Ducklet makes using SQLite databases easy for everyone, whether you&rsquo;re a developer, data analyst, or just curious. We&rsquo;ve designed a user-friendly interface for a smooth and intuitive experience, so you can focus on your data.<\/p><p>[&#8230;]<\/p><p>Experience unmatched performance and seamless integration with our native application written in SwiftUI and AppKit.<\/p><\/blockquote>\n<p>I discovered this <a href=\"https:\/\/indieapps.space\/@ducklet\/111211445444801540\">new<\/a> app while assembling the Black Friday deals. It brings some fresh ideas but isn&rsquo;t mature enough for me to switch yet.<\/p>\n<p>Likes:<\/p>\n<ul>\n<li>It has a nice view of how much space each table and index is using.<\/li>\n<li>You can open each table&rsquo;s schema in a separate window.<\/li>\n<li>It has tabs both to show different sequences of SQL that you&rsquo;re editing\/executing and to show query results. So there&rsquo;s a lot of history visible.<\/li>\n<li>It can show the <code>EXPLAIN<\/code> info about how a query is executed.<\/li>\n<\/ul>\n<p>Dislikes:<\/p>\n<ul>\n<li>It takes too many steps to create a project and add my database. I just want to drag and drop a file to open it.<\/li>\n<li>There are lots of places in the table views and statistics list where text is truncated, and there&rsquo;s no way to resize things to show it, even though there&rsquo;s lots of available space in the window.<\/li>\n<li>There are lots of places where text isn&rsquo;t selectable.<\/li>\n<li>The table browser (when you&rsquo;re not doing a query) is in a sheet that feels constricting and can&rsquo;t show the full cell values.<\/li>\n<li>It takes extra steps to view a BLOB, and it doesn&rsquo;t know how to decode common formats.<\/li>\n<\/ul>\n\n<p>Overall, I like <a href=\"https:\/\/menial.co.uk\/base\/\">Base<\/a> and <a href=\"https:\/\/betamagic.nl\/products\/coredatalab.html\">Core Data Lab<\/a> better, but Base has been giving me a lot of internal errors lately, and I&rsquo;m unsure whether it&rsquo;s still under development. However, Ducklet looks promising, so I purchased it on sale.<\/p>\n\n<p>Previously:<\/p>\n<ul>\n<li><a href=\"https:\/\/mjtsai.com\/blog\/2023\/11\/21\/black-friday-2023\/\">Black Friday 2023<\/a><\/li>\n<li><a href=\"https:\/\/mjtsai.com\/blog\/2023\/09\/15\/core-data-lab-2-4-beta\/\">Core Data Lab 2.4 Beta<\/a><\/li>\n<li><a href=\"https:\/\/mjtsai.com\/blog\/2020\/01\/27\/core-data-lab-1-0\/\">Core Data Lab 1.0<\/a><\/li>\n<li><a href=\"https:\/\/mjtsai.com\/blog\/2014\/08\/01\/core-data-editor-is-now-open-source\/\">Core Data Editor Is Now Open Source<\/a><\/li>\n<\/ul>","protected":false},"excerpt":{"rendered":"<p>ohoj Software: Ducklet makes using SQLite databases easy for everyone, whether you&rsquo;re a developer, data analyst, or just curious. We&rsquo;ve designed a user-friendly interface for a smooth and intuitive experience, so you can focus on your data.[&#8230;]Experience unmatched performance and seamless integration with our native application written in SwiftUI and AppKit. I discovered this new [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"apple_news_api_created_at":"2023-11-22T20:47:00Z","apple_news_api_id":"549da8d6-29bf-476f-b3a0-afa6b5d6b91e","apple_news_api_modified_at":"2023-11-22T20:49:12Z","apple_news_api_revision":"AAAAAAAAAAAAAAAAAAAAAQ==","apple_news_api_share_url":"https:\/\/apple.news\/AVJ2o1im_R2-zoK-mtda5Hg","apple_news_coverimage":0,"apple_news_coverimage_caption":"","apple_news_is_hidden":false,"apple_news_is_paid":false,"apple_news_is_preview":false,"apple_news_is_sponsored":false,"apple_news_maturity_rating":"","apple_news_metadata":"\"\"","apple_news_pullquote":"","apple_news_pullquote_position":"","apple_news_slug":"","apple_news_sections":"\"\"","apple_news_suppress_video_url":false,"apple_news_use_image_component":false,"footnotes":""},"categories":[2],"tags":[2467,143,75,30,32,2385,425],"class_list":["post-41197","post","type-post","status-publish","format-standard","hentry","category-technology","tag-base","tag-database","tag-developertool","tag-mac","tag-macapp","tag-macos-14-sonoma","tag-sqlite"],"apple_news_notices":[],"_links":{"self":[{"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/posts\/41197","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/comments?post=41197"}],"version-history":[{"count":3,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/posts\/41197\/revisions"}],"predecessor-version":[{"id":41200,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/posts\/41197\/revisions\/41200"}],"wp:attachment":[{"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/media?parent=41197"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/categories?post=41197"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mjtsai.com\/blog\/wp-json\/wp\/v2\/tags?post=41197"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}