jeffknupp

sandman2

Python2015–2022

jeffknupp / sandman2

sandman2

Automatically generate a RESTful API service for your legacy database. No code required!

Data & Databases Web Development

Explore on GitHub Read Hacker News discussions

8Distinct people

9Mentions

0Explicit recommenders

2KGitHub stars

REPOSITORY AT A GLANCE

What to know before exploring

What it is

Automatically generate a RESTful API service for your legacy database. No code required!

GitHub

Where it is used

No documented product use has been verified yet.

What people are saying

No recommendation phrase was found in the indexed comments.

No classified warning is attached to this page. Read the discussions before treating silence as approval.

Also in these discussions

simonw/datasette · linked in 3 of the same discussions

Mentioned in the same Hacker News threads. That is not proof they are substitutes.

This week on Hacker News

Nov 7–Nov 14 UTC · Direct repository links and separately labeled related project stories. Indexed through 11/14/2026, 3:56:07 PM UTC.

No direct repository links were found in the indexed HN discussions over the past seven days. Older discussions are available below.

Mentions over time

HN mentions by year9 dated mentions

Observed mentions: 2015-01-04 01:42:21 UTC to 2022-10-07 11:57:16 UTC.

Counts come from the repository’s dated source evidence. Index cutoff: 2026-11-02 08:16:59 UTC.

View mention counts and date ranges

UTC ranges include their start and exclude their end. Select a period to filter the source evidence.
Period	Start (UTC)	End (exclusive, UTC)	Mentions	Comments
2015	2015-01-01 00:00:00 UTC	2016-01-01 00:00:00 UTC	1	1
2016	2016-01-01 00:00:00 UTC	2017-01-01 00:00:00 UTC	0	0
2017	2017-01-01 00:00:00 UTC	2018-01-01 00:00:00 UTC	3	3
2018	2018-01-01 00:00:00 UTC	2019-01-01 00:00:00 UTC	0	0
2019	2019-01-01 00:00:00 UTC	2020-01-01 00:00:00 UTC	3	3
2020	2020-01-01 00:00:00 UTC	2021-01-01 00:00:00 UTC	0	0
2021	2021-01-01 00:00:00 UTC	2022-01-01 00:00:00 UTC	1	1
2022	2022-01-01 00:00:00 UTC	2023-01-01 00:00:00 UTC	1	1

What Hacker News says

9 sources

hantusk·Oct 7, 2022

https://github.com/jeffknupp/sandman2 works with many different backends including sqlite, but postgrest definitely have the auth flow and security model right for these things.

In Nocodb: Turns Any MySQL, Postgres, SQLite into a Spreadsheet with REST APIs

gowthamgts12·Nov 30, 2021

I'm using sandman2[0] as a wrapper for psql and mysql databases. how is it different or any feature/differentiating factor I should consider for my future wrappers? [0] - https://github.com/jeffknupp/sandman2

In PostgREST 9.0

westurner·Aug 21, 2019

There are lots of apps that do database introspection. Some also generate forms on the fly, but eventually it's necessary to: specify a forms widget for a particular field because SQL schema only describes the data and not the UI; and specify security authorization restrictions on who can create, read, update, or delete data. And then you want to write arbitrary queries to filter on columns that aren't indexed; but it's really dangerous to allow clients to run arbitrary SQL queries because there basically are no row/object-level database permissions (the application must enforce row-level permissions). Datasette is a great tool for read-only database introspection and queries of SQLite databases. https://github.com/simonw/datasette Sandman2 generates a REST API for an arbitrary database. https://github.com/jeffknupp/sandman2 You can gener

Read the rest

ate Django models and then write admin.py files for each model/table that you want to expose in the django.contrib.admin interface. There are a number of apps for providing a GraphQL API given introspection of a database that occurs at every startup or at runtime; but that doesn't solve for row-level permissions (or web forms) If you have an OpenAPI spec for the REST API that runs atop The database, you can generate forms ("scaffolding") from the OpenAPI spec and then customize those with form widgets; optionally with something like json-schema. It's not safe to allow introspected CRUD like e.g. phpMyAdmin for anything but development. If there are no e.g. foreign-key constraints specified in the SQL schema,a blindly-introspected UI very easily results in database corruption due to invalid foreign key references (because the SQL schema doesn't specify what table.column a foreign key references). Django models, for example, unify SQL schema and forms UI in models.py; admin.py is optional but really useful for scaffolding (such as when you're doing manual testing because you haven't yet written automated tests) https://docs.djangoproject.com/en/2.2/ref/contrib/admin/#mod...

In Ask HN: Is there a CRUD front end for databases (especially SQLite)?

hprotagonist·Jul 10, 2019

Jeff Knupp's sandman2 (https://github.com/jeffknupp/sandman2) has long been my go-to project for when i need to do this. I don't have to very often, but it is _very_ handy when I do! Semi-related (kind of the inverse) tool is simon w's datasette (https://github.com/simonw/datasette) which gives you a readonly view into a sqlite database, conveniently exposed as a website. I've fired that up in meetings before to general shock and acclaim...

In Sqlite to Rest

BerislavLopac·Apr 28, 2019

I've also been a happy user of Sandman: https://github.com/jeffknupp/sandman2

In PostgreSQL Features to Try

simonw·Nov 14, 2017

The "REST API for your database" thing isn't actually the part of this I'm most excited about - there are quite a few entries in that category already, such as https://github.com/jeffknupp/sandman2 The thing that excites me is being able to take almost any dataset, package it up into a simple, well-understood format and then deploy that in a read-only, highly scalable way, taking advantage of modern containerization systems. Read-only SQLite is /perfect/ for this use-case. It's fast, widely supported, has a great feature-set and can be distributed as a single file. My favourite feature of Datasette isn't the web UI, it's the publish command: datasette publish now ~/path-to-my/sqlite.db Combined with my https://github.com/simonw/csvs-to-sqlite tool it means you can take a CSV file and turn it into a live-on-the-internet REST SQL API i

Read the rest

n literally minutes. Here are a bunch of datasets that I've done that to just today: https://github.com/simonw/datasette/wiki/Datasettes

In Show HN: Datasette – Create and publish an API for SQLite databases

drunkcatsdgaf·Jun 24, 2017

check out sandman, https://github.com/jeffknupp/sandman2

In pREST – A fully RESTful API from any existing PostgreSQL database writting in Go

BerislavLopac·Feb 14, 2017

Nice, Postgrest looks really amazing, especially for long-term production needs. I've previously used Sandman, which is much easier to set up, which makes it ideal for more quick-and-dirty needs: https://github.com/jeffknupp/sandman2

In Is PostgreSQL good enough?

detaro·Jan 4, 2015

That probably is because he rewrote it: https://github.com/jeffknupp/sandman2

In Automatic REST API for Any Postgres Database