Our great sponsors
|3 days ago||2 days ago|
|MIT License||GNU General Public License v3.0 or later|
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
is it a good idea to develop a database with direct rest API access??
2 projects | reddit.com/r/rust | 21 Mar 2023
Is a custom CMS a bad idea?
2 projects | reddit.com/r/webdev | 20 Mar 2023
wait till you find out https://github.com/PostgREST/postgrest.
How to use Supabase RLS with third-party client library?
2 projects | reddit.com/r/Supabase | 17 Feb 2023
Yes that's exactly what I'm reading here and there. It seems to be the approach that Supabase is taking itself when receiving queries via their API gateway, powered by PostgREST. I had a look at the source code for the latter and it's basically converting the claims in the received JWT into as many local set_config() calls (basically a wrapper function around SET LOCAL). See this related discussion.
Can't link fresh project - problem with underlying postgrest version not supporting 15.
2 projects | reddit.com/r/Supabase | 29 Jan 2023
I suspect this is the culprit (might be wrong): https://github.com/PostgREST/postgrest/blob/main/src/PostgREST/Config/PgVersion.hs
Show HN: Rest – Instant RESTful API on Any SQL Database
2 projects | news.ycombinator.com | 26 Jan 2023
Pretty cool - wonder how it compares to Postgrest (https://postgrest.org/).
Generally been a fan of these sorts of models - SQL data is very malleable - and treating the tables as movable from the start really helps move faster as a developer - database migrations become easier as you don't need to do a lot of work with API.
I can see how this would cause problems if you always used this in production after finding a fit for the data model - but for rapid prototyping and development - big fan.
Architecture Pitfalls: Don’t use your ORM entities for everything — embrace the SQL!
5 projects | reddit.com/r/programming | 12 Jan 2023
Just as an addendum, the supabase.com team are bullish on the power and value of leaning heavily into the database. iirc, they're also the team behind postgREST which makes it easy to spin up a full REST API on the back of a PostgREST database. I used to think this kind of approach was a disaster, but I've changed my mind significantly. When being willing to use stored procedures, you can spin up this REST API, AND use the same stored procedures for your application as well, to ensure consistency of business logic, all without needing a separate business logic API middleware service between DB and the rest of the world. It's not all roses, but it is pretty amazing.
PostgREST – Serve a RESTful API from Any Postgres Database
22 projects | news.ycombinator.com | 29 Dec 2022
At work, we've finally replaced a large part of a custom (mostly-)web backend with PostgREST recently, and that's quite a relief: considerably less code to maintain in that project now, and that was a rather awkward code. Something akin to PostgREST's "Embedding with Top-level Filtering"  had to be provided for all the tables, with OpenAPI schema and a typed API (Haskell + Servant); I avoided manually writing it all down, but at the cost of poking framework internals, and maintainability suffered. It was particularly annoying that the code doesn't really do anything useful, except for standing between a database and an HTTP client, and simply mimics the database anyway. Whenever a change had to be introduced, it was introduced into the database, the backend, and the frontend simultaneously, so it wasn't even useful for some kind of compatibility.
Now PostgREST handles all that, and only a few less trivial endpoints are handled by a custom backend (including streaming, which I'm considering replacing with postgrest-websocket  at some point).
During the switch to PostgREST, the encountered minor issues were those with inherited tables (had to set a bunch of computed/virtual columns  in order to "embed" those), and with a bug on filtering using such relations (turned out it was an already-fixed regression , so an update helped). Also a couple of helper stored procedures (to use via /rpc/) for updates in multiple tables at once (many-to-many relationships, to edit entities along with their relationships, using fewer requests) were added (though the old custom backend didn't have that), the security policies were set from the beginning, the frontend was rewritten (which allowed to finally switch without adding more work), so it was only left to cleanup the backend.
Not using views, since as mentioned above, database changes usually correspond to frontend changes, and the API doesn't have to be that stable yet.
Happy with it so far.
 https://postgrest.org/en/stable/api.html#computed-virtual-co...22 projects | news.ycombinator.com | 29 Dec 2022
For how often Nix is mentioned here on HackerNews, has anybody looked at the Nix config files for this repo to build it locally?
Looking for a boilerplate
3 projects | reddit.com/r/SaaS | 25 Dec 2022
I don't know for the stack you're looking for but is this close enough ? https://github.com/PostgREST/postgrest
Should I replace all db select query REST APIs with a single generic router ?
3 projects | reddit.com/r/golang | 19 Dec 2022
It's neither MySQL nor Go, but https://github.com/PostgREST/postgrest has figured out most of the patterns and API designs you could follow.
Building a Cloud Database from Scratch: Why We Moved from C++ to Rust
5 projects | news.ycombinator.com | 10 Feb 2023
I would like to know your advice, I am creating an inventory control software, and I would like to use the PostgreSQL database instead of SQL Server, Could you give me your opinions of the advantages and disadvantages of using one or the other, Thank you.
3 projects | reddit.com/r/dotnet | 15 Jan 2023
Question: What is the Best Way to Store a ~10 Terabytes of Time Series Data?
2 projects | reddit.com/r/bigdata | 6 Jan 2023
Have you heard of timescale? https://www.timescale.com/ Seems similar to ocient but specifically for time series data.
Day 23: CI using timescaledb a PostgreSQL based time series database
3 projects | dev.to | 23 Dec 2022
Slowly I understood that instead of a vanilla PostgreSQL database I need to use to use Timescale which is based on PostgreSQL. I am sure others would have come to this conclusion much faster than I did.
Is Postgresql integration well supported in Julia?
3 projects | reddit.com/r/Julia | 27 Sep 2022
Good question... haha I haven't really considered it. I'm no too versed in this domain and so the whole project will be a learning experience. One of the things is that it will include time-series harvest data. I was searching around for ways to implement this and found solutions like TimescaleDB and InfluxDB. Seems like also there are just some plugins that can sit on top of PostgreSQL.
TimescaleDB 2.7 vs. PostgreSQL 14
4 projects | news.ycombinator.com | 22 Sep 2022
What tools should I use to gather custom metrics about my Django application?
4 projects | reddit.com/r/django | 8 Sep 2022
We use Grafana on top of Timescale for metric analytics. It's working pretty well -- we're doing a few dozen events a second.
How we made data aggregation on PostgreSQL better and faster
4 projects | news.ycombinator.com | 21 Jun 2022
(NB - blog author/Timescale employee)
One thing we're improving as we move forward in documentation and other areas is explaining why doing joins (and things like window functions) is difficult in continuous aggregates and not the current focus. Honestly, it's part of the reason most databases haven't tackled this problem before.
Once you add in joins or things that might refer to data outside of the refresh window (LAG values for example), things get really complicated. For instance, if you join to a dimension table and a piece of metadata changes, does that change now need to be updated and reflected back in all of this historical aggregate data that's outside of the automatic refresh policy? Same with a window function - if data within a window hasn't changed but data that *might* be hit because of the window function reference does change, continuous aggregates would have to know about that for each query and track those changes too.
I'm not saying it's impossible or that it won't be solved someday, but the functionality with continuous aggregates that keeps the aggregate data updated automatically (without losing any history) *and* being able to perform fast joins on the finalized data is a very useful step that's not available anywhere else within the Postgres ecosystem.
RE: CAGG on top of a CAGG - you're certainly not the only person to request this () and we understand that. Part of this is because of what I discussed above (tracking changes across multiple tables), although having finalized data might make this more possible in the future.
That said (!!!), the cool thing is that we already *have* begun to solve this problem with hyperfunction aggregates and 2-step aggregation, something I showed in the blog post. So, if your dataset can benefit from one of the hyperfunction aggregates that we currently provide, there are lots of cool things you can do with it, including rollups into bigger buckets without creating a second continuous aggregate! If you haven't checked them out, please do! 
Ingesting an S3 file into an RDS PostgreSQL table
3 projects | dev.to | 10 Jun 2022
either we go for RDS, but we stick to the AWS handpicked extensions (exit timescale, citus or their columnar storage, ... ),
SyMon - System monitoring/alerting tool written in Go
2 projects | reddit.com/r/golang | 6 Jun 2022
It could make sense to switch to a timescales db which could store and query timescales much more efficient than mariadb. Of course, for the indented small use-cases mariadb could still be more than enough. For postgresql, there would be the https://github.com/timescale/timescaledb extension.
What are some alternatives?
Hasura - Blazing fast, instant realtime GraphQL APIs on your DB with fine grained access control, also trigger webhooks on database events.
supabase - The open source Firebase alternative. Follow to stay updated about our public Beta.
ClickHouse - ClickHouse® is a free analytics DBMS for big data
promscale - [DEPRECATED] Promscale is a unified metric and trace observability backend for Prometheus, Jaeger and OpenTelemetry built on PostgreSQL and TimescaleDB.
TDengine - TDengine is an open source, high-performance, cloud native time-series database optimized for Internet of Things (IoT), Connected Cars, Industrial IoT and DevOps.
GORM - The fantastic ORM library for Golang, aims to be developer friendly
postgres-websockets - PostgreSQL + Websockets
temporal_tables - Temporal Tables PostgreSQL Extension
Telegraf - The plugin-driven server agent for collecting & reporting metrics.
Appwrite - Secure Backend Server for Web, Mobile & Flutter Developers 🚀 AKA the 100% open-source Firebase alternative.
pgbouncer - lightweight connection pooler for PostgreSQL
metabase-clickhouse-driver - ClickHouse database driver for the Metabase business intelligence front-end