A picture to explain the branch products of DB
Introduction to osql database
It is a non-relational database service that can solve the concurrency capabilities of conventional databases,
Month: September 2021
How to sort in PostgreSQL via UUID?
Is there any order guarantee for using uuid_generate_v1() on postgresql?
If yes, it does not matter whether it is guaranteed to generate the UUID on each machine or on which machine? Since V1
Anyone uses the NOSQL database for medical record storage?
Electronic medical records are composed of different types of data. The access information (date/location/insurance information) seems to be applicable to the RDMS. Other types of medical informati
PostgreSQL – Postgres unique constraint is not forced uniqueness
This is my constraint:
CREATE UNIQUE INDEX index_subscriptions_on_user_id_and_class_type_id_and_deleted_at
ON subscriptions
USING btree
(user_id, class_type_id, deleted_at); This query pr
PostgreSQL – Postgres hierarchy – counting of sub-level, sorted by subkey or grandson
I want to know how to write a postgres subquery so that the following example will output what I need.
id parent_id postdate
1 -1 2015-03-10
2 1 2015-03-11 (child level 1)
3 1 2015
PostgreSQL arrangement by query optimization order
I encountered a small problem here.
SELECT DISTINCT ON (“reporting_processedamazonsnapshot”.”offer_id”) *
FROM “reporting_processedamazonsnapshot” INNER JOIN
“offers_boooffer”
ON (“report
Introduction to the Venice Source Code and Nosql
NoSQL (Not Only SQL), which means “not just SQL”, is a brand-new revolutionary database movement. It was proposed in the early days, and the trend has been increasing until 2009. Proponents of NoSQ
High concurrent large capacity NOSQL solution exploration
In the era of big data, enterprises also put forward higher requirements for DBAs. At the same time, NoSQL, as a newly emerging technology in recent years, has also received more and more attention
PowerDesigner batch modification column case
Faced with different database capitalization specifications, it is too troublesome to modify each field. If you use PowerDesigner design, there is a relatively simple method. Enter PowerDesigner, o
PostgreSQL – Error in top level: flunt.entityError.Nodatabase
I am trying to fix an error I recently encountered while running the Vapor project.
It builds well, but when it runs, it crashes. This is my log:
fatal error: Error raised at top level: