188 points by khanmitdoit 9 days ago | 20 comments
lovasoa 9 days ago
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 !

frectonz 9 days ago
The ui is mostly shadcn/ui (https://ui.shadcn.com/).
lovasoa 9 days ago
Thanks! I didn't know about it, and it looks great.
frectonz 9 days ago
Thanks, I appreciate it. SQLpage looks like a cool idea, will look into it more.
runlaszlorun 9 days ago
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.

lovasoa 8 days ago
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.

kayson 9 days ago
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?
frectonz 9 days ago
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.
8mobile 9 days ago
Hi, currently I think it is the best Single binary, single command SQLite database explorer. thanks
simplify 9 days ago
Love that it has a Nix package! Curious about the docker dependency, is that needed?
maxlin 9 days ago
no screenshot of a visualization tool. Instant L
llagerlof 9 days ago
This is a classic example of good developers who miss important key points in marketing.
ks2048 9 days ago
Homepage seems broken, https://sqlite-studio.frectonz.io/
qwertox 9 days ago
I have the same issue. Even with uBlock disabled, but PiHole still enabled. Console doesn't log any errors and Network shows nothing blocked.
riiii 8 days ago
Something feels very off about this project.
efilife 8 days ago
why? I don't see anything suspicious
frectonz 9 days ago
Yeah seems like there was DB locking issue or sth, just restarted the server, will be fixed soon.
gigatexal 9 days ago
The read me could benefit from a picture of what it is like to use.
galaxyLogic 9 days ago
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?

frectonz 9 days ago
yeah sorry, i didn't know there was another tool with the same name, i will change it soon.
dotandgtfo 8 days ago
DuckDB support would be great!
postepowanieadm 8 days ago
I believe during websqlite considerations there was an idea to integrate a simple ui into the browser? I really can't find it anymore.
webprofusion 9 days ago
Windows Defender says: Trojan:Script/Wacatac.H!ml : severe

Do not download.

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

oefrha 8 days ago
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.
arp242 8 days ago
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...

jdthedisciple 8 days ago
Defender detected the same "Trojan" when I downloaded redbean recently.

Most likely a false positive.

efilife 8 days ago
windows always flags my software as wacatac too, even if it's harmless
chris_pie 8 days ago
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.
wiradikusuma 8 days ago
D2 from CloudFlare is seriously in need of a GUI like this (or, really, any GUI).
mvdtnz 9 days ago
Come on man, you need to lead with a bit more of a README than that.
wanderingstan 9 days ago
Yes, a screenshot would do wonders. From the readme theres no telling if it’s a CLI tool, a Qt thing, or whatever.
frectonz 9 days ago
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.

SamBam 9 days ago
Second link seems hugged.
frectonz 9 days ago
Yeah that's true. I didn't think people would be this interested. Will add more info.
cottsak 9 days ago
i was looking for the screenshot too.
frectonz 9 days ago
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).
giis 9 days ago
At-least for now, you need to move these into readme.md These animated gif gives better idea about this tool! nice work!
frectonz 8 days ago
Thanks, i have moved them now.
abbbi 8 days ago
looks nice, does it support presets like datasette?
ananya_paw 8 days ago
we already have drizzle studio, are there more features in this than that
mesrine 8 days ago
on Windows, i have got a security warnig.
nanidin 9 days ago
"SQLite Studio" seems like a poor choice of name given that it's already in use[0].

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

killingtime74 9 days ago
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

SigmundurM 8 days ago
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"."

otteromkram 9 days ago
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

killingtime74 9 days ago
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.

Archelaos 9 days ago
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?

killingtime74 9 days ago
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).

frectonz 9 days ago
Creator here, sorry, i didn't know the name was taken, i will rename it soon.
cottsak 9 days ago
This is the kind of laser focus I need with my side projects!! not even looking around. Just grinding out an idea!! amazing work!
metadat 9 days ago
Yes, hopefully they'll rename to "SQLite Explorer" or similar, I like both!
8 days ago
SoothingSorbet 9 days ago
I'd also appreciate a comparison to DB Browser for SQLite (https://sqlitebrowser.org/)
adonese 8 days ago
i like sqlitebrowser, but i wish it had a cli interface. this seems to fill in this gap.
okr 8 days ago
A cli interface? What do you mean? Other than the provided one?
adonese 8 days ago
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

8 days ago
8 days ago