Comments (2)
Thanks for the feedback, and thanks for the driver!
I wonder if it's an option to do streaming at the SQL level (using the large objection functions) rather than db driver level?
Perhaps a better description of that column would be "Native Streaming Blobs", because, in fact, using the large object functions via SQL is exactly what RelStorage does on pg8000 (or when using psycopg2 in async mode). But this has to divide an upload or download into chunks and perform iterative copying at the Python level (instead of natively in libpq at speed), and IIRC there are differences at the protocol level too. Ultimately it's closer to what MySQL does ("No, emulated via chunking.") than what psycopg2 does (even though the _lobject.py
file provides the same interface on pg8000).
from relstorage.
Cool, I'll close the issue, thanks for the quick response 👍
from relstorage.
Related Issues (20)
- Cache vacuuming can sometimes take way too long HOT 1
- Clarification on oids.sqlite3 in SQLite storage HOT 2
- FIPS support HOT 5
- Problem packing RelStorage HOT 5
- psycopg2.ProgrammingError: named cursor isn't valid anymore HOT 1
- When Relstorage 3.5.0 final or beta? HOT 2
- Why is psycopg2-binary not recommended in production use? HOT 3
- psycopg2.errors.DuplicateObject: type "temp_store" already exists HOT 7
- Relstorage cache problem? HOT 2
- Prepack fails HOT 2
- pg8000 driver - AttributeError: 'Connection' object has no attribute 'in_transaction' HOT 2
- Avoiding UnableToLockRowsToReadCurrentError exceptions HOT 2
- Question about Pyramid + ZODB + RelStorage performances HOT 2
- Unable to install: fails to build relstorage.cache.cache extension HOT 6
- Large PostgreSQL database with blobs HOT 3
- Persistent cache not working? HOT 5
- Problem installing on macOS Sonoma HOT 1
- Uses `six` library but does not declare it.
- POSKeyError after pack postgresql database
- Read-Only config not working with read-only postgres database HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from relstorage.