Top 23 Ruby Postgresql Projects

• Discourse

  198 40,538 10.0 Ruby

  A platform for community discussion. Free, open, simple.

  

Project mention: Discord to Start Showing Ads for Gamers to Boost Revenue | news.ycombinator.com | 2024-04-01

> Tell me another platform that is free, has realtime chat, voice and video, has stable service, allows sharing images and other media, with good ownership management... and is open source.

Mattermost: https://mattermost.com/

Rocket.Chat: https://www.rocket.chat/

Nextcloud Talk: https://nextcloud.com/talk/

Self hosting and some assembly required. I've run all of them on cheap VPSes to explore a Slack/Discord replacement, neither was mindblowing but all of them seemed okay (Nextcloud's offering was rather barebones, though).

Audio and video support varies because getting those right is challenging, at best you'd just integrate with something like Jitsi, that one's actually pretty good for meetings and such: https://jitsi.org/ and has a cloud version too: https://meet.jit.si/ (yet people still go for Zoom and it's odd UI/UX choices)

I actually rather liked forums back in the day, but I guess nobody will be setting up that many phpBB instances in the current year, though projects like Discourse also seem promising: https://www.discourse.org/

I don't think many people at all will be leaving Discord, due to how entrenched the platform is (network effect): if you want people to help you with what you're working on, you go where they are, not vice versa.

• maybe

  4 26,739 9.6 Ruby

  The OS for your personal finances

  

Project mention: 🛠️Non-AI Open Source Projects that are 🔥 | dev.to | 2024-04-04

Maybe is the story of a comeback. It was shut down in July, 2023. Not wanting to waste the $1,000,000 from investors, Maybe was open-sourced this past January as a fully transparent, open-source, community-backed personal finance app. It was hard to miss because it was trending on GitHub for the entire week.

• InfluxDB

  www.influxdata.com featured

  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.

  

• Backup

  3 4,817 4.0 Ruby

  Easy full stack backup operations on UNIX-like systems.

  

Project mention: Backup VS database - a user suggested alternative | libhunt.com/r/backup | 2023-06-21

• pgsync

  5 2,971 5.6 Ruby

  Sync data from one Postgres database to another

Project mention: PgSync: Sync data from one Postgres database to another | news.ycombinator.com | 2024-02-17

• Motor Admin

  18 1,913 6.0 Ruby

  Deploy a no-code admin panel for your application in less than a minute. Stop wasting time on custom internal tools and focus on the actual product. Motor Admin allows to launch a custom admin panel for any application.

  

• Logidze

  6 1,557 5.5 Ruby

  Database changes log for Rails

Project mention: Versioning data in Postgres? Testing a Git like approach | news.ycombinator.com | 2023-10-20

There's an interesting approach to it that works with Rails and PostgreSQL using triggers.

https://github.com/palkan/logidze

• pg_search

  7 1,230 5.6 Ruby

  pg_search builds ActiveRecord named scopes that take advantage of PostgreSQL’s full text search

  

• SaaSHub

  www.saashub.com featured

  SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

  

• Rails PG Extras

  11 1,075 5.5 Ruby

  Rails PostgreSQL database performance insights. Locks, index usage, buffer cache hit ratios, vacuum stats and more.

Project mention: What are your favourite approaches to keeping on top of Postgres health? | /r/rails | 2023-06-27

I use either PgHero or Rails PG Extras on every project

• Mobility

  3 956 7.1 Ruby

  Pluggable Ruby translation framework

• textacular

  0 936 3.9 Ruby

  Textacular exposes full text search capabilities from PostgreSQL, and allows you to declare full text indexes. Textacular will extend ActiveRecord with named_scope methods making searching easy and fun!

  

• pg_easy_replicate

  11 832 8.7 Ruby

  Easily setup logical replication and switchover to new database with minimal downtime

Project mention: Zero Downtime Postgres Upgrades | news.ycombinator.com | 2023-12-12

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

• with_advisory_lock

  1 613 6.6 Ruby

  Advisory locking for ActiveRecord

  

• online_migrations

  18 581 9.1 Ruby

  Catch unsafe PostgreSQL migrations in development and run them easier in production (code helpers for table/column renaming, changing column type, adding columns with default, background migrations, etc).

• attr_json

  7 511 6.8 Ruby

  Serialized json-hash-backed ActiveRecord attributes, super smooth

• pg-osc

  6 481 7.6 Ruby

  Easy CLI tool for making zero downtime schema changes and backfills in PostgreSQL

Project mention: Pgroll: zero-downtime, undoable, schema migrations for Postgres | news.ycombinator.com | 2023-10-03

Great to see more innovation in this space! How does this compare to?

https://github.com/shayonj/pg-osc

• pg_party

  1 443 3.8 Ruby

  ActiveRecord PostgreSQL Partitioning

• ekylibre

  2 401 7.9 Ruby

  Open source Farm management Information System (FMIS) - Connecting farms to the world

  

• evil-seed

  1 314 10.0 Ruby

  A Gem for creating partial anonymized dumps of your database using your app model relations.

  

• datoji

  10 226 0.0 Ruby

  A tiny JSON storage service. Create, Read, Update, Delete and Search JSON data.

• rom-sql

  1 219 5.9 Ruby

  SQL support for rom-rb

  

• fast_count

  2 211 6.4 Ruby

  Quickly get a count estimation for large tables (>99% of accuracy for PostgreSQL).

Project mention: Everyday performance rules for Ruby on Rails developers | /r/rails | 2023-12-07

Counts can also be made blazingly fast (but estimate with > 99% accuracy) via https://github.com/fatkodima/fast_count.

• Ruby PG Extras

  0 124 5.6 Ruby

  Ruby PostgreSQL database performance insights. Locks, index usage, buffer cache hit ratios, vacuum stats and more.

• activerecord-slotted_counters

  1 98 7.1 Ruby

  Active Record extension providing slotted counters support

  

• SaaSHub

  www.saashub.com featured

  SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

  

Ruby Postgresql related posts

• Show HN: PostgreSQL Index Advisor

  6 projects | news.ycombinator.com | 13 Apr 2024

• Figma's Databases team lived to tell the scale

  5 projects | news.ycombinator.com | 14 Mar 2024

• PgSync: Sync data from one Postgres database to another

  1 project | news.ycombinator.com | 17 Feb 2024

• Greenmask: PostgreSQL Dump and Obfuscation Tool

  5 projects | news.ycombinator.com | 17 Feb 2024

• Ruby Outperforms C: Breaking the Catch-22

  4 projects | news.ycombinator.com | 9 Sep 2023

• Available options for migrating from Rhel6 PG10 to Rhel8 PG14

  1 project | /r/PostgreSQL | 27 Jun 2023

• What are your favourite approaches to keeping on top of Postgres health?

  3 projects | /r/rails | 27 Jun 2023
• A note from our sponsor - InfluxDB
  www.influxdata.com | 4 May 2024

  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. Learn more →

Index

Sponsored

SaaSHub - Software Alternatives and Reviews

SaaSHub helps you find the best software and product alternatives

www.saashub.com

Do not miss the trending Ruby projects with our weekly report!