PostgreSQL remote connection method
Sometimes when connecting remotely, it will report Error connecting to the server: fatal error: not used for host “…”, User “…”, database “…”, pg_hba
Tag: database
PostgreSQL – AWS Database Single Columns Add a lot of data
I am using PgAdmin to retrieve data from an AWS database. This works well. The problem is that I set a column to True after retrieving the corresponding row and initially set it to Null. Doing so w
MySQL Backup – Back up all databases in turn using mysqldump
In some scenarios, the databases need to be backed up separately, and in some scenarios, all the databases need to be backed up together. Hereby we organize this backup script
#! /bin/bash
#
What is the difference between NOSQL and the column-oriented database?
The more you read about NoSQL, it starts to sound like a column-oriented database.
What is the difference between NoSQL (such as CouchDB, Cassandra, MongoDB) and column-oriented databases (su
NOSQL database for storing big files?
I need to store very large (more than 512Mb) binary files in a NoSQL database. What special NoSQL database implementation allows? No experience, but Mongos GridFS is the only one I’ve heard of,
PostgreSQL – Export Heroku Postgres database, but exclude table
I want to export the Postgres database of my Heroku application, but I want to exclude a table. Is this possible?
This is the command I used to export the entire Postgres database:
$PGU
What type of NOSQL database is best suited to store hierarchical data?
What type of NoSQL database is best for storing hierarchical data?
For example, I want to store a forum post with a tree structure:
original post
+ re: original post< br /> + re: origi
[Big Data] In-depth analysis of the distributed algorithm of the NOSQL database
In-depth analysis NoSQL database distributed algorithm < /section> Although the NoSQL movement did not bring fundamental technological changes to distributed data processing, it s
PowerDesigner collaboration with SQL Server () data model and database of database
Data model conversion into database Generate database script according to DB design, “Database”-“Generate Database…”;
< /span>
Set the script storage path and name, select “Direct generati
An article detailed Nosql database Redis
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,