News AI
July 8th, 2024

DB Browser for SQLite (Windows, macOS, and Most Versions of Linux)

DB Browser for SQLite (DB4S) is an open-source tool for SQLite databases, supporting Windows, macOS, Linux, and Unix. It enables table management, data manipulation, SQL queries, and visualization features. Version 3.12.2 is current, with a 3.13.x-rc1 release. Nightly builds are also available for testing.

Read original articleLink Icon
DB Browser for SQLite (Windows, macOS, and Most Versions of Linux)

DB Browser for SQLite (DB4S) is an open-source tool designed for creating, searching, and editing SQLite database files. It offers a spreadsheet-like interface and full SQL query capabilities, working on Windows, macOS, Linux, and Unix. Users can perform various tasks such as creating, modifying, and deleting tables, browsing records, importing/exporting data, and executing SQL queries. The current official version is 3.12.2, with a release candidate 3.13.x-rc1 available for download. Additionally, nightly builds are accessible for testing purposes. The tool provides controls and wizards for database management and visualization, including features like creating compact database files, defining indexes, and plotting graphs. Over the years, the project has seen continuous updates and improvements, with support from sponsors like DigitalOcean and Patreon. The tool's website offers documentation, downloads, and insights into its development history and future releases.

Related

Show HN: WhoDB – Streamlined, Lightweight Database Management with a Sleek UI/UX

Show HN: WhoDB – Streamlined, Lightweight Database Management with a Sleek UI/UX

WhoDB is a database management tool on GitHub, developed in GoLang for speed. It includes interactive graphs for database schema visualization. Find more details on the WhoDB GitHub Repository.

WhoDB: Lightweight next-gen database explorer

WhoDB: Lightweight next-gen database explorer

WhoDB is a database management tool by Clidey, written in GoLang. It features interactive graphs for database schema visualization, supporting PostgreSQL, MySQL, SQLite3, MongoDB, and Redis. It aims for Adminer's simplicity with improved user experience and performance. Access the WhoDB GitHub Repository for details.

Optimizing Large-Scale OpenStreetMap Data with SQLite

Optimizing Large-Scale OpenStreetMap Data with SQLite

The article discusses optimizing large-scale OpenStreetMap data with SQLite. Converting OSMPBF to SQLite enhanced search functionalities. Indexing, full-text search, and compression improved query performance, despite some false positives.

The Ultimate Database Platform

The Ultimate Database Platform

AverageDB, a database platform for developers, raised $50 million in funding. It offers speed, efficiency, serverless architecture, real-time data access, and customizable pricing. The platform prioritizes data privacy and caters to diverse user needs.

TinyBase v5: CRDTs for the rest of us

TinyBase v5: CRDTs for the rest of us

TinyBase is a versatile reactive data store for local-first apps, featuring data listening, synchronization, local storage, and schema support. It offers tools for key-value stores, tabular data, React integration, and complex queries.

Link Icon 28 comments
By @lucydodo - 5 months
Hello Hacker News! I'm one of the maintainers of this project.

Thank you for featuring our project here, and we will be releasing a new stable version soon, so stay tuned for the new version! If you have any further comments, suggestions, or questions about the project, please feel free to leave an issue in our repository! Thank you.

By @moonshinefe - 5 months
The killer feature for me with this app is the stupidly easy CSV loading. I deal with huge CSVs at work often. SQLite Browser is the easiest, fastest and most lightweight UI tool to analyze them I've tried. It can load millions of records into a table in like <3 seconds. Then obviously you can query the CSV data via SQL.
By @noman-land - 5 months
I seriously love this app. I use it nearly every day. I scoured the net looking for a FOSS sqlite Mac app with a table exploring GUI. This is the best one!
By @zie - 5 months
If you are looking for another one: I use https://sqlitestudio.pl which is GPL-3 only and also cross platform. I'm not sure I ever compared them, I think I just came across sqlitestudio first and it stuck.
By @heavyset_go - 5 months
Another similar open source app is DBeaver: https://dbeaver.io/

Works with more than just SQLite.

By @runjake - 5 months
Great software. I use it almost every day. But, posted many times before:

https://news.ycombinator.com/from?site=sqlitebrowser.org

By @me551ah - 5 months
Been using this software for a decade and it’s hands down the best SQLite browser and DB editor that I have seen.
By @tester457 - 5 months
For the CLI there's litecli. It has auto-completion and syntax highlighting.

https://github.com/dbcli/litecli

By @ocdtrekkie - 5 months
This is my go-to while I've been working on a SQLite-based app to see what's actually in the database.
By @zoomablemind - 5 months
There used to be a Firefox plugin with much similar features. However since the change of Firefox plugin arch, it's no longer available.
By @aabbcc1241 - 5 months
I'm teaching people dev with sqlite, and DB Browser is a few tools I recommend them to download (alone with VSCode and Meld)
By @Shalomboy - 5 months
This application single-handedly underpins the entire competitive/online yugioh space. Thank you for your excellent work!
By @iKlsR - 5 months
Great project, came in super handy on a project and I needed a way to mass import csv files which wasn't a feature at the time (7 years ago), threw together a PR over a weekend and the kind maintainers helped get it in. The chief maintainer at the time Justin is a cool guy, donate if you can.
By @bigyikes - 5 months
I have this app open right now, actually. It's honestly... okay. I wish I had something better installed. It gets the job done, but the UI leaves something to be desired. It's free though, so I can't complain. I use it to manage my local financial transaction database.
By @vekker - 5 months
I don't know why, but this program had difficulty opening what was clearly a correct SQLite3 database file (created with TypeORM) on Ubuntu 22.04. "Reason: Invalid file format". I ended up using Beekeeper Studio instead, which didn't have any problems with that file. I wonder if that bug is fixed.
By @GGerome - 5 months
I am a huge fan of this app that is the Toad like equivalent for Sqlite for me. Keep up this excellent work!
By @webprofusion - 5 months
Use this a lot, doesn't seem to get many releases but it looks like there's one coming soon.
By @sanjaysubra - 5 months
Very useful app in my day job as a Windows dev, it works flawlessly and is quite reliable.
By @asmr - 5 months
I guess devs haven't ventured down the rabbithole of public DBs? Not trying to be a jerk, just honestly surprised this is on the front page.
By @RamblingCTO - 5 months
Awesome, other than the vscode sqlite browser I can actually view dbs using sqlite-vss!
By @czaxvgdcs - 5 months
Oddly the release version doesn’t support strict tables. Nightly does.

I moved to beaver and it’s mostly been fine.

By @julius-fx - 5 months
My favorite for years - love it.
By @lbj - 5 months
Looks very nice - I'm still hard-stuck in EJC, the convenience is just unbeatable.
By @xwat - 5 months
The best
By @digitalsankhara - 5 months
Would really like to have a dedicated DuckDB version of this please. Also, add in a few simple tools for analytics - basic chart, pivot table tool, ETL etc. Nothing fancy, just enough to scope out the data before building pipelines/reports etc.

No rush - tomorrow is fine :-)

Thanks.

By @winstonp - 5 months
Would love one that looks as slick as Supabase's web ui
By @pjmlp - 5 months
Looks great, specially for not being yet another Chrome shell.

Good job!