SQLPage - Build SQL-only websites Reviews and details

Social recommendations and mentions

• SQLPage – Building a full web application with nothing but SQL queries [video]

  Saving a few clicks for readers: Project page: https://sql.ophir.dev/. - Source: Hacker News / 2 months ago

• Bruno

  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

• Apache Superset

  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 / 2 months ago

• PostgREST: Providing HTML Content Using Htmx

  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 think I need to go lie down

  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

• Portugal. The Man – Official Website Is a Google Sheets Document

  The official website for SQLPage (https://sql.ophir.dev/) is written in SQLPage. The source code is here: https://github.com/lovasoa/SQLpage/tree/main/examples/official-site The github README has code snippets and associated screenshots: https://github.com/lovasoa/SQLpage#examples And SQLPage cloud is coming: https://sql.ophir.dev/your-first-sql-website/hosted.sql. - Source: Hacker News / 6 months ago

• A modern, open-source spreadsheet that goes beyond the grid

  Yes ! Maybe I'm old-fashioned, but I do still think that SQL is a better interface to databases than excel formulas. I am building an open-source tool that allows quickly building web user interfaces on top of relational databases [1]. Among users are many people without a CS background, and without prior knowledge of SQL. And from the feedback I get, the pain point for getting started is very rarely learning SQL.... - Source: Hacker News / 6 months ago

• Omnigres: Postgres as a Platform

  Nice to see Omnigres trending on hn; congratulations Yurii! The project is interesting, and thought provoking, because it goes against the often recommended "good practice" of separating storage and compute. Doing the exact opposite has a lot to offer in terms of performance, simplicity, and speed of development. I am currently also working on a database-first web application framework [1], with different goals... - Source: Hacker News / 7 months ago

• Ask HN: What do you like to see in tech talks?

  Hey HN community! I'll be making my first ever presentation at a large tech conference at pgconf.eu this December, where I'll be presenting the SQLPage webapp micro-framework ( https://sql.ophir.dev/ ). I'm eager to make a lasting impression and deliver a presentation that truly resonates with the audience at the conference, who probably knows more about postgres than I do. That's where I could use your insights.... - Source: Hacker News / 7 months ago

• Show HN: A open-source financial accounting alternative to QuickBooks

  When I see that, I always wonder whether this is part of the business plan of the people who distribute open source software for free, with a paid hosted version. There is some kind of a conflict of interest: the easier the software is to install and operate, the less attractive the hosted version. I am working on an open-source software with a hosted version myself ( https://sql.ophir.dev ). It's a website... - Source: Hacker News / 8 months ago

• Launch HN: Refine (YC S23) – Open-Source Retool for Enterprise

  There is a lot of activity in this space, and I think it's a good thing. Other very similar solutions include appsmith, tooljet, or budibase. How do you differentiate from them ? In the same spirit, but SQL-only instead of based on javascript, I am currently working on https://sql.ophir.dev . It also allows building entire data-centric applications and internal tools very quickly, but without having to think about... - Source: Hacker News / 9 months ago

• Repeating Yourself Thrice Doesn’t Turn You into a 3x Developer

  Hey Ophir here, I'm the co-author of the post. What you say is on-point, and we should have mentioned it in the post. The way I see it is: at the beginning, everything is repeated three times on the three layers. Then, as time advances, complexity grows, and you start having much more specific requirements that will need one of the layers to differ slightly. The common approach is to just duplicate everything... - Source: Hacker News / 10 months ago

• PRQL, Pipelined Relational Query Language

  I am currently building a SQL-only web framework [1], and I was contacted by the prql folks to include the language by default in sqlpage. I have to say, I have mixed feelings about it: on one hand, it indeed feels more natural to query data with a clean pipeline of operators. On the other hand, it makes me think of the famous xkcd comic about standards [2]: there were too many data querying languages, so we made... - Source: Hacker News / 10 months ago

• What's everyone working on this week (28/2023)?

  Still working on SQLPage (building SQL-only websites) ✴️. Source: 10 months ago

• Roast My Opensource Project

  SQLPage gives you simplicity and agility. It allows you to iterate swiftly on your app idea, putting it in front of users from day one, and gathering valuable feedback. Should your idea prove successful, you can gradually transition to a heavier framework while preserving the database structure and queries you've already built with SQLPage. Iterate quickly on what matters: your problem domain model, not your fancy... Source: 10 months ago

• Introducing SQLPage : write websites entirely in SQL

  Hey ! Sure ! The homepage mentions a few use cases, but to sum it up in one sentence, it's : Build an app in an afternoon, without locking yourself into a proprietary ecosystem that doesn't scale. Source: 10 months ago

• Introducing SQLPage : write websites entirely in SQL

  SQLPage is a web server that executes .sql files and renders the result as web pages, allowing the creation of entire dynamic websites in SQL. Source: 10 months ago

• Is ORM still an anti-pattern?

  SQL is much more powerful than most people think, and taking an afternoon to learn everything you can do with it is a great investment. After you do that, you will probably not WANT an ORM anymore, finding that it makes your code less readable than plain sql, not simpler. Actually, you'll even realize that you may not need anything BUT sql to write your application, using something like (shameless plug) SQLPage... - Source: Hacker News / 11 months ago

• SQLPage

  SQLPage is a web server that takes your .sql files, executes them on demand with parameters coming from the web request, and formats the results using pre-built web components that you can assemble to build full dynamic websites. Source: 11 months ago