Powerful document editing and collaboration in your app or environment. Ultimate security, API and 30+ ready connectors, SaaS or on-premises Learn more →
Top 23 Ruby Postgresql Projects
-
Project mention: Reddit API Pricing Would Cost Apollo Developer $20M per Year | news.ycombinator.com | 2023-05-31
-
Project mention: Backup: Ruby Gem for Easy full stack backup operations on Unix-like systems | news.ycombinator.com | 2022-07-30
-
SonarQube
Static code analysis for 29 languages.. Your projects are multi-language. So is SonarQube analysis. Find Bugs, Vulnerabilities, Security Hotspots, and Code Smells so you can release quality code every time. Get started analyzing your projects today for free.
-
Project mention: Data sync options when upgrading from v10.21 to v14.6 | reddit.com/r/PostgreSQL | 2023-02-22
pgsync from an EC2 instance that can connect to both target and destination https://github.com/ankane/pgsync
-
Motor Admin
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.
Tangential: MotorAdmin is a pretty reasonable, mountable, Rails-based option.
-
Project mention: Best rails tools to automatically handle logging of things like all a user's actions, or changes to a record in a module - primarily for audit purposes. | reddit.com/r/rails | 2023-03-09
https://github.com/palkan/logidze is my favorite for these kind of things
-
pg_search
pg_search builds ActiveRecord named scopes that take advantage of PostgreSQL’s full text search
On the backend, we'll need a few tools. Apart from the classics (ActiveRecord scopes and the pg_search gem), you’ll see how the (yet officially unreleased but production-tested) all_futures gem, built by SR authors, will act as an ideal ephemeral object to temporarily store our filter params and host our search logic. Finally, we’ll use pagy for pagination duties.
-
Rails PG Extras
Rails PostgreSQL database performance insights. Locks, index usage, buffer cache hit ratios, vacuum stats and more.
Project mention: rails-pg-extras introduces new API for measuring SQL queries generated by any Ruby snippet | reddit.com/r/rails | 2023-02-27 -
InfluxDB
Access the most powerful time series database as a service. Ingest, store, & analyze all types of time series data in a fully-managed, purpose-built database. Keep data forever with low-cost storage and superior data compression.
-
textacular
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!
-
Project mention: Marks object as dirty even if nothing was changed in RichTextTranslation fields · Issue #597 · shioyama/mobility | reddit.com/r/rails | 2022-12-12
-
-
online_migrations
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).
Project mention: Migration Magic ✨, Handling Not-Null Constraints in Production with Ruby on Rails | reddit.com/r/rails | 2023-04-05Or simply use https://github.com/fatkodima/online_migrations and don’t get bitten by migrations in production again.
-
Project mention: How to use store_accessor for nested JSON in rails | reddit.com/r/rails | 2023-03-14
https://github.com/jrochkind/attr_json (by me)
-
-
Project mention: Want to avoid MySQL but find PlanetScale really appealing | reddit.com/r/PostgreSQL | 2023-03-25
-
-
evil-seed
A Gem for creating partial anonymized dumps of your database using your app model relations.
Since it can be challenging to replicate production DB issues exactly, I would recommend creating anonymized dumps of your data with something like https://github.com/evilmartians/evil-seed
-
-
-
Project mention: Announcing fast_count - a new gem to quickly get an accurate count estimation for large tables | reddit.com/r/rails | 2023-04-26
I released a new gem - https://github.com/fatkodima/fast_count.
-
-
Project mention: counter_culture VS activerecord-slotted_counters - a user suggested alternative | libhunt.com/r/counter_culture | 2022-11-29
Introducing Active Record slotted counters gem—not-so-blocking counter caches for your models! This gem adds slotted counters support to Active Record counter cache. Slotted counters help to reduce contention on a single row update in case you have many concurrent operations (like updating a page views counter during traffic spikes). Details: [here](https://planetscale.com/blog/the-slotted-counter-pattern)
-
- Back-end applications (Ruby on Rails): https://github.com/ralixjs/rails-ralix-tailwind - Static site applications (Middleman): https://github.com/ralixjs/middleman-ralix-tailwind - Plain HTML: https://github.com/ralixjs/ralix-tailwind
-
timescaledb
The timescaledb gem. Pack of helpers to work with TimescaleDB extension in Ruby. (by jonatas)
Project mention: Day 23: CI using timescaledb a PostgreSQL based time series database | dev.to | 2022-12-23As always I started by cloning the timescaledb git repository.
-
CodiumAI
TestGPT | Generating meaningful tests for busy devs. Get non-trivial tests (and trivial, too!) suggested right inside your IDE, so you can code smart, create more value, and stay confident when you push.
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).
The latest post mention was on 2023-05-31.
Ruby Postgresql related posts
- SQL Maxis: Why We Ditched RabbitMQ and Replaced It with a Postgres Queue
- Migration Magic ✨, Handling Not-Null Constraints in Production with Ruby on Rails
- rails-pg-extras introduces new API for measuring SQL queries generated by any Ruby snippet
- rails-pg-extras introduces new API for measuring SQL queries generated by any Ruby snippet
- Data sync options when upgrading from v10.21 to v14.6
- Gemfile of dreams: the libraries we use to build Rails apps
- Github Copilot in the Terminal (bash)
-
A note from our sponsor - ONLYOFFICE
www.onlyoffice.com | 31 May 2023
Index
What are some of the best open-source Postgresql projects in Ruby? This list will help you:
| Project | Stars | |
|---|---|---|
| 1 | Discourse | 37,940 |
| 2 | Backup | 4,775 |
| 3 | pgsync | 2,650 |
| 4 | Motor Admin | 1,594 |
| 5 | Logidze | 1,405 |
| 6 | pg_search | 1,076 |
| 7 | Rails PG Extras | 969 |
| 8 | textacular | 892 |
| 9 | Mobility | 888 |
| 10 | with_advisory_lock | 546 |
| 11 | online_migrations | 446 |
| 12 | attr_json | 428 |
| 13 | pg_party | 410 |
| 14 | pg-osc | 332 |
| 15 | ekylibre | 313 |
| 16 | evil-seed | 278 |
| 17 | datoji | 225 |
| 18 | rom-sql | 208 |
| 19 | fast_count | 157 |
| 20 | WebsiteOne | 141 |
| 21 | activerecord-slotted_counters | 74 |
| 22 | rails-ralix-tailwind | 59 |
| 23 | timescaledb | 43 |
ONLYOFFICE Docs — document collaboration in your environment
Powerful document editing and collaboration in your app or environment. Ultimate security, API and 30+ ready connectors, SaaS or on-premises
www.onlyoffice.com