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
Author: Simo
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:
What does the NOSQL database mean?
Unlimited is a term currently floating in the world of NoSql.
What does this mean?
>I have a document with 3 attributes today, and then go to production, then when I need to add 2 more attri
PostgreSQL – Database exception in Slick 3.0 when insertion insertion
By batch inserting thousands of records every 5 seconds in Smooth 3, I got
org.postgresql .util.PSQLException: FATAL: sorry, too many clients already My data access layer looks like:
va
Mono a function for each updated row in PostgreSQL
I have a sql UPDATE statement in the plpgsql function. I now want to call the pg_notify function for each updated row, and am not sure if my solution is the best possibility.
I don’t know whe
Large capacity NOSQL solution: Aerospike actual combat
Github has been focusing on providing news push services for developers for many years. Through a push SDK, the mobile terminal establishes a long connection with the server and maintains an online
NOSQL – Redis: Handling failover?
Redis really seems to be a great product with built-in replication and amazing speed. After testing, it definitely feels like a 2010 memcached replacement.
However, since memcached is usually
PowerDesigner generates SQL table name with quotation number solution
When powerdesigner connects to oracle11g, I created a table aaa
The generated SQL statement is:
drop table ” aaa” cascade constraints;
create table “aaa”
(
“id” INT not null,
“name” NVARCHAR
Receive the postgreSQL backend behavior after “Termination” (‘x’) after “Commit”
We run postgres server v9.2.8 and use epgsql (erlang) as the client library. In some cases, we produce in a production environment but cannot reproduce it in a development environment , We are losi