Simo, Author at Simon Technology Blog

How do I correctly design a VS matching table in PostgreSQL?

I have considered this problem, and I have not come up with something better. So let me describe my problem, my current solution, and what I want to improve Place. I also have some concerns, such a

September 21, 2021By Simo Postgresql Correction, design, How to, matching, PostgreSQL, table, VSLeave a Comment

PostgreSQL – How do I check the remaining size of persistent disks on Google Cloud? Where can I find the code in the instance?

I created a project on Google Cloud a long time ago and I am currently experiencing some problems. The only result I seem to receive is an internal server error.

I tried to connect to the com

September 21, 2021By Simo Postgresql check, Cloud, Disk, Google, How to, lasting, PostgreSQL, Size, Where, You canLeave a Comment

PostgreSQL, Triple Group and Similarity

Just test PostgreSQL 9.6.2 on my Mac and use Ngrams.
Assuming the brewery has a GIN triplet index.

Similarity limit (I know this is deprecated):

SELECT set_limit(0.5); I am building on

September 21, 2021By Simo Postgresql 3 yuan, Group, PostgreSQL, similarity, ternaryLeave a Comment

Manage users using PostgreSQL

Our system will run on a local network, where no more than 50 clients connect to the same local server. We are creating a DB user for each client to take advantage of postgresql permissions System.

September 21, 2021By Simo Postgresql management, PostgreSQL, use, usersLeave a Comment

How does NOSQL perform a horizontal extension and how it is more effective than RDBMS extension

I am reading an article about noSQL and relational DBMS.
After many posts, I cannot understand exactly how the noSQL system performs horizontal expansion and how it is more effective than RDBMS ex

September 21, 2021By Simo Nosql and how, execute, Extension, How, Level, more effective, NOSQL, RDBMSLeave a Comment

PostgreSQL multi-column unique

I have a strange situation in PostgreSQL 9.4.
I have a table:

id integer NOT NULL DEFAULT nextval(‘users_userpropmeta_id_seq’::regclass)
name character varying(255) NOT NULL
cls character va

September 21, 2021By Simo Postgresql inadvertent, multiple columns, PostgreSQL, UniqueLeave a Comment

In PostgreSQL, how to cancel the time zone offset using “At Time Zone”

I’m trying to bypass the Postgresql time zone and I can’t seem to figure this out. EST is “Eastern Standard Time” in the United States, usually UTC-5.

Example 1: Basic test

select ’08/3

September 21, 2021By Simo Postgresql cancel, how to use, in, offset, PostgreSQL, time, time zone, ZoneLeave a Comment

PowerDesigner imports using SQL script

1. Prepare the script for creating the database

2 , Import SQL into powerDesigner

September 21, 2021By Simo Power Designer import, PowerDesigner, Script, SQL, useLeave a Comment

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

September 21, 2021By Simo Postgresql database, Excluded, export, Heroku, Postgres, PostgreSQL, tableLeave a Comment

Can I build complex queries for NOSQL DB?

I have been studying noSQL DB, and I have not been able to answer myself satisfactorily: Can complex queries be constructed on noSQL DB?

The type of query I want to know will be like this:

September 21, 2021By Simo Nosql build, Complex, DB, for, NOSQL, query, Whether it isLeave a Comment