hugsql vs toucan

hugsql

A Clojure library for embracing SQL (by layerware)

Clojure SQL

Source Code

hugsql.org

Suggest alternative

Edit details

toucan

A classy high-level Clojure library for defining application models and retrieving them from a DB (by metabase)

toucan Hydration honeysql Clojure ORM Metabase Flexible SQL

Source Code

Suggest alternative

Edit details

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.

www.influxdata.com

featured

SaaSHub - Software Alternatives and Reviews

SaaSHub helps you find the best software and product alternatives

www.saashub.com

featured

hugsql		toucan
	Project
2	Mentions	4
668	Stars	571
0.1%	Growth	0.2%
0.0	Activity	2.5
28 days ago	Latest Commit	7 months ago
Clojure	Language	Clojure
Apache License 2.0	License	Eclipse Public License 1.0

The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
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.

hugsql

Posts with mentions or reviews of hugsql. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2023-03-15.

Drizzle - An ORM that lets you just write SQL
2 projects | /r/javascript | 15 Mar 2023

I thought it was gonna be...just sql. Like, you know https://github.com/layerware/hugsql. This is just another DSL
Successors to Korma?
3 projects | /r/Clojure | 22 Aug 2021

Different kind of sql lib: https://github.com/layerware/hugsql

toucan

Posts with mentions or reviews of toucan. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2023-06-17.

Ask HN: What are some of the most elegant codebases in your favorite language?
37 projects | news.ycombinator.com | 17 Jun 2023

Metabase's toucan (https://github.com/metabase/toucan) has some elegantly annotated source code: https://rawgit.com/metabase/toucan/master/docs/uberdoc.html
Clojure Turns 15 panel discussion video
24 projects | news.ycombinator.com | 13 Feb 2023

There's this:
https://github.com/metabase/toucan
But beware what you do with it. Avoid DB side effects from business logic.
What is the most commonly used database or de facto database for clojure apps?
1 project | /r/Clojure | 28 Dec 2022

ORMiest option that I know of is Toucan, though I think plain ol' HoneySQL is much more commonly used.
Successors to Korma?
3 projects | /r/Clojure | 22 Aug 2021

For ORM, there's Toucan. Cam is also working on a successor but I'm not sure when it's coming out.

What are some alternatives?

When comparing hugsql and toucan you can also consider the following projects:

honeysql - Turn Clojure data structures into SQL

walkable - A Clojure(script) SQL library for building APIs: Datomic® (GraphQL-ish) pull syntax, data driven configuration, dynamic filtering with relations in mind

relic - Functional relational programming for Clojure(Script).

honeyeql - HoneyEQL is a Clojure library enables you to query database using the EDN Query Language.

gungnir - A fully featured, data-driven database library for Clojure.

coast - The fullest full stack clojure web framework

Light Table - The Light Table IDE ⛺

drizzle-northwind-benchmarks

metabase-clickhouse-driver - ClickHouse database driver for the Metabase business intelligence front-end

Metabase - The simplest, fastest way to get business intelligence and analytics to everyone in your company :yum:

dbdoc - Document your database schema, because your team will thank you, and a single text file makes it easy. Works well with PostgreSQL and others.