robconery / dox Goto Github PK
View Code? Open in Web Editor NEWA Document Database API extension for Postgres
License: MIT License
A Document Database API extension for Postgres
License: MIT License
Wouldn't an index on the specific parts of the JSONB structure be more efficient for what you are looking for? ie:
CREATE INDEX idx_jsonpart ON jsonTbl(cast(body->>'intvalue' AS INT));
No trigger maintenance and it would accomplish what I think you are attempting to accomplish via the lookup. Or am I missing the purpose behind the lookups?
how can we improve on that aspect any idea?
Both here in the README.md, and in your blog post, for the dox.save
function you use a named argument of 'table
', but the function actually uses a parameter 'collection
', like the rest of the API.
This project is quite interesting and compelling. Can you clarify the license for this code?
I would love to see dox provide the ability to detect and prevent lost "concurrent" updates. By which I mean concurrent users who retrieve a document in one transaction, then modify it outside the DB and save it back in another transaction.
Maybe dox could keep a version number on each document that increments on every save/modify. The version number could be returned with results. Save
and modify
could be made to optionally compare the current version number with the one specified in the incoming document and return an error if they don't match.
Hi Rob,
i can able to loop over all the documents and insert but performance prospective we need to insert at a time to all documents,
i read many places that we can use COPY, but how can we use it.
how can we insert bulk of documents into details jsonb and if we insert then how the primary key generate automatically, please help me.
Thanks.
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.