1. Create a test table
CREATE TABLE big_data
(
id character varying(50) NOT NULL,
name character varying(50),
datetime timestamp with time zone,
CONSTRAINT big_data_pkey PRIMARY KEY (id)
Month: September 2021
PostgreSQL – Postgres image is not created database
According to these docs, I can use env var POSTGRES_DB to specify the name of the database created by the postgres docker image. I set it in the docker-compose file, but it is not created.
Th
PostgreSQL – Is there a way to know the last submission value in the table?
I am using Postgres 9.5. If I update some values of a row and submit them, is there a way to get the old values later? I was wondering if there is something like flashback? But this will be a s
PowerDesigner creates a database table and exports SQL
I recently accepted a new project. The project structure uses jdbc to connect to the database, and the database uses orcal. I used to use hibernate to automatically generate tables. Now I have to d
Neo4j preliminary understanding and use
Introduction Graph Database is a special existence in the NoSQL database family, used to store rich relational data. Neo4j is currently the most popular graph database and supports complete transac
PowerDesigner prompts to install the printer
Question:
PowerDesigner will open every function Prompt to install the printer is very damning
Solution:
Just turn on this printer service
Question:
PowerDesigner will
Windows tools for analyzing PostgreSQL log files
I activated log_duration in the PostgreSQL configuration in order to find the most expensive query.
Now I am looking for a tool (Windows) that enables I can analyze the generated log files. C
What is the NOSQL database, the difference between NOSQL and SQL
NoSQL database is optimized for scalable performance and architectureless data model Non-relational database.
NoSQL databases are also widely recognized for their ease of development, low lat
PostgreSQL creation view
I have the following columns in Form A. They record user fingerprint “transactions” every time they register or check out from the building.
CREATE TABLE user_transactions(
id serial P
PowerDesigner generates Java code
Use the powerDesigner tool to draw the class diagram, and then let it generate java code
Use the powerDesigner tool to draw the class diagram, and then let it generate java code