PBpbreit·May 7, 2019
Would something like Python "records" ever get traction? Just write SQL.
https://github.com/kennethreitz/records
In To ORM or Not to ORMkennethreitz
records
Python2016–2019
kennethreitz / records
records
SQL for Humans™
7Distinct people
9Mentions
0Explicit recommenders
7.2KGitHub stars
What to know before exploring
What it is
SQL for Humans™
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
No other repository is repeatedly linked in the same discussions.
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: 2016-02-07 16:53:58 UTC to 2019-05-07 18:32:20 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
| Period | Start (UTC) | End (exclusive, UTC) | Mentions | Submissions | Comments |
|---|---|---|---|---|---|
| 2016 | 2016-01-01 00:00:00 UTC | 2017-01-01 00:00:00 UTC | 6 | 1 | 5 |
| 2017 | 2017-01-01 00:00:00 UTC | 2018-01-01 00:00:00 UTC | 2 | 0 | 2 |
| 2018 | 2018-01-01 00:00:00 UTC | 2019-01-01 00:00:00 UTC | 0 | 0 | 0 |
| 2019 | 2019-01-01 00:00:00 UTC | 2020-01-01 00:00:00 UTC | 1 | 0 | 1 |
What Hacker News says
9 sourcesKenneth Reitz's records library is similar (and also reliant on Sqlalchemy): https://github.com/kennethreitz/records
In Getting the Most Out of Sqlite3 with PythonYep. I'm wondering if a framework would ever adopt something like Records [1].
1: https://github.com/kennethreitz/records (same author as Requests)
In Django 1.11 beta 1 releasedAlso Records for Python: https://github.com/kennethreitz/records
In What ORMs have taught me: just learn SQL (2014)> There are a lot of ways to do that, and many of them involve the current team members being proactive about going out and trying to recruit someone to fill that role.
Orrrr the current team members can be proactive and do something that will reduce the number of bad bug reports they get.
Without Github Issues you might miss out on useful input such as https://github.com/kennethreitz/records/issues/10 though.
In Investigate switching away from GitHubHe's using cursors directly from the his database library[1] which is psycopg2[2] (and we can also see that the cursor_factory is how the dicts are generated). The psycopg2 docs say[3]:
When a database query is executed, the Psycopg cursor usually
fetches all the records returned by the backend, transferring
them to the client process. If the query returned an huge amount
of data, a proportionally large amount of memory will be
allocated by the client.
[1] https://github.com/kennethreitz/records/blob/master/records....
[2] https://github.com/kennethreitz/records/blob/master/records....
[3] http://initd.org/psycopg/docs/usage.html#server-side-cursors
In Records: Python library for making raw SQL queries to Postgres databasesI've made a pull request implementing namedtuple support at https://github.com/kennethreitz/records/pull/6.
In Records: Python library for making raw SQL queries to Postgres databasesRecords: Python library for making raw SQL queries to Postgres databases
257 points · Open discussion