SaaSHub helps you find the best software and product alternatives Learn more →
Top 19 Ruby Postgre Projects
-
-
-
InfluxDB
Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
-
-
-
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
-
pg_easy_replicate
Easily setup logical replication and switchover to new database with minimal downtime
-
-
-
template-ruby-on-rails-postgres
A Ruby on Rails template, with Postgres, configured for Gitpod (www.gitpod.io) to give you pre-built, ephemeral development environments in the cloud.
-
-
dynamic-records-meritfront
Dynamic Records Meritfront was built to allow you to make full use of your database's capabilites, while utilizing ruby on rails & Active Record. It contains a better way to write sql queries for rails, and includes other tips and tricks to take advantage of. Perfect for all your dynamic applications, optimizations and weird edge cases!
-
rails6template
Rails 6 template with Ruby 3.0.0, Devise, Admin, and TailwindCSS 2, guard and live reload
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
> Can you define "low throughput"?
<1000 messages per minute
Not saying SKIP LOCKED can't work with that many. But you'll probably want to do something better.
FWIW, Que uses advisory locks [1]
[1] https://github.com/que-rb/que
> where you can see overlapped timelines when support ended
I tried to generate a visual timeline for a given page (https://github.com/endoflife-date/endoflife.date/pull/2859, has some screenshots), but it was limited to a single page (so you'd only see nokia devices at once for eg).
It turned out that it is too hard to generate clear charts with vague data. We often only know whether is device is supported or not (true/false, see comments about samsung below in this thread), and don't have clear release dates.
I'll get to it someday (PRs welcome), but it might not work for the usecase we want (picking phones) because data on mobiles is very vague.
repairability score -> sounds interesting, will file an issue and see. The hard part is that there's no clear identifiers for devices (SWID/CPE are just not good enough) for us to track this kind of data from elsewhere easily.
I took a 13,000 line Rails 7.0 app and updated it to 7.1. I had to change 1 line of test configuration code to make everything work.
I would say that's a success for having an easy upgrade path. Now the fun part is going back to refactor some of the code to use the new features in 7.1.
If anyone is curious, I updated my Rails / Docker example app to use 7.1 too https://github.com/nickjj/docker-rails-example. Even though Rails 7.1 comes with a Dockerfile, there's still a lot of opinions you can add such as using Docker Compose to have a fully working out of the box experience that works in development and production -- complete with Postgres, Redis, Action Cable, Sidekiq and more.
This is great! I wrote a tool that automates most of the things you came across. If you find it useful or would like to extend it with your feedback/ideas, I'd love to have them! Thanks for sharing
https://github.com/shayonj/pg_easy_replicate
My thoughts exactly. It's surprising that external online schema change tools for Postgres have only become a thing fairly recently! The only two I'm aware of are:
* pgroll: Written in Golang, first commits June 2023. https://github.com/xataio/pgroll
* pg-osc: Written in Ruby, first commits Dec 2021. https://github.com/shayonj/pg-osc
Meanwhile over in the MySQL and MariaDB ecosystem, external OSC tools have been around for quite some time, starting with oak-online-alter-table over 15 years ago. The most popular options today are pt-online-schema-change or gh-ost, but other battle-tested solutions include fb-osc, LHM, and the latest entry Spirit.
NOTE:
The open source projects on this list are ordered by number of github stars.
The number of mentions indicates repo mentiontions in the last 12 Months or
since we started tracking (Dec 2020).
Ruby Postgres related posts
-
How not to change PostgreSQL column type
-
Rails 7.1 Released
-
Rails 7.1: Dockerfiles, BYO Authentication, More Async Queries, and More
-
What are your favourite approaches to keeping on top of Postgres health?
-
Minimal downtime major PostgreSQL version upgrades with pg_easy_replicate
-
Minimal downtime major PostgreSQL version upgrades with pg_easy_replicate
-
Minimal downtime major PostgreSQL version upgrades with pg_easy_replicate
-
A note from our sponsor - SaaSHub
www.saashub.com | 10 May 2024
Index
What are some of the best open-source Postgre projects in Ruby? This list will help you:
| Project | Stars | |
|---|---|---|
| 1 | flipper | 3,573 |
| 2 | Scenic | 3,347 |
| 3 | Que | 2,288 |
| 4 | endoflife.date | 2,207 |
| 5 | ActiveRecordExtended | 1,248 |
| 6 | jsonb_accessor | 1,086 |
| 7 | docker-rails-example | 914 |
| 8 | pg_easy_replicate | 834 |
| 9 | SearchCop | 823 |
| 10 | with_advisory_lock | 613 |
| 11 | pg-osc | 484 |
| 12 | safe-pg-migrations | 482 |
| 13 | pg_party | 446 |
| 14 | simple_recommender | 121 |
| 15 | template-ruby-on-rails-postgres | 15 |
| 16 | PgDice | 10 |
| 17 | dynamic-records-meritfront | 7 |
| 18 | divisionly-api | 1 |
| 19 | rails6template | 1 |
Sponsored
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com