Hacker News new | past | comments | ask | show | jobs | submit login
Show HN: SQLite Database Explorer (github.com/frectonz)
188 points by khanmitdoit 9 days ago | hide | past | favorite | 55 comments
SQLite database explorer





I love the UI ! It's clean and beautiful.

What CSS framework did you use ?

I also maintain a database visualization tool (more of a SQL-to-UI tool, actually), where I use tabler.io for styling: https://github.com/lovasoa/SQLpage . If people know other lesser-known tools in this space, I'm interested !


The ui is mostly shadcn/ui (https://ui.shadcn.com/).

Thanks! I didn't know about it, and it looks great.

Thanks, I appreciate it. SQLpage looks like a cool idea, will look into it more.

SQLpage is very interesting. I’d had some recent thoughts on the idea but was only thinking around sql queries + handlebars templates.

Looks like you’ve already done that plus pushed the SQL idea much further. I’ll def have to check this out when I get some time.


If you do, please share the results of your exploration here: https://github.com/lovasoa/SQLpage/discussions

We love to see what other people build.


Sounds really cool but I have no idea how it works from the README. It appears to be web-based. Is it generating static html? Starting a web server? How do I access it?

It is a CLI tool that starts a local web server. After you install it, you can run `sqlite-studio <your_db>` and then you will see a log that says "listening on http://127.0.0.1:3030". When you open that page you will see the dashboard.

Hi, currently I think it is the best Single binary, single command SQLite database explorer. thanks

Love that it has a Nix package! Curious about the docker dependency, is that needed?

no screenshot of a visualization tool. Instant L

This is a classic example of good developers who miss important key points in marketing.

Homepage seems broken, https://sqlite-studio.frectonz.io/

I have the same issue. Even with uBlock disabled, but PiHole still enabled. Console doesn't log any errors and Network shows nothing blocked.

Something feels very off about this project.

why? I don't see anything suspicious

Yeah seems like there was DB locking issue or sth, just restarted the server, will be fixed soon.

The read me could benefit from a picture of what it is like to use.

When I go to the page it says I'm looking at the page of SQLite Studio release 0.1.3.

But I already have something called SQLite Studio version 3.4.4 installed on my PC.

Is this confusing naming or what?


yeah sorry, i didn't know there was another tool with the same name, i will change it soon.

DuckDB support would be great!

I believe during websqlite considerations there was an idea to integrate a simple ui into the browser? I really can't find it anymore.

Windows Defender says: Trojan:Script/Wacatac.H!ml : severe

Do not download.

[Edit: could be a false positive. Do you feel lucky?]


IIRC Windows Defender flags my Go binaries as this trojan all the time, especially if I build with -H windowsgui to hide the console window. That signature is trash.

A fair amount of actual malware is written in Go. One important reasons is probably because being statically compiled by default simplifies the whole deployment story, which matters even more for malware than many other things.

Go binaries share a lot of the same code: the Go runtime, stdlib. And the heuristics malware scanners use seem to have trouble with that.

Or at least: that's always been my assumption why so many legit Go binaries get flagged, but I don't really work in this space so what do I know...


Defender detected the same "Trojan" when I downloaded redbean recently.

Most likely a false positive.


windows always flags my software as wacatac too, even if it's harmless

This could use a comparison to sqlite-web. I think it's the only other web-based SQLite dashboard. Except maybe phpLiteAdmin which seems dead.

D2 from CloudFlare is seriously in need of a GUI like this (or, really, any GUI).

Come on man, you need to lead with a bit more of a README than that.

Yes, a screenshot would do wonders. From the readme theres no telling if it’s a CLI tool, a Qt thing, or whatever.

We have some screenshots on the github releases page (https://github.com/frectonz/sqlite-studio/releases). Would be better to take a look at the hosted preview (https://sqlite-studio.frectonz.io/) though.

It is a CLI tool, that creates a local server. I will make the readme better soon.


Second link seems hugged.

Yeah that's true. I didn't think people would be this interested. Will add more info.

i was looking for the screenshot too.

You can checkout the hosted preview (https://sqlite-studio.frectonz.io/). We also have some screenshots on the github releases page (https://github.com/frectonz/sqlite-studio/releases).

At-least for now, you need to move these into readme.md These animated gif gives better idea about this tool! nice work!

Thanks, i have moved them now.

looks nice, does it support presets like datasette?

we already have drizzle studio, are there more features in this than that

on Windows, i have got a security warnig.

"SQLite Studio" seems like a poor choice of name given that it's already in use[0].

[0] https://sqlitestudio.pl/.


Technically both these projects are infringing trademarks. SQLite is a trademarked term by the SQLite authors. OP is not more wrong than https://sqlitestudio.pl/. If https://sqlitestudio.pl/ is using the mark under license, they haven't indicated that anywhere (usually a requirement).

See this Github post where SQLite author asserts his trademark https://github.com/vapor/sqlite-kit/issues/47 on another project that uses SQLite in the name.

Both projects should change their names.

While SQLite is open source, the trademark is retained by the authors https://sqlite.org/consortium_agreement-20071201.html


The SQLite author says in the last paragraph of the sqlite-kit issue:

"You are welcomed to use "SQLite" as part of the name for your software, so that people know that it uses SQLite. For example, you might call your software "SQLite Wrapper for Swift" or "Vapor's Swift SQLite Wrapper". But you may not use the unqualified name "SQLite"."


The SQLite author wanted them to change their name because it was literally called "SQLite," not because it had SQLite in the name.

From the linked GitHub issue:

> Please do NOT use the name "SQLite" for your project.

Resolution PR: https://github.com/vapor/sqlite-kit/pull/52/files


There is on the one hand what the Author wanted in this case, and what the law is on the other. He may have many reasons for not enforcing his rights to the maximum extent.

He may want to be nice, or have done a deal or any number of reasons. That doesn't mean he can't stop them from using it altogether.

Also he can change his mind down the track.

Whether it is infringing or not is up to many factors in each case, but simply extending it is not going to protect you in every case.

If we want a definitive answer, would have to take this to a court.

Source: studied IP in Law school, but not a professor or anything.


Is the trademark registered internationally?

If this were not the case and a trademark is USA specific, how is is to be assessed if, as in the case of SQLite Database Explorer, someone from Ethiopia or, as in the case of SQLiteStudio, someone from Poland violates it? Or the other way round, if someone from the USA violates an Ethiopian or Polish trademark?


I went to law school in Australia over 10 years ago so things maybe have changed.

At the time we were taught about the Madrid Protocol (US implementation https://www.uspto.gov/ip-policy/international-protection/mad...), which gives you some time to register it in each country after the first registration. If you register it within this alloted time, you retain priority over other people who want to register it too.

You do have to register it, but more importantly, enforce it, yourself worldwide.

IP Lawfirms usually provide this as a service.

On the practical matter of "Is the trademark registered internationally?". Have to do a search in each country's trade mark office. It's very tedious (not every mark is in text, some are pictures, sounds).


Creator here, sorry, i didn't know the name was taken, i will rename it soon.

This is the kind of laser focus I need with my side projects!! not even looking around. Just grinding out an idea!! amazing work!

Yes, hopefully they'll rename to "SQLite Explorer" or similar, I like both!

I'd also appreciate a comparison to DB Browser for SQLite (https://sqlitebrowser.org/)

i like sqlitebrowser, but i wish it had a cli interface. this seems to fill in this gap.

A cli interface? What do you mean? Other than the provided one?

As in ipython to python. Datasets does this but for me it feels too heavy.

A simple shell with autocompletion and history can a long way as my main quick-and-dirty sql explorations




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: