Sqlserver

Open-source projects categorized as Sqlserver
Edit details
Language: + Java + TypeScript + Go + C# + PHP + TSQL
Topics: MySQL SQL Postgresql Database Sqlite
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.
workos.com
Sponsored

Top 23 Sqlserver Open-Source Projects

  • nocodb

    🔥 🔥 🔥 Open Source Airtable Alternative

    • Project mention: Show HN: Teable – Open-Source No-Code Database Fusion of Postgres and Airtable | news.ycombinator.com | 2024-03-11

  • dbeaver

    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

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

    InfluxDB logo

  • Prisma

    Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, MongoDB and CockroachDB

    • Project mention: Deploy Full-Stack Next.js T3App with Cognito and Prisma using AWS Lambda | dev.to | 2024-04-15

    generator 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

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

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

  • APIJSON

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

  • Chat2DB

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

    • Project mention: Show HN: AI-driven data development and analysis platform | news.ycombinator.com | 2024-04-08

  • bytebase

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

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

    WorkOS logo

  • nopCommerce

    ASP.NET Core eCommerce software. nopCommerce is a free and open-source shopping cart.

    • Project mention: Dotnet.World.News(Monday, September, 11, 2023) | /r/bitplatform | 2023-09-14

    🔴 nopCommerce: ASP.NET Core eCommerce software. nopCommerce is a free and open-source shopping cart.

  • Flyway

    Flyway by Redgate • Database Migrations Made Easy.

    • Project mention: Let's write a simple microservice in Clojure | dev.to | 2024-04-26

    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.

  • jOOQ

    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

    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

    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

  • FreeSql

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

    Chat-based SQL Client and Editor for the next decade

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

  • PHP-CRUD-API

    Single file PHP script that adds a REST API to a SQL database

    • Project mention: Need something to host a URL that listens for a POST and then talks back to on-prem SQL. | /r/sysadmin | 2023-05-10

    For quick dev/arch projects at home, I usually use this: https://github.com/mevdschee/php-crud-api

  • EFCore.BulkExtensions

    Entity Framework EF Core efcore Bulk Batch Extensions with BulkCopy in .Net for Insert Update Delete Read (CRUD), Truncate and SaveChanges operations on SQL Server, PostgreSQL, MySQL, SQLite

    • Project mention: Best way to do mass inserts with Entity Framework | /r/dotnet | 2023-06-08

    EF Core Bulk Extensions has helped me out many a day.

  • tbls

    tbls is a CI-Friendly tool for document a database, written in Go.

    • Project mention: FLaNK 25 December 2023 | dev.to | 2023-12-26

  • wal-g

    Archival and Restoration for databases in the Cloud

    • Project mention: WAL-G 3.0.0 – fast disaster recovery for Postgres | news.ycombinator.com | 2024-03-17

  • LINQ to DB

    Linq to database provider.

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

  • sql-server-maintenance-solution

    SQL Server Maintenance Solution

    • Project mention: Rookie dba questions on maintenance | /r/SQLServer | 2023-12-07

  • Jailer

    Database Subsetting and Relational Data Browsing Tool.

    • Project mention: Show HN: Jailer is a unique open-source database client tool | news.ycombinator.com | 2024-03-14

  • prisma-client-go

    Prisma Client Go is an auto-generated and fully type-safe database client

    • Project mention: Prisma Client Go: Typesafe Database Client for Golang | news.ycombinator.com | 2024-01-20

  • GeoTools

    Official GeoTools repository

  • SaaSHub

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

    SaaSHub logo
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).

Sqlserver related posts

Index

What are some of the best open-source Sqlserver projects? This list will help you:

Project Stars
1 nocodb 42,374
2 dbeaver 37,391
3 Prisma 37,151
4 TypeORM 33,287
5 APIJSON 16,643
6 Chat2DB 12,566
7 bytebase 9,977
8 nopCommerce 8,909
9 Flyway 7,763
10 jOOQ 5,882
11 JSqlParser 4,956
12 liquibase 4,394
13 FreeSql 3,973
14 sqlchat 3,722
15 PHP-CRUD-API 3,526
16 EFCore.BulkExtensions 3,472
17 tbls 3,068
18 wal-g 3,038
19 LINQ to DB 2,859
20 sql-server-maintenance-solution 2,756
21 Jailer 2,705
22 prisma-client-go 1,937
23 GeoTools 1,634

Sponsored
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com