{"id":1941,"date":"2015-12-24T09:53:03","date_gmt":"2015-12-24T04:23:03","guid":{"rendered":"http:\/\/reliablesoftwares.com\/blog\/?p=1941"},"modified":"2015-12-20T21:50:30","modified_gmt":"2015-12-20T16:20:30","slug":"sqlpad-run-sql-in-your-browser","status":"publish","type":"post","link":"http:\/\/reliablesoftwares.com\/blog\/sqlpad-run-sql-in-your-browser\/","title":{"rendered":"SqlPad Run SQL in your browser"},"content":{"rendered":"<p><a href=\"http:\/\/reliablesoftwares.com\/blog\/?attachment_id=1942\" rel=\"attachment wp-att-1942\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" data-attachment-id=\"1942\" data-permalink=\"http:\/\/reliablesoftwares.com\/blog\/sqlpad-run-sql-in-your-browser\/query-editor\/\" data-orig-file=\"https:\/\/i0.wp.com\/reliablesoftwares.com\/blog\/wp-content\/uploads\/2015\/12\/query-editor.png?fit=1444%2C989\" data-orig-size=\"1444,989\" data-comments-opened=\"1\" data-image-title=\"query-editor\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/reliablesoftwares.com\/blog\/wp-content\/uploads\/2015\/12\/query-editor.png?fit=800%2C548\" class=\"alignleft size-medium wp-image-1942\" src=\"https:\/\/i0.wp.com\/reliablesoftwares.com\/blog\/wp-content\/uploads\/2015\/12\/query-editor-300x205.png?resize=300%2C205\" alt=\"query-editor\" width=\"300\" height=\"205\" srcset=\"https:\/\/i0.wp.com\/reliablesoftwares.com\/blog\/wp-content\/uploads\/2015\/12\/query-editor.png?resize=300%2C205 300w, https:\/\/i0.wp.com\/reliablesoftwares.com\/blog\/wp-content\/uploads\/2015\/12\/query-editor.png?resize=768%2C526 768w, https:\/\/i0.wp.com\/reliablesoftwares.com\/blog\/wp-content\/uploads\/2015\/12\/query-editor.png?resize=1024%2C701 1024w, https:\/\/i0.wp.com\/reliablesoftwares.com\/blog\/wp-content\/uploads\/2015\/12\/query-editor.png?w=1444 1444w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a>I am always looking for a better SQL Editor for Microsoft SQL 2008 or above on Mac. Have never found any which were free and good as well (not I know of). Then I came across SqlPad its base on Node.js hence its quite fast and low on resource. Also It is open sourced :).<\/p>\n<p>SqlPad is a self-hosted web app for writing and running SQL queries and visualizing the results. Its goal is to be a simple tool for exploratory data work and visualizations, ideal for data analysts who would prefer to work in SQL.<\/p>\n<p>SqlPad is meant to be run on an internal network for a single team. All connections added to the app can be used by all individuals with access to the SqlPad server. All queries written can be run and edited by everyone on the server.<\/p>\n<p>For more details on installing and running a SqlPad instance, see the <a href=\"http:\/\/rickbergfalk.github.io\/sqlpad\/installation-and-administration\" target=\"_blank\">Installation and Administration page<\/a>.<\/p>\n<p>I am really impressed by it, try it out I am sure will like it too.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I am always looking for a better SQL Editor for Microsoft SQL 2008 or above on Mac. Have never found<\/p>\n","protected":false},"author":1,"featured_media":1942,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"colormag_page_container_layout":"default_layout","colormag_page_sidebar_layout":"default_layout","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[10,3],"tags":[92,266,265],"class_list":["post-1941","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-app","category-blog","tag-browser","tag-sql","tag-sqlpad"],"jetpack_publicize_connections":[],"jetpack_shortlink":"https:\/\/wp.me\/pgLsB5-vj","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":3636,"url":"http:\/\/reliablesoftwares.com\/blog\/code-review-i-let-ai-rewrite-my-10-year-old-project-the-results-shocked-me\/","url_meta":{"origin":1941,"position":0},"title":"Code Review: I Let AI Rewrite My 10-Year-Old Project \u2013 The Results Shocked Me","author":"saifuddin","date":"September 21, 2025","format":false,"excerpt":"For years, I carried around a dusty old codebase\u201410 years old, full of hacks, patches, and outdated dependencies. Instead of rewriting it myself, I decided to see what AI could do. The outcome? Faster code, fewer bugs, and a shocking reminder that AI isn\u2019t just a coding assistant\u2014it can be\u2026","rel":"","context":"In &quot;AI&quot;","block_context":{"text":"AI","link":"http:\/\/reliablesoftwares.com\/blog\/category\/blog\/ai\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/reliablesoftwares.com\/blog\/wp-content\/uploads\/2025\/09\/ai-coding-vibe.jpg?fit=1024%2C1024&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/reliablesoftwares.com\/blog\/wp-content\/uploads\/2025\/09\/ai-coding-vibe.jpg?fit=1024%2C1024&resize=350%2C200 1x, https:\/\/i0.wp.com\/reliablesoftwares.com\/blog\/wp-content\/uploads\/2025\/09\/ai-coding-vibe.jpg?fit=1024%2C1024&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/reliablesoftwares.com\/blog\/wp-content\/uploads\/2025\/09\/ai-coding-vibe.jpg?fit=1024%2C1024&resize=700%2C400 2x"},"classes":[]},{"id":503,"url":"http:\/\/reliablesoftwares.com\/blog\/how-to-load-game-from-usb-for-wii\/","url_meta":{"origin":1941,"position":1},"title":"How to load game from usb for Wii","author":"saifuddin","date":"January 26, 2012","format":false,"excerpt":"This is just for educational purpose. This work only after\u00a0Homebrew Channel is install, for\u00a0instruction\u00a0on how to install Homebrew Channel click here. You will require 2 softwares: 1.Download USB Loader GX (2.0 r1037) from\u00a0HERE 2. WBFS Manager from\u00a0HERE. (64-bit version of WBFS Manager,\u00a0download from\u00a0HERE; if you need MAC download\u00a0HERE. ) \u00a0\u2026","rel":"","context":"In &quot;Miscellaneous&quot;","block_context":{"text":"Miscellaneous","link":"http:\/\/reliablesoftwares.com\/blog\/category\/miscellaneous\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/reliablesoftwares.com\/wp-content\/uploads\/2012\/01\/wii-usb-loader-300x225.png?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":3642,"url":"http:\/\/reliablesoftwares.com\/blog\/building-a-personal-ai-assistant-that-actually-works-complete-tutorial\/","url_meta":{"origin":1941,"position":2},"title":"Building a Personal AI Assistant That Actually Works \u2013 Complete Tutorial","author":"saifuddin","date":"September 25, 2025","format":false,"excerpt":"We\u2019ve all dreamed of having our own J.A.R.V.I.S.\u2014an AI assistant that listens, thinks, and helps us with daily tasks. The good news? You don\u2019t need to spend $1,000+ on a commercial solution. With the right open-source tools, you can build a personal AI assistant for under $50. This tutorial walks\u2026","rel":"","context":"In &quot;AI&quot;","block_context":{"text":"AI","link":"http:\/\/reliablesoftwares.com\/blog\/category\/blog\/ai\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/reliablesoftwares.com\/blog\/wp-content\/uploads\/2025\/09\/A_futuristic_personal_AI_assistant_setupglowing_ho_1757908515.jpg?fit=1024%2C1024&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/reliablesoftwares.com\/blog\/wp-content\/uploads\/2025\/09\/A_futuristic_personal_AI_assistant_setupglowing_ho_1757908515.jpg?fit=1024%2C1024&resize=350%2C200 1x, https:\/\/i0.wp.com\/reliablesoftwares.com\/blog\/wp-content\/uploads\/2025\/09\/A_futuristic_personal_AI_assistant_setupglowing_ho_1757908515.jpg?fit=1024%2C1024&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/reliablesoftwares.com\/blog\/wp-content\/uploads\/2025\/09\/A_futuristic_personal_AI_assistant_setupglowing_ho_1757908515.jpg?fit=1024%2C1024&resize=700%2C400 2x"},"classes":[]},{"id":3625,"url":"http:\/\/reliablesoftwares.com\/blog\/chatgpt-locally-for-free-the-complete-ollama-guide-2024\/","url_meta":{"origin":1941,"position":3},"title":"ChatGPT Locally for FREE: The Complete Ollama Guide (2024)","author":"saifuddin","date":"September 14, 2025","format":false,"excerpt":"Imagine having a ChatGPT-like AI assistant running on your computer, completely offline, with no monthly fees or data privacy concerns. It sounds too good to be true, but it's not only possible\u2014it's surprisingly easy to set up. Meet Ollama, the open-source tool that's revolutionizing how we interact with AI by\u2026","rel":"","context":"In &quot;Article&quot;","block_context":{"text":"Article","link":"http:\/\/reliablesoftwares.com\/blog\/category\/article\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/reliablesoftwares.com\/blog\/wp-content\/uploads\/2025\/09\/images.png?fit=243%2C207&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":3639,"url":"http:\/\/reliablesoftwares.com\/blog\/the-dark-side-of-ai-what-chatgpt-doesnt-want-you-to-know\/","url_meta":{"origin":1941,"position":4},"title":"The Dark Side of AI: What ChatGPT Doesn\u2019t Want You to Know","author":"saifuddin","date":"September 23, 2025","format":false,"excerpt":"AI tools like ChatGPT have exploded in popularity. They write code, draft essays, and even generate art. But beneath the convenience lies a darker truth\u2014how these systems are trained, what data they use, and the risks they quietly introduce. This isn\u2019t fear-mongering\u2014it\u2019s a reality check. \ufe0f Data Collection Practices of\u2026","rel":"","context":"In &quot;AI&quot;","block_context":{"text":"AI","link":"http:\/\/reliablesoftwares.com\/blog\/category\/blog\/ai\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/reliablesoftwares.com\/blog\/wp-content\/uploads\/2025\/09\/aicaptive.png?fit=1024%2C905&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/reliablesoftwares.com\/blog\/wp-content\/uploads\/2025\/09\/aicaptive.png?fit=1024%2C905&resize=350%2C200 1x, https:\/\/i0.wp.com\/reliablesoftwares.com\/blog\/wp-content\/uploads\/2025\/09\/aicaptive.png?fit=1024%2C905&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/reliablesoftwares.com\/blog\/wp-content\/uploads\/2025\/09\/aicaptive.png?fit=1024%2C905&resize=700%2C400 2x"},"classes":[]},{"id":3775,"url":"http:\/\/reliablesoftwares.com\/blog\/the-loop-that-lives-in-your-reflexes\/","url_meta":{"origin":1941,"position":5},"title":"The Loop That Lives In Your Reflexes","author":"saifuddin","date":"May 6, 2026","format":false,"excerpt":"Splice distills tap-timing to its purest form. A color wheel spins beneath a yellow notch. Above, a tile shows the color you must hit. When that segment crosses the notch, tap. Miss by a hair and the run ends. Every successful tap speeds the wheel up. Every fifth tap adds\u2026","rel":"","context":"In &quot;AI&quot;","block_context":{"text":"AI","link":"http:\/\/reliablesoftwares.com\/blog\/category\/blog\/ai\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/reliablesoftwares.com\/blog\/wp-content\/uploads\/2026\/04\/splice.jpeg?fit=540%2C1200&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/reliablesoftwares.com\/blog\/wp-content\/uploads\/2026\/04\/splice.jpeg?fit=540%2C1200&resize=350%2C200 1x, https:\/\/i0.wp.com\/reliablesoftwares.com\/blog\/wp-content\/uploads\/2026\/04\/splice.jpeg?fit=540%2C1200&resize=525%2C300 1.5x"},"classes":[]}],"jetpack_likes_enabled":true,"jetpack_featured_media_url":"https:\/\/i0.wp.com\/reliablesoftwares.com\/blog\/wp-content\/uploads\/2015\/12\/query-editor.png?fit=1444%2C989","_links":{"self":[{"href":"http:\/\/reliablesoftwares.com\/blog\/wp-json\/wp\/v2\/posts\/1941","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/reliablesoftwares.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/reliablesoftwares.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/reliablesoftwares.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/reliablesoftwares.com\/blog\/wp-json\/wp\/v2\/comments?post=1941"}],"version-history":[{"count":1,"href":"http:\/\/reliablesoftwares.com\/blog\/wp-json\/wp\/v2\/posts\/1941\/revisions"}],"predecessor-version":[{"id":1943,"href":"http:\/\/reliablesoftwares.com\/blog\/wp-json\/wp\/v2\/posts\/1941\/revisions\/1943"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/reliablesoftwares.com\/blog\/wp-json\/wp\/v2\/media\/1942"}],"wp:attachment":[{"href":"http:\/\/reliablesoftwares.com\/blog\/wp-json\/wp\/v2\/media?parent=1941"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/reliablesoftwares.com\/blog\/wp-json\/wp\/v2\/categories?post=1941"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/reliablesoftwares.com\/blog\/wp-json\/wp\/v2\/tags?post=1941"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}