sq
Dapper
sq | Dapper | |
---|---|---|
10 | 42 | |
227 | 17,193 | |
- | 0.8% | |
5.9 | 8.3 | |
9 days ago | 21 days ago | |
Go | C# | |
MIT License | GNU General Public License v3.0 or later |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
sq
-
How to use prepared queries wisely - postgres & pgx & squirell
You can use my library sq which handles this exact use case with the PreparedQuery type. It allows you to build a query programmatically, prepare it and optionally rebind parameters by name.
-
How to Work with SQL Databases in Go
Have you seen my library https://github.com/bokwoon95/sq? You can use it like database/sql and write plain SQL strings, only needing to provide a function that maps an database row to a struct and generics returns a slice of those structs at the end.
-
DRY pgx / database/sql?
Also consider my library sq which handles dynamic query generation as well as data mapping. You may find it simpler than bun because it's a lot closer to database/sql (it doesn't require a special DB object, it uses a plain *sql.DB).
-
Ent: An Entity Framework for Go
> I didn't see anything to help me build back graphs
Hmm you've certainly given me something to think about. Thanks.
BTW joins are not challenging, but you made me realize I didn't show any joins in my basic examples. Here is UPDATE with JOIN example: https://bokwoon.neocities.org/sq.html#postgres-update-with-j....
-
scan rows into types powered by generics
How does it compare to https://github.com/bokwoon95/sq?
- Show HN: An SQL data mapper using Go generics
- A type-safe struct mapper and query builder for Go (using generics)
- A struct mapper, query builder and migration tool for Go.
Dapper
-
Get SQL-Server Stored Procedures with C#
Using Dapper to get database names from the SQL-Server instance set in appsettings.json
-
Working with Dapper/SQL-Server Framework 4.8 C#
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.
-
Working with Dapper in C#
In this article learn how to use Dapper an open-source object-relational mapping (ORM) library for .NET and .NET Core applications. Unlike many articles out there, this one will provide source code to try everything out that is shown in an easy-to-follow way by beginning with a single table then in part two of this series will work with multiple tables.
- Interceptors (new C# metaprogramming feature) to fuel DapperAOT development
- API REST C# Entity Framework y SQL
-
Integration Testing Postgres Store
Dapper
-
REST API using C# .NET 7 with MySql
I will be using Dapper - a simple object mapper for .Net along with MySqlConnector.
-
Resources for learning minimal API using dapper in .net
Maybe the more basic approach to dapper is their documentation https://github.com/DapperLib/Dapper the readme but again most likely you not gonna understand
-
SQL Connection Question
I think EF Core & EF are the successors to LINQ to SQL that you'd wanna look into, and/or Dapper if you wanna go lower.
-
Dapper is die?
The main maintainers of Dapper no longer work at Stack, but they're active enough to comment on recent pull requests: https://github.com/DapperLib/Dapper/pull/1887.
What are some alternatives?
vlcn-orm - Develop with your data model anywhere. Query and load data reactively. Replicate between peers without a central server.
efcore-dapper-benchmark - A project that I have created to benchmark the read/write performance of EFCore vs Dapper
scan - scan sql rows into any type powered by generics
Npgsql - Npgsql is the .NET data provider for PostgreSQL.
korm - KORM, an elegant and lightning-fast ORM for all your concurrent and async needs. Inspired by the highly popular Django Framework, KORM offers similar functionality with the added bonus of performance
PetaPoco - Official PetaPoco, A tiny ORM-ish thing for your POCO's
typed-graphql-builder - A fully type-safe graphql query builder, inspired by tql
Knex - A query builder for PostgreSQL, MySQL, CockroachDB, SQL Server, SQLite3 and Oracle, designed to be flexible, portable, and fun to use.
node-sql - SQL generation for node.js
Hasura - Blazing fast, instant realtime GraphQL APIs on your DB with fine grained access control, also trigger webhooks on database events.
sqddl - sqddl is a zero-configuration database migration tool.
pg-ulid - ULID Functions for PostgreSQL