| id |
text |
url |
tags |
updated_at |
| 5188 |
jolt-org/advanced-alchemy: A carefully crafted, thoroughly tested, optimized companion library for SQLAlchemy |
https://github.com/jolt-org/advanced-alchemy |
python
databases
|
4 days ago |
| 5187 |
Виды JOIN в SQL |
https://antonz.ru/sql-join/ |
databases
|
4 days ago |
| 5123 |
Relational is more than SQL | Hacker News |
https://news.ycombinator.com/item?id=37532245 |
databases
|
16 days ago |
| 5004 |
piccolo-orm/piccolo: A fast, user friendly ORM and query builder which supports asyncio. |
https://github.com/piccolo-orm/piccolo/ |
python
databases
|
2023 Sep 01 18:36 |
| 4986 |
File Attachments: Databases can now store files and images | Hacker News |
https://news.ycombinator.com/item?id=37324370 |
databases
|
2023 Aug 30 18:14 |
| 4898 |
redis move data to different server - Google Search |
https://www.google.com/search?hl=en&q=redis%20move%20data%20to%20different%20server |
databases
|
2023 Aug 15 07:44 |
| 4891 |
Python: Just Write SQL | Hacker News |
https://news.ycombinator.com/item?id=37118633 |
python
databases
|
2023 Aug 14 11:46 |
| 4889 |
TUTORIAL: SQLAlchemy 2.0 - YouTube |
https://www.youtube.com/watch?v=Uym2DHnUEno&list=WL&index=37&t=2006s |
python
databases
|
2023 Aug 14 07:45 |
| 4830 |
Do we really need a specialized vector database? | Hacker News |
https://news.ycombinator.com/item?id=37097004 |
ai
databases
|
2023 Aug 12 10:05 |
| 4699 |
PRQL: Pipelined Relational Query Language | Hacker News |
https://news.ycombinator.com/item?id=36866861 |
databases
|
2023 Jul 26 13:12 |
| 4192 |
CTEs as lookup tables | Hacker News |
https://news.ycombinator.com/item?id=34346411 |
databases
|
2023 Mar 25 10:04 |
| 4088 |
Удивительное и невероятное о первичных ключах PostgreSQL: serial, bigserial, UUID v4, ULID, UUID v6 - YouTube |
https://www.youtube.com/watch?v=VC9KbAA_5rE |
python
databases
|
2023 Feb 27 12:15 |
| 4080 |
sqlalchemy default vs server_default - Google Search |
https://www.google.com/search?hl=en&q=sqlalchemy%20default%20vs%20server_default |
python
databases
|
2023 Feb 26 21:09 |
| 4076 |
# python orms
- [SQLAlchemy Documentation — SQLAlchemy 2.0 Documentation](https://docs.sqlalchemy.org)
- [SQLModel](https://sqlmodel.tiangolo.com/)
- [Tortoise ORM - Tortoise ORM v0.19.3 Documentation](https://tortoise.github.io/)
- [python-gino/gino: GINO Is Not ORM - a Python asyncio ORM on SQLAlchemy core.](https://github.com/python-gino/gino) |
|
python
databases
|
2023 Feb 26 18:34 |
| 4075 |
MoscowPython Meetup 80. Зачем нужен и как использовать Dependency Injection в питонячих сервисах - YouTube |
https://www.youtube.com/watch?v=wtP4kdGj_vA |
python
databases
|
2023 Feb 26 18:29 |
| 4074 |
MoscowPython Meetup 80. Как мы с Fastapi на Django перешли - YouTube |
https://www.youtube.com/watch?v=xQVLMio4RDE |
python
databases
|
2023 Feb 26 18:19 |
| 4033 |
dropbox/sqlalchemy-stubs: Mypy plugin and stubs for SQLAlchemy |
https://github.com/dropbox/sqlalchemy-stubs |
python
databases
|
2023 Feb 22 20:57 |
| 4031 |
What's New in SQLAlchemy 2.0? - miguelgrinberg.com |
https://blog.miguelgrinberg.com/post/what-s-new-in-sqlalchemy-2-0 |
python
databases
|
2023 Feb 22 19:55 |
| 3995 |
DuckDB 0.7.0 | Hacker News |
https://news.ycombinator.com/item?id=34771524 |
databases
|
2023 Feb 13 10:55 |
| 3973 |
Vector similarity | Redis |
https://redis.io/docs/stack/search/reference/vectors/ |
ml
databases
|
2023 Feb 07 08:47 |
| 3953 |
redis-py dev documentation |
https://redis.readthedocs.io/en/stable/index.html |
python
databases
|
2023 Feb 05 08:13 |
| 3951 |
Asyncio Examples - redis-py dev documentation |
https://redis.readthedocs.io/en/stable/examples/asyncio_examples.html |
python
databases
|
2023 Feb 04 20:29 |
| 3946 |
brainix/pottery: Redis for humans. 🌎🌍🌏 |
https://github.com/brainix/pottery |
python
databases
|
2023 Feb 04 11:34 |
| 3945 |
6.5.1 Single-recipient publish/subscribe replacement | Redis |
https://redis.com/ebook/part-2-core-concepts/chapter-6-application-components-in-redis/6-5-pull-messaging/6-5-1-single-recipient-publishsubscribe-replacement/ |
databases
|
2023 Feb 04 10:57 |
| 3944 |
Event Queue | Redis |
https://redis.com/redis-best-practices/communication-patterns/event-queue/ |
databases
|
2023 Feb 04 10:17 |
| 3943 |
PSUBSCRIBE | Redis - subscribe to patterns
- [Distributed Events | Redis](https://redis.com/redis-best-practices/communication-patterns/distributed-events/) |
https://redis.io/commands/psubscribe/ |
databases
|
2023 Feb 04 09:37 |
| 3934 |
чел говорит что хранение `HSET` намного меньше занимает по памяти чем плоские структуры |
https://youtu.be/JBIm4sglyQU?t=690 |
coding
databases
|
2023 Feb 03 15:43 |
| 3914 |
How to convert SQLAlchemy row object to a Python dict? - Stack Overflow |
https://stackoverflow.com/questions/1958219/how-to-convert-sqlalchemy-row-object-to-a-python-dict |
python
databases
|
2023 Feb 02 21:17 |
| 3913 |
Install Redis on macOS | Redis |
https://redis.io/docs/getting-started/installation/install-redis-on-mac-os/ |
macos
databases
|
2023 Feb 02 19:48 |
| 3902 |
GraphQL | Search powered by Algolia |
https://hn.algolia.com/?dateRange=all&page=0&prefix=true&query=GraphQL&sort=byPopularity&type=story |
databases
|
2023 Jan 31 18:49 |
| 3901 |
Advanced SQLAlchemy Features You Need To Start Using | Martin Heinz | Personal Website & Blog |
https://martinheinz.dev/blog/28 |
python
databases
|
2023 Jan 31 15:51 |
| 3899 |
PostgREST | Hacker News |
https://news.ycombinator.com/item?id=21435195 |
databases
|
2023 Jan 31 15:25 |
| 3895 |
SQL should be the default choice for data engineering pipelines | Hacker News |
https://news.ycombinator.com/item?id=34578324 |
spark
databases
|
2023 Jan 30 16:35 |
| 3879 |
SQLAlchemy 1.4 | Hacker News |
https://news.ycombinator.com/item?id=26487959 |
python
databases
|
2023 Jan 24 07:38 |
| 3878 |
sqlalchemy cascade delete - Google Search |
https://www.google.com/search?hl=en&q=sqlalchemy%20cascade%20delete |
python
databases
|
2023 Jan 24 07:19 |
| 3877 |
Pro-Tip: Django ORM vs SQLAlchemy in 2021 | EBS Integrator |
https://ebs-integrator.com/blog/django-orm-vs-sql-alchemy/ |
python
databases
|
2023 Jan 24 07:19 |
| 3841 |
RaRe-Technologies/sqlitedict: Persistent dict, backed by sqlite3 and pickle, multithread-safe. |
https://github.com/RaRe-Technologies/sqlitedict |
python
databases
|
2023 Jan 15 07:33 |
| 3840 |
diskcache · PyPI |
https://pypi.org/project/diskcache/ |
python
databases
|
2023 Jan 15 07:33 |
| 3839 |
TIL–Python has a built-in persistent key-value store (2018) | Hacker News |
https://news.ycombinator.com/item?id=32849592 |
python
databases
|
2023 Jan 15 07:33 |
| 3500 |
udns/redis.py at main · bobuk/udns |
https://github.com/bobuk/udns/blob/main/redis.py |
python
databases
|
2022 Dec 04 07:08 |
| 3421 |
Who needs MLflow when you have SQLite? | Hacker News |
https://news.ycombinator.com/item?id=33624018 |
ml
databases
|
2022 Nov 16 17:53 |
| 3121 |
Ошибки выбора MongoDB в качестве основной БД в стартапе / Хабр |
https://habr.com/ru/post/692736/ |
databases
|
2022 Oct 12 10:44 |
| 3060 |
mongodump — MongoDB Database Tools |
https://www.mongodb.com/docs/database-tools/mongodump/#connect-to-a-mongodb-instance |
databases
|
2022 Oct 04 06:49 |
| 3027 |
sqlite replication - Google Search |
https://www.google.com/search?hl=en&q=sqlite%20replication |
databases
|
2022 Oct 01 05:42 |
| 2779 |
MongoDB Crash Course 2022 - YouTube |
https://www.youtube.com/watch?v=2QQGWYe7IDU |
databases
|
2022 Aug 14 09:21 |
| 2752 |
architecture - When to Redis? When to MongoDB? - Stack Overflow |
https://stackoverflow.com/questions/5400163/when-to-redis-when-to-mongodb |
databases
|
2022 Aug 12 06:38 |
| 2751 |
Redis explained | Hacker News |
https://news.ycombinator.com/item?id=32426879 |
databases
|
2022 Aug 12 06:37 |
| 2742 |
Reddit’s database has two tables (2012) | Hacker News |
https://news.ycombinator.com/item?id=32407873 |
databases
|
2022 Aug 10 07:00 |
| 2737 |
davidlatwe/montydb: Monty, Mongo tinified. MongoDB implemented in Python ! |
https://github.com/davidlatwe/montydb |
python
databases
|
2022 Aug 09 17:44 |
| 2736 |
msiemens/tinydb: TinyDB is a lightweight document oriented database optimized for your happiness :) |
https://github.com/msiemens/tinydb |
python
databases
|
2022 Aug 09 17:42 |
| 2730 |
simple-graph/python at main · dpapathanasiou/simple-graph |
https://github.com/dpapathanasiou/simple-graph/tree/main/python |
python
databases
|
2022 Aug 09 05:27 |
| 2549 |
Ten SQL Tricks that You Didn’t Think Were Possible (Lukas Eder) - YouTube |
https://www.youtube.com/watch?v=mgipNdAgQ3o |
databases
|
2022 Jul 27 16:06 |
| 2545 |
Run Numba functions in SQLite: WTF? - Phillip Cloud - YouTube |
https://www.youtube.com/watch?v=PNvaDm8SKPs |
python
databases
|
2022 Jul 27 15:52 |
| 2538 |
Без ОРМ - YouTube |
https://www.youtube.com/watch?v=qEfNez0Ht7s |
databases
|
2022 Jul 27 13:43 |
| 2478 |
009. B-деревья. Система непересекающихся множеств - М. А. Бабенко - YouTube |
https://www.youtube.com/watch?v=KFcpDTpoixo |
algorithms
databases
|
2022 Jul 27 13:06 |
| 2432 |
Talk: Hannah Stepanek - Let's talk Databases in Python: SQLAlchemy and Alembic - YouTube |
https://www.youtube.com/watch?v=36yw8VC3KU8 |
python
databases
|
2022 Jul 27 12:11 |
| 2405 |
D. Richard Hipp - SQLite [The Databaseology Lectures - CMU Fall 2015] - YouTube |
https://www.youtube.com/watch?v=gpxnbly9bz4 |
databases
|
2022 Jul 27 11:29 |
| 1988 |
One-liner for running queries against CSV files with SQLite | Hacker News |
https://news.ycombinator.com/item?id=31824030 |
databases
|
2022 Jun 21 15:59 |
| 1867 |
The Winamp Skin Museum is powered by a SQLite3 database with 1.2GB of metadata | Hacker News |
https://news.ycombinator.com/item?id=31703874 |
databases
|
2022 Jun 12 09:19 |
| 1779 |
Intro, Data Modeling, Databases | Prisma's Data Guide |
https://www.prisma.io/dataguide/ |
databases
|
2022 Jun 05 15:01 |
| 1777 |
davidlatwe/montydb: Monty, Mongo tinified. MongoDB implemented in Python ! |
https://github.com/davidlatwe/montydb |
python
databases
|
2022 Jun 05 09:11 |
| 1758 |
Orm subclass of python list |
|
python
databases
|
2022 Jun 02 06:47 |
| 1754 |
Вводная по сложным запросам в SQLAlchemy / Хабр |
https://habr.com/ru/company/true_engineering/blog/226521/ |
python
databases
|
2022 Jun 01 12:24 |
| 1739 |
Ask HN: Raw SQL vs. ORM? | Hacker News |
https://news.ycombinator.com/item?id=16809620 |
databases
|
2022 May 30 15:33 |
| 1738 |
orm | Search powered by Algolia |
https://hn.algolia.com/?dateRange=all&page=0&prefix=true&query=orm&sort=byPopularity&type=story |
databases
|
2022 May 30 15:08 |
| 1735 |
The end of big data | Hacker News |
https://news.ycombinator.com/item?id=31515938 |
databases
|
2022 May 29 15:44 |
| 1730 |
dpapathanasiou/simple-graph: This is a simple graph database in SQLite, inspired by "SQLite as a document database" |
https://github.com/dpapathanasiou/simple-graph |
python
databases
|
2022 May 28 21:50 |
| 1728 |
dataset 1.5.2 documentation |
https://dataset.readthedocs.io/en/latest/ |
python
databases
|
2022 May 28 21:49 |
| 1727 |
SQLite as a document database |
https://dgl.cx/2020/06/sqlite-json-support |
databases
|
2022 May 28 21:49 |
| 1722 |
DuckDB - An in-process SQL OLAP database management system |
https://duckdb.org/ |
databases
|
2022 May 28 09:35 |
| 1720 |
TIL you can not create explicit cursor in python sqlite module |
https://docs.python.org/3/library/sqlite3.html#using-shortcut-methods |
python
databases
|
2022 May 27 12:42 |
| 1719 |
foreign keys | Search powered by Algolia |
https://hn.algolia.com/?dateRange=all&page=0&prefix=true&query=foreign%20keys&sort=byPopularity&type=story |
databases
|
2022 May 27 12:09 |
| 1718 |
dpapathanasiou/simple-graph: This is a simple graph database in SQLite, inspired by "SQLite as a document database" |
https://github.com/dpapathanasiou/simple-graph |
python
databases
|
2022 May 27 10:41 |
| 1708 |
ORM — отвратительный анти-паттерн / Хабр |
https://habr.com/ru/post/667078/ |
databases
|
2022 May 25 13:39 |
| 1703 |
Python Database API. Firstly, Let us understand What is… | by Yashi Agarwal | Medium |
https://medium.com/@er.26yashiagarwal/python-database-api-beb8e61109cf |
python
databases
|
2022 May 25 12:10 |
| 1702 |
PEP 249 – Python Database API Specification v2.0 | peps.python.org |
https://peps.python.org/pep-0249/ |
python
databases
|
2022 May 25 12:03 |
| 1691 |
Talk - Sangarshanan: Build-a-Database with Python - YouTube |
https://www.youtube.com/watch?v=Ay9MNXXURBc |
databases
|
2022 May 24 17:21 |
| 1685 |
Modern SQL: A lot has changed since SQL-92 |
https://modern-sql.com/ |
databases
|
2022 May 23 13:28 |
| 1684 |
migrations | Search powered by Algolia |
https://hn.algolia.com/?dateRange=all&page=0&prefix=true&query=migrations&sort=byPopularity&type=story |
databases
|
2022 May 23 07:21 |
| 1680 |
ponyorm | Search powered by Algolia |
https://hn.algolia.com/?dateRange=all&page=0&prefix=true&query=ponyorm&sort=byPopularity&type=story |
python
databases
|
2022 May 22 20:24 |
| 1679 |
PonyORM - Python ORM with beautiful query syntax |
https://ponyorm.org/ |
python
databases
|
2022 May 22 20:24 |
| 1674 |
Как писать и тестировать миграции БД с Alembic - YouTube |
https://www.youtube.com/watch?v=KFj3VhMTAdk |
python
databases
|
2022 May 22 08:47 |
| 1673 |
python sql query builder - Google Search |
https://www.google.com/search?hl=en&q=pythoon%20sql%20query%20builder |
python
databases
|
2022 May 22 08:13 |
| 1639 |
System design hack: Postgres is a great pub/sub and job server | Hacker News |
https://news.ycombinator.com/item?id=21484215 |
databases
|
2022 May 18 22:19 |
| 1638 |
Publish–subscribe pattern - Wikipedia |
https://en.wikipedia.org/wiki/Publish%E2%80%93subscribe_pattern |
coding
databases
|
2022 May 18 22:15 |
| 1637 |
DuckDB – An embeddable SQL database like SQLite, but supports Postgres features | Hacker News |
https://news.ycombinator.com/item?id=24531085 |
databases
|
2022 May 18 22:12 |
| 211 |
Quickstart — peewee 3.14.10 documentation |
http://docs.peewee-orm.com/en/latest/peewee/quickstart.html#quickstart |
python
databases
|
2022 May 18 18:11 |
| 207 |
Jailer: A truly relational database tool | Hacker News |
https://news.ycombinator.com/item?id=31420930 |
tools
databases
|
2022 May 18 18:00 |
| 199 |
What are some good Python ORM solutions? - Stack Overflow |
https://stackoverflow.com/questions/53428/what-are-some-good-python-orm-solutions |
python
databases
|
2022 May 18 17:14 |
| 113 |
Orm that is subclass of python list |
|
python
databases
|
2022 May 17 08:34 |
| 92 |
SQLite cron-based backup (alternative to Litestream for simpler usecases) | Hacker News |
https://news.ycombinator.com/item?id=31386330 |
databases
|
2022 May 15 09:17 |
| 91 |
Я написал серверную SQLite / Хабр |
https://habr.com/ru/company/skillfactory/blog/665708/ |
databases
|
2022 May 15 09:15 |
| 77 |
Friendlier SQL with DuckDB | Hacker News |
https://news.ycombinator.com/item?id=31355050 |
databases
|
2022 May 12 15:04 |
| 69 |
I'm all-in on server-side SQLite | Hacker News |
https://news.ycombinator.com/item?id=31318708 |
databases
|
2022 May 10 09:51 |
| 37 |
Why isn’t there a decent file format for tabular data? | Hacker News |
https://news.ycombinator.com/item?id=31220841 |
databases
|
2022 May 08 18:55 |
| 33 |
SQLModel |
https://sqlmodel.tiangolo.com/ |
python
databases
|
2022 May 08 18:43 |
| 28 |
Welcome to Alembic’s documentation! — Alembic 1.7.7 documentation |
https://alembic.sqlalchemy.org/en/latest/ |
python
databases
|
2022 May 08 17:56 |
| 17 |
Как изучить SQL за ночь или шпаргалка для системного аналитика / Хабр |
https://habr.com/ru/post/664550/ |
databases
|
2022 May 08 14:28 |