No SQLPage - Build SQL-only websites videos yet. You could help us improve this page by suggesting one.
JDBI might be a bit more popular than SQLPage - Build SQL-only websites. We know about 23 links to it since March 2021 and only 19 links to SQLPage - Build SQL-only websites. We are tracking product recommendations and mentions on various public social media platforms and blogs. They can help you identify which product is more popular and what people think of it.
Saving a few clicks for readers: Project page: https://sql.ophir.dev/. - Source: Hacker News / 2 months ago
I am currently looking for a solution to run automated tests on a sql website generator I am working on ( https://sql.ophir.dev ) I wanted to use hurl (https://hurl.dev/), but Bruno's UI seems to be useful while developing the tests... Has someone tried both ? Which is better for automated testing, including when the response type is html and not json? - Source: Hacker News / 2 months ago
Full fledged BI tools like Superset and Metabase are amazing for their intended use cases. But they may be an overkill if your primary use case is to infrequently build semi-interactive reports for non-technical end-users and your use cases are are mostly covered by standard graphs & tables. Esp. So if you are familiar with SQL and have access to the underlying data source. Two nifty utilities I have found to be... - Source: Hacker News / 3 months ago
I feel obligated to add a shameless plug here. The idea is very close to a project I presented at pgconf.eu last week: SQLPage https://sql.ophir.dev/ SQLPage has the same goal as postgrest+htmx, but is a little bit higher level. It let's you build your application using prepackaged components you can invoke directly from SQL, without having to write any HTML, CSS, or JS. - Source: Hacker News / 5 months ago
I have been thinking about that a lot recently. Where I work, we spend a very small fraction of our time on building things that are unique to our business. Maybe we are doing something very wrong, but I am under the impression that most of the code that gets written is extremely low-entropy. This low-entropy, repetitive coding is not limited to the user interfaces. We do tend to describe the same structures and... - Source: Hacker News / 6 months ago
While this may work for greenfield applications, I don't see this working well for preexisting schemas. From their getting started page: "Database fields are automatically created for any abstract getter methods", which definitely scares me away since they seem to be relying on automatic field type conversions. I prefer to manage my schemas when I can and do type and DAO conversions via mapper classes in the very... - Source: Hacker News / 8 months ago
Someone else mentioned jOOQ, but personally I also rather enjoyed JDBI3: https://jdbi.org/#_introduction_to_jdbi_3 It addresses the issues with using JDBC directly (not nice ergonomics), while still letting you work with SQL directly without too many abstractions in the middle. In combination with Dropwizard, it was pretty pleasant: https://www.dropwizard.io/en/stable/manual/jdbi3.html Other than that, I actually... - Source: Hacker News / 8 months ago
> I've been doing ORM on Java since Hibernate was new, and it has always sucked. Have you ever looked at something like myBatis? In particular, the XML mappers: https://mybatis.org/mybatis-3/dynamic-sql.html Looking back, I actually quite liked it - you had conditionals and ability to build queries dynamically (including snippets, doing loops etc.), while still writing mostly SQL with a bit of XML DSL around it,... - Source: Hacker News / 11 months ago
I found JDBi[1] to be a really nice balance between ORM and raw SQL. It gives me the flexibility I need but takes care of a lot of the boilerplate. It's almost like a third category. 1. http://jdbi.org. - Source: Hacker News / 12 months ago
You could use something like jdbi or mybatis. It's not as ugly as raw jdbc and easier to use without all of the gunk from an ORM like hibernate. Source: about 1 year ago
htmx - high power tools for HTML
Hibernate - Hibernate an open source Java persistence framework project.
Gio UI - Gio is an open source library for creating portable, immediate mode GUI programs for Android, iOS, Linux, Windows, macOS.
Hibernate ORM - Hibernate team account. Hibernate is a suite of open source projects around domain models. The flagship project is Hibernate ORM, the Object Relational Mapper.
Fyne - The Fyne toolkit is an easy to learn, free and open source, platform for building graphical applications for desktop, mobile and beyond.
Postgres.js - Postgres.js - The Fastest full featured PostgreSQL client for Node.js - porsager/postgres