Top 23 Oracle Open-Source Projects

• dbeaver

  27 37,575 9.9 Java

  Free universal database tool and SQL client

  

Project mention: DBeaver – open-source Database client | news.ycombinator.com | 2024-03-10

Yes but not in the community version:

https://github.com/dbeaver/dbeaver/wiki/Schema-compare

• TypeORM

  156 33,430 9.0 TypeScript

  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.

  

Project mention: NodeJS Security Best Practices | dev.to | 2024-02-19

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.

• 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.

  

• APIJSON

  0 16,673 8.3 Java

  🏆 零代码、全功能、强安全 ORM 库 🚀 后端接口和文档零代码，前端(客户端) 定制返回 JSON 的数据和结构。 🏆 A JSON Transmission Protocol and an ORM Library 🚀 provides APIs and Docs without writing any code.

  

• Chat2DB

  5 13,644 9.9 Java

  🔥🔥🔥AI-driven data management platform Over 1 million developers are using Chat2DB

  

Project mention: LLMs and SQL | news.ycombinator.com | 2024-04-29

• bytebase

  36 10,107 10.0 Go

  The GitLab/GitHub for database DevOps. World's most advanced database DevOps and CI/CD for Developer, DBA and Platform Engineering teams.

  

Project mention: Ask HN: What tool(s) do you use to code review and deploy SQL scripts? | news.ycombinator.com | 2024-04-14

We have been building https://github.com/bytebase/bytebase for 3+ years. You can think it of as GitHub/GitLab for SQL changes, with integrated GitOps, code review and deployment.

You can further check out this tutorial to get a feel of our GitOps solution

https://www.bytebase.com/docs/tutorials/database-change-mana...

• dbal

  9 9,366 9.3 PHP

  Doctrine Database Abstraction Layer

  

Project mention: PHP + Informix + Framework? | /r/PHP | 2023-05-22

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.

• usql

  21 8,634 9.2 Go

  Universal command-line interface for SQL databases

  

Project mention: xo/usql: Universal command-line interface for SQL databases | /r/devel | 2023-06-08

• SaaSHub

  www.saashub.com featured

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

  

• ali-dbhub

  2 8,439 9.5 Java

  已迁移新仓库，此版本将不再维护

  

Project mention: FLaNK Stack Weekly for 20 June 2023 | dev.to | 2023-06-20

ChatGPT Mac/Windows App for SQL https://github.com/alibaba/Chat2DB

• blog

  1 7,849 9.9 PLpgSQL

  OpenSource,Database,Business,Minds. git clone --depth 1 https://github.com/digoal/blog (by digoal)

• chainlink

  168 6,647 10.0 Go

  node of the decentralized oracle network, bridging on and off-chain computation

  

Project mention: Best Crypto To Invest in 2024 [Expert Guide] | dev.to | 2023-12-29

Chainlink (LINK) – The Blockchain Oracle Giant

• docker-images

  15 6,390 8.0 Shell

  Official source of container configurations, images, and examples for Oracle products and projects

  

Project mention: Is there an image that i can deploy and install java on, and run java app? | /r/docker | 2023-06-18

• jOOQ

  94 5,896 9.8 Java

  jOOQ is the best way to write SQL in Java

  

Project mention: Serious flaws in SQL – Edgar F. Codd (1990) | news.ycombinator.com | 2024-04-25

> 2. ORMs do not hide SQL nastiness.

This is certainly true!

I mean: ORMs are now well known to "make the easy queries slightly more easy, while making intermediate queries really hard and complex queries impossible".

I think the are of ORMs is over. It simply did not deliver.

If a book on SQL is --say-- 100 pages, a book on Hibernate is 400 pages. So much to learn just to make the easy queries slightly easier to type? Just not worth it.

I prefer jooq any day over ORMs. And dont get me started over what tools like Hasuna have to offer.

There are also some languages (forgot the names) that are SQL-done-right. Select in the back, more type safe, more logic, more in the same steps as the query gets executed. These need to be adopted by PG and MySQL and we're good to go. (IMHO)

https://www.jooq.org/

https://hasura.io/

• JSqlParser

  4 4,971 9.4 Java

  JSqlParser parses an SQL statement and translate it into a hierarchy of Java classes. The generated hierarchy can be navigated using the Visitor Pattern

  

• liquibase

  54 4,408 9.9 Java

  Main Liquibase Source

  

Project mention: I am looking for a troubled/bad open source codebase | /r/ExperiencedDevs | 2023-07-12

While I respect the work, Liquibase's code base is quite messy... https://github.com/liquibase/liquibase

• bento

  7 4,194 7.2 HCL

  Packer templates for building minimal Vagrant baseboxes for multiple platforms

  

Project mention: Windows Server Datacenter French Edition | /r/AZURE | 2023-07-04

• FreeSql

  0 3,987 9.4 C#

  🦄 .NET aot orm, C# orm, VB.NET orm, Mysql orm, Postgresql orm, SqlServer orm, Oracle orm, Sqlite orm, Firebird orm, 达梦 orm, 人大金仓 orm, 神通 orm, 翰高 orm, 南大通用 orm, 虚谷 orm, 国产 orm, Clickhouse orm, QuestDB orm, MsAccess orm. (by dotnetcore)

  

• sqlchat

  6 3,765 8.7 TypeScript

  Chat-based SQL Client and Editor for the next decade

  

Project mention: FLaNK Stack Weekly 12 February 2024 | dev.to | 2024-02-12

• xo

  16 3,567 6.2 Go

  Command line tool to generate idiomatic Go code for SQL databases supporting PostgreSQL, MySQL, SQLite, Oracle, and Microsoft SQL Server (by xo)

  

Project mention: Open-sourcing SQX, a way to build flexible database models in Go | news.ycombinator.com | 2023-09-02

i like xo's approach https://github.com/xo/xo but it is as is. I would love if something similar comes along that is used by db practititoners that is actively used and supported.

• PonyORM

  2 3,528 5.8 Python

  Pony Object Relational Mapper

  

• cloudsploit

  6 3,197 9.9 JavaScript

  Cloud Security Posture Management (CSPM)

  

• requery

  1 3,132 0.0 Java

  requery - modern SQL based query & persistence for Java / Kotlin / Android

  

• FluentMigrator

  9 3,140 8.8 C#

  Fluent migrations framework for .NET

  

Project mention: Entity Framework Core Owned Entity | dev.to | 2024-02-15

Fluent Migrator

• LINQ to DB

  20 2,862 8.8 C#

  Linq to database provider.

  

Project mention: Upserting complex data models from an API into EF Core entities | /r/dotnet | 2023-06-02

• SaaSHub

  www.saashub.com featured

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

  

Oracle related posts

• Oracle Java Platform Extension for Visual Studio Code

  1 project | news.ycombinator.com | 23 Oct 2023

• Mixed feelings about Oracle Linux

  1 project | /r/sysadmin | 8 Jul 2023

• PHP + Informix + Framework?

  2 projects | /r/PHP | 22 May 2023

• If you use Oracle - new prebuilt dash/alerts/metrics in free Grafana Cloud tier

  1 project | /r/grafana | 10 May 2023

• OracleDB anyone?

  1 project | /r/Papermerge | 2 Mar 2023

• Simple terraform script failing with 400-CannotParseRequest

  1 project | /r/oraclecloud | 27 Feb 2023

• K8s cluster with OCI free-tier and Raspberry Pi4 (part 1)

  5 projects | dev.to | 15 Feb 2023
• A note from our sponsor - SaaSHub
  www.saashub.com | 10 May 2024

  SaaSHub helps you find the best software and product alternatives Learn more →

Index

Sponsored

SaaSHub - Software Alternatives and Reviews

SaaSHub helps you find the best software and product alternatives

www.saashub.com