Show HN: SQLite Database Explorer(github.com)
github.com
Show HN: SQLite Database Explorer
https://github.com/frectonz/sqlite-studio
SQLite database explorer
58 comments
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 !
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 !
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.
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.
We love to see what other people build.
Thanks, I appreciate it. SQLpage looks like a cool idea, will look into it more.
The ui is mostly shadcn/ui (https://ui.shadcn.com/).
Thanks! I didn't know about it, and it looks great.
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?
Homepage seems broken, https://sqlite-studio.frectonz.io/
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?
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?]
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...
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.
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.
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).
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.
It is a CLI tool, that creates a local server. I will make the readme better soon.
Second link seems hugged.
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/.
[0] https://sqlitestudio.pl/.
[deleted]
Yes, hopefully they'll rename to "SQLite Explorer" or similar, I like both!
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
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"."
"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
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.
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?
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).
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).
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.
[deleted]
[deleted]