Tag:postgresql

  • KunlunBase Guide Manual (4) Real-time Synchronization Data from Oracle

    Time:2022-12-6

    1. Environment and software requirements Oracle GoldenGate supports data replication between Oracle database and KunlunBase starting from 11.2.1.0.2. This document provides the basic configuration scheme of the data replication process, involving specific configurations of different operating systems and database versions, please refer to the official document. Software Requirements: Oracle GoldenGate for Oracle Oracle GoldenGate for […]

  • Data Import & Synchronization of KunlunBase Guidebook (3)

    Time:2022-12-5

    1. Environment Migrate business data from the native PostgreSQL database to the KunlunBase cluster. Since KunlunBase is compatible with the postgreSQL protocol, it can directly support Pg data import and export tools: pg_dump and pg_restore. However, since the currently compatible PostgreSQL version of KunlunBase is 11.5, for inconsistent versions: newer version tools can be compatible […]

  • All the hard work and the sweetness of the domestic database list-March 2022

    Time:2022-12-4

    Database classification With the development of databases, many new words have emerged, such as HATP, NewSQL, distributed, cloud native, etc., through the following introduction to database classification to understand these concepts. relational database (SQL) A relational database refers to a database that uses a relational model to organize data. Relational databases are divided into: OLAP, […]

  • High-altitude cleaners can operate robots to wash buildings

    Time:2022-12-3

    9:0012:0017:00used a robot When it comes to hot weather, it is easy to think of those who work diligently under the scorching sun, and “Spiderman” is a typical representative of such people. They don’t know how to do light work, and they don’t have the super power of Spiderman, but they walk on the high-rise […]

  • Use the SQL preprocessing function of Go language ORM library worm

    Time:2022-12-3

    Worm supports the precompilation of SQL statements. Using SQL statement precompilation can improve the efficiency of database access. SQL statement precompilation can be enabled in three ways in worm: global enablement, session enablement, and statement enablement. Enable global SQL precompilation package main import ( “database/sql” _ “github.com/go-sql-driver/mysql” log “github.com/haming123/wego/dlog” “github.com/haming123/wego/worm” ) func main() { dbcnn, […]

  • Multiplier Technology Joins PolarDB Open Source Database Community

    Time:2022-12-2

    Multiplier Technology signed Alibaba’s open source CLA (Contribution License Agreement, Contribution License Agreement), and officially joined the Alibaba Cloud PolarDB open source database community.PolarDB is a new-generation database product family developed by Alibaba. Under the separation of storage and computing architecture, PolarDB takes advantage of the combination of software and hardware to provide users with […]

  • How to enter wgcloud and import wgcloud-PostgreSQL.sql

    Time:2022-12-1

    Import with Navicat Premium

  • Example of KunlunBase function experience

    Time:2022-11-30

    1. Database capacity test It is recommended to use sysbench for relevant performance tests. For details, please refer to:https://github.com/akopytov/s… Related sysbench options can refer to:https://github.com/akopytov/s… Capacity testing can be done with the following command after installing sysbench sysbench oltp_point_select \ –tables=[several data tables in total] \ –table-size=[The amount of data to be filled in each […]

  • Postgresql12 opens pg_stat_statements extension

    Time:2022-11-30

    read first This article is based on pg12, different versions can perform similar operations in the following document linkshttps://www.postgresql.org/do…The mirror uses postgres:12-alpine Introduction to postgresql-contrib postgresql-contrib is also called contrib module, which is a non-pg core package, most of which are tools for statistics, performance and data synchronizationTo quote a sentence from the postgres official […]

  • DapuStor joins the PolarDB open source database community

    Time:2022-11-28

    Recently, DapuStor signed the Alibaba Open Source CLA (Contribution License Agreement, Contribution License Agreement), formally joining hands with the Alibaba Cloud PolarDB open source database community. As a global database leader, Alibaba Cloud Database firmly embraces open source, has actively participated in the construction of open source communities over the years, and has made many […]

  • Hongshan Technology Joins Alibaba Cloud PolarDB Open Source Database Community

    Time:2022-11-28

    Hongshan Technology signed the Alibaba Open Source CLA (Contribution License Agreement, Contribution License Agreement), formally joining hands with the Alibaba Cloud PolarDB open source database community.As a global database leader, Alibaba Cloud Database firmly embraces open source, has actively participated in the construction of open source communities over the years, and has made many contributions […]

  • Free training camp limited time rush report|Big coffee guides you to play PolarDB for PostgreSQL open source training camp

    Time:2022-11-27

    At the Alibaba Cloud Developer Conference on May 29, 2021, Alibaba Cloud announced the official open source cloud-native database capability and the source code of the relational database PolarDB for PostgreSQL. This time Alibaba Cloud open sourced PolarDB for PostgreSQL distributed version, including database kernel, related plug-ins, tool scripts, test cases and design documents, suitable […]