The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning. Learn more →
Top 23 MariaDB Open-Source Projects
-
SurveyJS
Open-Source JSON Form Builder to Create Dynamic Forms Right in Your App. With SurveyJS form UI libraries, you can build and style forms in a fully-integrated drag & drop form builder, render them in your JS app, and store form submission data in any backend, inc. PHP, ASP.NET Core, and Node.js.
-
Prisma
Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, MongoDB and CockroachDB
-
TypeORM
ORM for TypeScript and JavaScript. Supports MySQL, PostgreSQL, MariaDB, SQLite, MS SQL Server, Oracle, SAP Hana, WebSQL databases. Works in NodeJS, Browser, Ionic, Cordova and Electron platforms.
-
Sequelize
Feature-rich ORM for modern Node.js and TypeScript, it supports PostgreSQL (with JSON and JSONB support), MySQL, MariaDB, SQLite, MS SQL Server, Snowflake, Oracle DB (v6), DB2 and DB2 for IBM i.
-
go-sql-driver/mysql
Go MySQL Driver is a MySQL driver for Go's (golang) database/sql package (by go-sql-driver)
-
WorkOS
The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.
-
sqlx
🧰 The Rust SQL Toolkit. An async, pure Rust SQL crate featuring compile-time checked queries without a DSL. Supports PostgreSQL, MySQL, and SQLite. (by launchbadge)
-
HeidiSQL
A lightweight client for managing MariaDB, MySQL, SQL Server, PostgreSQL, SQLite, Interbase and Firebird, written in Delphi
-
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.
Project mention: A list of SaaS, PaaS and IaaS offerings that have free tiers of interest to devops and infradev | dev.to | 2024-02-05netdata.cloud — Netdata is an open-source tool to collect real-time metrics. It's a growing product and can also be found on GitHub!
Project mention: Show HN: Teable – Open-Source No-Code Database Fusion of Postgres and Airtable | news.ycombinator.com | 2024-03-11
Project mention: Deploy Full-Stack Next.js T3App with Cognito and Prisma using AWS Lambda | dev.to | 2024-04-15generator client { provider = "prisma-client-js" binaryTargets = ["native", "rhel-openssl-1.0.x"] } datasource db { provider = "postgresql" // NOTE: When using mysql or sqlserver, uncomment the @db.Text annotations in model Account below // Further reading: // https://next-auth.js.org/adapters/prisma#create-the-prisma-schema // https://www.prisma.io/docs/reference/api-reference/prisma-schema-reference#string url = env("DATABASE_URL") } model Post { id Int @id @default(autoincrement()) name String createdAt DateTime @default(now()) updatedAt DateTime @updatedAt createdBy User @relation(fields: [createdById], references: [id]) createdById String @@index([name]) } // ... rest of the schema
If you use Sequalize, TypeORM or for MongoDB, we have Mongoose these types of ORM tools, then you are safe by default because these help us against the SQL query injection attacks by default.
Sequelize - modern Typescript and NodeJS ORM for Oracle, Postgres, MySQL, MariaDB, SQLite, SQL Server+docs
Go does not natively support the use of migrations, but we could use the ORM that has this functionality, such as GORM which is the most used by the community, but We can use migrations without using an ORM, for this we will use the golang-migrate package.
What exactly are you missing? I haven't really written "boring corporate backend stuff" in a few years but something like sqlx provides everything I've ever needed there.
In that case, write your own platform and db driver that translates it, doctrine already has tons of work done which can be easily extended : https://github.com/doctrine/dbal/tree/3.6.x/src/Platforms - or simply use PDO directly as it can do raw queries and forget ORMs in general for such usecase.
Project mention: xo/usql: Universal command-line interface for SQL databases | /r/devel | 2023-06-08
The session logs show that the application loads configurations and establishes a connection with a PostgreSQL database. This involves initializing a HikariCP connection pool and Flyway for database migrations. The logs confirm that the database schema validation and migration checks were successful. The startup of the Jetty HTTP server follows, and the server becomes operational and ready to accept requests on the specified port.
Mastering SQL is like engaging in a deep conversation with databases. Sometimes, you might feel like you're "chatting" with data. But don't worry, tools like phpMyAdmin for managing MySQL databases ensure that your data stays put, bidding farewell to the nightmare of "lost data." This phase requires mastering SQL and relational databases like MySQL, using tools like phpMyAdmin for data management and optimization. Tools to consider: phpMyAdmin, MySQL Workbench, Sequel Pro, and other database management tools.
On Mac OS I use Sequel Ace for MariaDB/MySQL, it's a spiritual successor to Sequel Pro. Native UI. Works great. https://sequel-ace.com/
SQL with SeaORM:
HeidiSQL is used to show database changes, consider supporting it.
Project mention: I am looking for a troubled/bad open source codebase | /r/ExperiencedDevs | 2023-07-12While I respect the work, Liquibase's code base is quite messy... https://github.com/liquibase/liquibase
Upvote, because I like the idea of https://github.com/cytopia/devilbox. But, it contains a bit too much for me. Worth a look, though, fellow redditors
Project mention: WAL-G 3.0.0 – fast disaster recovery for Postgres | news.ycombinator.com | 2024-03-17
Project mention: Upserting complex data models from an API into EF Core entities | /r/dotnet | 2023-06-02
MariaDB related posts
- Mariadb-operator: Run and operate MariaDB in a cloud native way on Kubernetes
- Mariadb - CCX33 vs AX41-NVMe performance difference
- Best Xampp alternative
- Restore or Migrate your MySQL Database to Railway
- Install Laravel Valet+ Ubuntu
- MariaDB, MySQL, and Node.js: Why Using the Right Connector Matters
- Joomla! 4.3 on OpenBSD 7.3: Install
-
A note from our sponsor - WorkOS
workos.com | 26 Apr 2024
Index
What are some of the best open-source MariaDB projects? This list will help you:
Project | Stars | |
---|---|---|
1 | Netdata | 68,153 |
2 | nocodb | 42,374 |
3 | Prisma | 37,151 |
4 | TypeORM | 33,287 |
5 | Sequelize | 29,045 |
6 | go-sql-driver/mysql | 14,178 |
7 | migrate | 13,946 |
8 | sqlx | 11,742 |
9 | dbal | 9,360 |
10 | usql | 8,605 |
11 | Flyway | 7,763 |
12 | phpMyAdmin | 7,023 |
13 | frappe | 6,484 |
14 | Sequel-Ace | 6,427 |
15 | sea-orm | 6,246 |
16 | drawdb | 6,154 |
17 | HeidiSQL | 4,437 |
18 | liquibase | 4,394 |
19 | devilbox | 4,324 |
20 | tbls | 3,068 |
21 | wal-g | 3,038 |
22 | LINQ to DB | 2,859 |
23 | datastation | 2,854 |
Sponsored