Top 16 Tsql Open-Source Projects

• sqlglot

  56 5,573 9.9 Python

  Python SQL Parser and Transpiler

Project mention: The Future of MySQL is PostgreSQL: an extension for the MySQL wire protocol | news.ycombinator.com | 2024-04-26

This is probably referring to "zero changes to your driver code" and not "zero changes to the SQL you send over this driver".

Translating between SQL dialects is notoriously hard and attempts to translate [1] are working in 95% of cases. But the last 5% would require 5x amount of work. That's because "SQL dialect" also includes weird edge cases of type inference of things like COALESCE(5, FALSE) and emulation of system catalogs (pg_catalog, information_schema).

[1] https://github.com/tobymao/sqlglot

• CommunityServer

  4 2,582 3.1 C#

  Free open source office suite with business productivity tools: document and project management, CRM, mail aggregator.

  

Project mention: OnlyOffice: Free open source office suite with business productivity tools | /r/hackernews | 2023-10-05

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

  

• sqlserver-kit

  2 1,980 5.8 TSQL

  Useful links, scripts, tools and best practice for Microsoft SQL Server Database

• naming-convention

  1 1,796 4.2

  Templates for naming convention - TSQL, JavaScript, C#, R, Python, Powershell

• Rezoom.SQL

  7 665 0.0 F#

  Statically typechecks a common SQL dialect and translates it to various RDBMS backends

  

Project mention: Gente con experiencia: con qué nueva tecnología, lenguaje de programación o framework debería actualizarme hoy? | /r/devsarg | 2023-07-05

• jupysql

  8 610 9.1 Python

  Better SQL in Jupyter. 📊

  

Project mention: Show HN: JupySQL – a SQL client for Jupyter (ipython-SQL successor) | news.ycombinator.com | 2023-12-06

Hey, HN community!

We're stoked to launch JupySQL today! JupySQL is an open-source library that brings a modern SQL experience to Jupyter. JupySQL is compatible with all major databases, such as Snowflake, Redshift, PostgreSQL, MySQL, MariaDB, DuckDB, SQL Server, Clickhouse, Trino, and more!

To get started, check out our tutorial: https://jupysql.ploomber.io/en/latest/quick-start.html

SQL is the defacto language for data analysis; however, analysis often requires a mix of SQL and Python. JupySQL bridges this gap, allowing users to execute SQL queries seamlessly in Jupyter and continue their analysis in Python. Add %%sql to the top of your cell and start writing SQL.

Here are some of JupySQL's main features:

- Syntax highlighting

• Sql-Server-DBA-Toolbox

  1 91 6.4 TSQL

  A box of tricks (SQL scripts) that I've built up over many years for Microsoft SQL Server instance and database administration, and general working-with-data.

• SaaSHub

  www.saashub.com featured

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

  

• SCOM-Scripts-and-SQL

  4 71 9.1 PowerShell

  The Scripts provided here are compatible with System Center Operations Manager

Project mention: How do I automate schedule discovery in the Network Discovery rule using Powershell cmdlets? | /r/scom | 2023-07-23

I've been going through Blake Drumm's Start-SCOMDiscovery script to get myself started, as well as Microsoft's OM cmdlet reference. From what I gleaned, I need to use Get-SCOMDiscovery to get a ManagementPackDiscovery[] array which contains the rule. I think I need to interact with the provided Management Pack (Network Discovery Internal?) but I can't find the docs that match with the actions described, so I'm not sure where to go from here.

• dbt-synapse

  2 64 9.0 Python

  dbt adapter for Azure Synapse Dedicated SQL Pools

  

• sql-basics

  6 23 9.2 C#

  Basics and intermediate topics for working with SQL-Server using C#

Project mention: Working with Dapper/SQL-Server Framework 4.8 C# | dev.to | 2024-01-27

In both samples to get all records and to get a single record works fine but there is a better way to perform the same work using NuGet package Dapper. Dapper is extremely easy to use and built with performance in mind. In the source code provided the basic operations are covered, to take things to the next level and read the information at GitHub, the following page and other code samples in the following repository.

• jds

  0 22 0.0 Kotlin

  Jenesis Data Store: a dynamic, cross platform, high performance, ORM data-mapper. Designed to assist in rapid development and data mining

• fql

  6 21 3.1 C++

  Formatted text processing with SQL

• cheatsheets

  3 9 9.0 C#

  code snippets instead of bookmarking and search stack overflow (by eddyizm)

• sqle

  0 9 8.5 Go

  A SQL-first/ORM-like Golang SQL package.

  

• Advent_of_Code

  11 6 2.6 TSQL

  A repo revolving around attempting to solve the Advent of Code puzzles with single-statement t-sql (by adimcohen)

• utility

  1 1 4.1 TSQL

  Making the world a better place, one utility tool at a time (by dadepretto)

• SaaSHub

  www.saashub.com featured

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

  

Tsql related posts

• Using Dapper - C# Part 1-A

  1 project | dev.to | 4 Nov 2023

• SQL Server Trace Flags

  1 project | /r/Database | 25 Sep 2021

• Repository of C# Naming Conventions (ktaranov github)

  1 project | /r/csharp | 3 Jan 2021

Index

Sponsored

SaaSHub - Software Alternatives and Reviews

SaaSHub helps you find the best software and product alternatives

www.saashub.com