Skip to content

A collection of applications migrated from PostgreSQL to YugabyteDB.

Notifications You must be signed in to change notification settings

rthallamko3/pg-migrated-apps

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

62 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

pg-migrated-apps

A collection of applications migrated from PostgreSQL to YugabyteDB.

Prerequisites

  1. Join the YugabyteDB Slack Community, head to the pg-app-century-challenge channel, and raise your hand!
  2. Fork this repository.
  3. Install PostgreSQL or run in Docker.
  4. Install YugabyteDB. NOTE: Be sure to run YugabyteDB with the --enable_pg_parity_tech_preview flag
  5. Install YugabyteDB Voyager.

Migration Steps

Instructions for migrating and running each application are available and linked in the Instructions column of the table below. Unless otherwise stated, follow these steps:

Run on PostgreSQL

  1. Start the application on PostgreSQL.
  2. Load sample data.
  3. Confirm the application is running properly.

Perform Offline Migration

Use the yb-voyager CLI to perform an offline migration.

  1. Generate and view migration assessment report.
  2. Export the schema and data from PostgreSQL.
  3. Perform schema analysis and review report.
  4. Import the schema and data to YugabyteDB.
  5. Verify the migration was successful by running queries to check row counts.
  6. Run the application on YugabyteDB.

After Migration

  1. Fill out application instructions in /apps/APP_NAME.md
  2. Issue a pull request to contribute to this project.
  3. Report your status to the pg-app-century-challenge channel.

List of Applications

Name Description Instructions Status Contributor
1 FireFly III A personal finances manager Run on YugabyteDB Done @ymahajan
2 Documenso The Open Source DocuSign Alternative. Run on YugabyteDB Done @ymahajan
3 Twenty a modern alternative to Salesforce, powered by the community. Run on YugabyteDB Blocked @ymahajan
4 Umami A simple, fast, privacy-focused alternative to Google Analytics. Run on YugabyteDB Done @ymahajan
5 Mattermost Open source platform that provides secure collaboration for technical and operational teams that work in environments with complex nation-state level security and trust requirements. Run on YugabyteDB Done @franckpachot
6 Bytebase The GitHub/GitLab for database DevOps Run on YugabyteDB In progress @vaibhav-yb
7 Keycloak Open Source Identity and Access Management For Modern Applications and Services Run on YugabyteDB Done @tusharraut-yb
8 HedgeDoc Was CodiMD: create real-time collaborative markdown notes Run on YugabyteDB Done @franckpachot
9 NocoDB An Open Source Alternative to Airtable Run on YugabyteDB Done @franckpachot
10 Wiki.js A modern and powerful wiki app built on Node.js Run on YugabyteDB Done @franckpachot
11 Replibyte Replibyte is a blazingly fast tool to seed your databases with your production data while keeping sensitive data safe Run on YugabyteDB Done @franckpachot
12 Commento A fast, bloat-free comments platform Run on YugabyteDB Done @BrettHoyer
13 Spree Online Commerce for Ruby on Rails Run on YugabyteDB Done @BrettHoyer
14 Nocobase A scalability-first, open-source no-code/low-code platform to build internal tools. Run on YugabyteDB Done @BrettHoyer
15 Invidious An alternative front-end to YouTube Run on YugabyteDB Done @BrettHoyer
16 cal.com The open source Calendly alternative, formerly Calendso Run on YugabyteDB In progress
17 Discourse A platform for community discussion. Free, open, simple. Run on YugabyteDB In progress
18 mathesar Web application providing an intuitive user experience to databases. Run on YugabyteDB Blocked
19 bank Full Stack Web Application similar to financial software that is used in banking institutions React.js and Node.js Run on YugabyteDB Done @BrettHoyer
20 NodeBB Node.js based forum software built for the modern web Run on YugabyteDB Done @BrettHoyer
21 Evershop NodeJS E-commerce Platform Run on YugabyteDB Done @BrettHoyer
22 pgTyped Typesafe SQL in TypeScript Run on YugabyteDB In progress
23 Quivr Open-source RAG Framework Run on YugabyteDB In progress
24 Temporal Open source durable execution system. Write code that’s fault tolerant, durable, and simple. Run on YugabyteDB Fail (PG12) @franckpachot
25 Redmine A flexible project management web application written using Ruby on Rails framework. Run on YugabyteDB
26 Plume A a federated blogging engine, based on ActivityPub. Run on YugabyteDB
27 Kine Alternative to Etcd. It already works on YugabyteDB - blog and video. Run on YugabyteDB
28 AWS data.all A modern data marketplace that makes collaboration among diverse users (like business, analysts and engineers) easier, increasing efficiency and agility in data projects on AWS. Run on YugabyteDB
29 Cachet Open-source status page system Run on YugabyteDB
30 Plane Open Source JIRA, Linear and Asana Alternative. Run on YugabyteDB
31 Dogehouse Taking voice conversations to the moon Run on YugabyteDB
32 logto The better identity infrastructure for developers and the open-source alternative to Auth0. Run on YugabyteDB
33 teable The Next Gen Airtable Alternative: No-Code Postgres Run on YugabyteDB
34 bolt a simple CMS written in PHP Run on YugabyteDB
35 waline A Simple, Safe Comment System Run on YugabyteDB
36 baserow an open source no-code database tool and Airtable alternative Run on YugabyteDB
37 webapp.rs A web application completely written in Rust. Run on YugabyteDB
38 metafresh Open Source ERP Run on YugabyteDB
39 WrenAI Open-source Text-to-SQL solution, Wren AI makes your database RAG-ready Run on YugabyteDB
40 mybb a free and open source forum software. Run on YugabyteDB
41 aquameta Web development platform built entirely in PostgreSQL Run on YugabyteDB
42 cocalc Collaborative Calculation in the Cloud Run on YugabyteDB
43 zenedo a CERN service, is an open dependable home for the long-tail of science, enabling researchers to share and preserve any research outputs in any size, any format and from any science. Run on YugabyteDB
44 chatWeb ChatWeb can crawl web pages, read PDF, DOCX, TXT, and extract the main content, then answer your questions based on the content, or summarize the key points. Run on YugabyteDB Blocked
45 Plausible Analytics Simple, open source, lightweight (< 1 KB) and privacy-friendly web analytics alternative to Google Analytics. Run on YugabyteDB
46 LedgerSMB Double-entry accounting & ERP for the web Run on YugabyteDB
47 Jira An agile project management tool used by teams to plan, track, release and support software Run on YugabyteDB
48 Confluence A collaborative platform used for creating, sharing, and organizing content within teams and organizations Run on YugabyteDB Done @denismagda
49 Puppet Run on YugabyteDB
50 GitLab Run on YugabyteDB
51 Stansoft Run on YugabyteDB
52 Orthanc free and open-source, lightweight DICOM server for medical imaging from Belgium. Run on YugabyteDB Fail (advisory locks) @franckpachot
53 Servicebot Open-source subscription management & billing automation system Run on YugabyteDB
54 Miaou A chat server with OAuth2 authentication, persistent and searchable history, video and audio, markdown formatting, private and public rooms, stars, votes, embedded games, and many other features Run on YugabyteDB
55 Tasking Manager The app to team up for mapping in OpenStreetMap Run on YugabyteDB
56 FeedHQ FeedHQ is a web-based feed reader Run on YugabyteDB
57 Open EduCat Comprehensive Open Source ERP for Educational Institutes Run on YugabyteDB
58 SQL Translator SQL Translator is a tool for converting natural language queries into SQL code using artificial intelligence. This project is 100% free and open source. Run on YugabyteDB
59 Papermark Papermark is the open-source DocSend alternative with built-in analytics and custom domains. Run on YugabyteDB
60 Saasfly Your Next SaaS Template or Boilerplate ! A magic trip start with bun create saasfly . The more stars, the more surprises Run on YugabyteDB
61 Worklenz All in one project management tool for efficient teams Run on YugabyteDB
62 Picsur An easy to use, selfhostable image sharing service like Imgur with built in converting Run on YugabyteDB
63 Miniflux/v2 Minimalist and opinionated feed reader Run on YugabyteDB
64 Goxygen Generate a modern Web project with Go and Angular, React, or Vue in seconds Run on YugabyteDB
65 short URL shortening service written in Go and React Run on YugabyteDB
66 maybe The OS for your personal finances Run on YugabyteDB
67 windmill Open-source developer platform to turn scripts into workflows and UIs. Fastest workflow engine (5x vs Airflow). Open-source alternative to Airplane and Retool. Run on YugabyteDB
68 Zitadel Identity infrastructure, simplified for you. Run on YugabyteDB
69 zws Shorten URLs using invisible spaces Run on YugabyteDB
70 DrawDB Free, simple, and intuitive online database design tool and SQL generator. Run on YugabyteDB
71 Hyperswitch An open source payments switch written in Rust to make payments fast, reliable and affordable Run on YugabyteDB
72 coolify An open-source & self-hostable Heroku / Netlify / Vercel alternative. Run on YugabyteDB
73 Dolibarr Dolibarr ERP CRM is a modern software package to manage your company or foundation's activity (contacts, suppliers, invoices, orders, stocks, agenda, accounting, ...). it's an open source Web application (written in PHP) designed for businesses of any sizes, foundations and freelancers. Run on YugabyteDB
74 Chat2DB AI-driven database tool Run on YugabyteDB
75 usql Universal command-line interface for SQL databases Run on YugabyteDB
76 xpipe Your entire server infrastructure at your fingertips Run on YugabyteDB
77 records SQL for Humans™ Run on YugabyteDB
78 Kuwala Kuwala is the no-code data platform for BI analysts and engineers enabling you to build powerful analytics workflows. Run on YugabyteDB
79 storage S3 compatible object storage service that stores metadata in Postgres Run on YugabyteDB
80 postgres-new In-browser Postgres sandbox with AI assistance Run on YugabyteDB
81 worker High performance Node.js/PostgreSQL job queue (also suitable for getting jobs generated by PostgreSQL triggers/functions out into a different work queue) Run on YugabyteDB
82 SQLchat Chat-based SQL Client and Editor for the next decade Run on YugabyteDB
83 Openblocks The Open Source Retool Alternative Run on YugabyteDB
84 nhost The Open Source Firebase Alternative with GraphQL. Run on YugabyteDB
85 PgQueuer PgQueuer is a Python library leveraging PostgreSQL for efficient job queuing. Run on YugabyteDB
86 Payload Payload is the open-source, fullstack Next.js framework, giving you instant backend superpowers. Get a full TypeScript backend and admin panel instantly. Use Payload as a headless CMS or for building powerful applications. Run on YugabyteDB
87 Infisical Infisical is the open-source secret management platform: Sync secrets across your team/infrastructure, prevent secret leaks, and manage internal PKI Run on YugabyteDB
88 Crystal Graphile's Crystal Monorepo; home to Grafast, PostGraphile, pg-introspection, pg-sql2 and much more! Run on YugabyteDB
89 Jitsu Jitsu is an open-source Segment alternative. Fully-scriptable data ingestion engine for modern data teams. Set-up a real-time data pipeline in minutes, not days Run on YugabyteDB
90 DBLab DBLab enables 🖖 database branching and ⚡️ thin cloning for any Postgres database and empowers DB testing in CI/CD. This optimizes database-related costs while improving time-to-market and software quality. Follow to stay updated. Run on YugabyteDB
91 nextjs-openai-doc-serach Template for building your own custom ChatGPT style doc search powered by Next.js, OpenAI, and Supabase. Run on YugabyteDB
92 Retrospected a free AI-powered Real-time Agile Retrospective Board for engineering teams. Run on YugabyteDB
93 nextjs-postgres-email-client An email client built with the Next.js App Router and Postgres as the database. Run on YugabyteDB
94 LimeSurvey The most popular FOSS online survey tool on the web. Run on YugabyteDB
95 pg-boss Queueing jobs in Node.js using PostgreSQL like a boss Run on YugabyteDB
96 sqorn A Javascript library for building SQL queries Run on YugabyteDB
97 Thin Backend Thin Backend is a Blazing Fast, Universal Web App Backend for Making Realtime Single Page Apps Run on YugabyteDB
98 frappe Low code web framework for real world applications, in Python and Javascript Run on YugabyteDB
99 Alerta Alerta monitoring system Run on YugabyteDB
100 Barman Backup and Recovery Manager for PostgreSQL Run on YugabyteDB
101 Mouthful Mouthful is a self-hosted alternative to Disqus Run on YugabyteDB
102 Satellity Yet another open source forum written in Golang, React and PostgreSQL. Run on YugabyteDB
103 Postgres WASM A PostgreSQL server instance running in a virtual machine running in the browser Run on YugabyteDB
104 NewBlur NewsBlur is a personal news reader that brings people together to talk about the world. A new sound of an old instrument. Run on YugabyteDB
105 directus CMS / DB Tool. Directus is a real-time API and App dashboard for managing SQL database content. Run on YugabyteDB
106 dbgate DbGate is cross-platform database manager. It's designed to be simple to use and effective, when working with more databases simultaneously. Run on YugabyteDB
107 Keycloak Open Source Identity and Access Management - Keycloak provides user federation, strong authentication, user management, fine-grained authorization, and more. Run on YugabyteDB
108 Wordpress WordPress is among the most popular content management systems – it was used by 43.1% of the top 10 million websites as of December 2023 main repo is in subversion pg4wp is a module used to make it run in PG https://github.com/PostgreSQL-For-Wordpress Run on YugabyteDB Done @franckpachot
109 marten .NET Transactional Document DB and Event Store on PostgreSQL Run on YugabyteDB
110 Pongo Pongo - Mongo but on Postgres and with strong consistency benefits Run on YugabyteDB

About

A collection of applications migrated from PostgreSQL to YugabyteDB.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages

  • JavaScript 100.0%