6 ms·
Show HN: SQLite Database Explorer
SQLite database explorer
- nanidin 2y ago"SQLite Studio" seems like a poor choice of name given that it's already in use[0]. [0] https://sqlitestudio.pl/ https://sqlitestudio.pl/.
- metadat 2y agoYes, hopefully they'll rename to "SQLite Explorer" or similar, I like both!
- frectonz 2y agoCreator here, sorry, i didn't know the name was taken, i will rename it soon.
- cottsak 2y agoThis is the kind of laser focus I need with my side projects!! not even looking around. Just grinding out an idea!! amazing work!
- killingtime74 2y agoTechnically both these projects are infringing trademarks. SQLite is a trademarked term by the SQLite authors. OP is not more wrong than https://sqlitestudio.pl/ https://sqlitestudio.pl/. If https://sqlitestudio.pl/ 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 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 https://sqlite.org/consortium_agreement-20071201.html
- Archelaos 2y agoIs 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 2y agoI 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/madrid-protocol 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).
- otteromkram 2y agoThe 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 https://github.com/vapor/sqlite-kit/pull/52/files
- killingtime74 2y agoThere 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.
- deleted 2y ago[deleted]
- ks2048 2y agoHomepage seems broken, https://sqlite-studio.frectonz.io/ https://sqlite-studio.frectonz.io/
- lovasoa 2y agoI 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 https://github.com/lovasoa/SQLpage . If people know other lesser-known tools in this space, I'm interested !
- frectonz 2y agoThanks, I appreciate it. SQLpage looks like a cool idea, will look into it more.
- frectonz 2y agoThe ui is mostly shadcn/ui (https://ui.shadcn.com/ https://ui.shadcn.com/).
- lovasoa 2y agoThanks! I didn't know about it, and it looks great.
- runlaszlorun 2y agoSQLpage 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 2y agoIf you do, please share the results of your exploration here: https://github.com/lovasoa/SQLpage/discussions https://github.com/lovasoa/SQLpage/discussions We love to see what other people build.
- mvdtnz 2y agoCome on man, you need to lead with a bit more of a README than that.
- frectonz 2y agoYeah that's true. I didn't think people would be this interested. Will add more info.
- cottsak 2y agoi was looking for the screenshot too.
- frectonz 2y agoYou can checkout the hosted preview (https://sqlite-studio.frectonz.io/ https://sqlite-studio.frectonz.io/). We also have some screenshots on the github releases page (https://github.com/frectonz/sqlite-studio/releases https://github.com/frectonz/sqlite-studio/releases).
- wanderingstan 2y agoYes, a screenshot would do wonders. From the readme theres no telling if it’s a CLI tool, a Qt thing, or whatever.
- frectonz 2y ago
- galaxyLogic 2y agoWhen 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 2y agoyeah sorry, i didn't know there was another tool with the same name, i will change it soon.
- kayson 2y agoSounds 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 2y agoIt 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 http://127.0.0.1:3030". When you open that page you will see the dashboard.
- maxlin 2y agono screenshot of a visualization tool. Instant L
- llagerlof 2y agoThis is a classic example of good developers who miss important key points in marketing.
- SoothingSorbet 2y agoI'd also appreciate a comparison to DB Browser for SQLite (https://sqlitebrowser.org/ https://sqlitebrowser.org/)
- adonese 2y agoi like sqlitebrowser, but i wish it had a cli interface. this seems to fill in this gap.
- deleted 2y ago[deleted]
- webprofusion 2y agoWindows Defender says: Trojan:Script/Wacatac.H!ml : severe Do not download. [Edit: could be a false positive. Do you feel lucky?]
- efilife 2y agowindows always flags my software as wacatac too, even if it's harmless
- jdthedisciple 2y agoDefender detected the same "Trojan" when I downloaded redbean recently. Most likely a false positive.
- oefrha 2y agoIIRC 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 2y agoA 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...
- gigatexal 2y agoThe read me could benefit from a picture of what it is like to use.
- simplify 2y agoLove that it has a Nix package! Curious about the docker dependency, is that needed?
- 8mobile 2y agoHi, currently I think it is the best Single binary, single command SQLite database explorer. thanks
- abbbi 2y agolooks nice, does it support presets like datasette?
- dotandgtfo 2y agoDuckDB support would be great!
- chris_pie 2y agoThis could use a comparison to sqlite-web. I think it's the only other web-based SQLite dashboard. Except maybe phpLiteAdmin which seems dead.
- postepowanieadm 2y agoI believe during websqlite considerations there was an idea to integrate a simple ui into the browser? I really can't find it anymore.
- mesrine 2y agoon Windows, i have got a security warnig.
- wiradikusuma 2y agoD2 from CloudFlare is seriously in need of a GUI like this (or, really, any GUI).
- deleted 2y ago[deleted]
- ananya_paw 2y agowe already have drizzle studio, are there more features in this than that