Bob Jonkman reshared this.
Okay, sqlitebrowser (from the #Debian repositories) is actually a pretty decent tool. It provides a nice point-and-click interface that makes working with #sqlite3 databases a little bit nicer. Knowledge of how to write an #SQL query is still a requirement, but it makes creating/editing tables more convenient. Maybe it's well known, but I just discovered it yesterday.
Edit: sqlite browser, not mysqlbrowser
This entry was edited (3 months ago)
like this
reshared this
screwlisp
in reply to Jonathan Lamothe • • •Philipp :emacs: :nixos:
in reply to Jonathan Lamothe • • •Jonathan Lamothe
in reply to Philipp :emacs: :nixos: • •@Philipp :emacs: :nixos:
Hasn't been fully decided yet. I'm presently working with an SQLite database, though it's already migrated from LibreOffice Base (don't ask).
I'm trying to build a nice front-end on it so my wife can use it without having to learn SQL. I've worked with
persistent-sqlitebefore because ofyesod, but setting it up as a standalone thing is a pain, and it really irks me that I need a whole separate library (esqueleto) just to do joins. I mean, isn't that the whole point of SQL in the first place?Side note: I kept responding to the wrong post.
Philipp :emacs: :nixos: likes this.
Boyd Stephen Smith Jr.
in reply to Jonathan Lamothe • • •I hear talking to PostgreSQL can be enjoyable.
But, I fear there will always be issues with partiality and overlaps when modeling sum (or Pi!) types in SQL.
$dayjob is still just composing and running untyped, unstructured "SQL", but we are also still talking to MS SQL which is well-known to be unfriendly even compared to other SQL DBs.
Jonathan Lamothe
in reply to Boyd Stephen Smith Jr. • •like this
Boyd Stephen Smith Jr. and Philipp :emacs: :nixos: like this.
HΓ©cate Moonlight
in reply to Jonathan Lamothe • • •@hackage/hpqtypes-extras
Flora