Category:Database

  • New Features of MongoDB Time Series

    Time:2022-10-10

    Table of contents: Parsing MongoDB’s new feature “Timing” How to use time series in MongoDB? MongoDB Time Series Collection Performance MongoDB Time Series IOT Scenario Design 1. Analyze the new feature of MongoDB “sequence” MongoDB time series collection is a new feature of MongoDB 5.0. It can quickly write data to disk within a period […]

  • MacBook install Golang Oracle database driver

    Time:2022-10-10

    Golang to connect to Oracle needs to install Oracle Full Client or Instant Client Oracle’s Instant Client Suite download address #Select the Instant Client for macOS (Intel x86) download package as follows: instantclient-basic-macos.x64-19.8.0.0.0dbru.zip instantclient-sdk-macos.x64-19.8.0.0.0dbru.zip instantclient-sqlplus-macos.x64-19.8.0.0.0dbru.zip #Extract to the same directory as instantclient_19_8 unzip instantclient-basic-macos.x64-19.8.0.0.0dbru.zip unzip instantclient-sdk-macos.x64-19.8.0.0.0dbru.zip unzip instantclient-sqlplus-macos.x64-19.8.0.0.0dbru.zip #Print the path of the instantclient_19_8 directory […]

  • Implement a simple Database2 (translation)

    Time:2022-10-10

    Previous review:Implement a simple Database1 (translation) Annotation: cstsck maintains a simple sqlite-like database implementation on github. Through this simple project, you can have a good understanding of how the database works. This article is the second, mainly to realize the front-end components of the database, the compiler and some functions of the virtual machine Part […]

  • How to use Flying Bird SQLite to generate platform system documentation and software configuration development

    Time:2022-10-9

    How to use Flying Bird SQLite to generate platform system documentation and software configuration development?Sifu user TG telegram duotebb copyright, reprint please indicate the source.Why use SQLite to maintain documentation? Or use it to manage software configuration files? In this article, I’ll explain the benefits and demonstrate how to use SQLite to generate documentation. I […]

  • Redis killed twelve questions, almost couldn’t resist!

    Time:2022-10-9

    Redis is a hurdle that cannot be bypassed in an interview. As long as you have used Redis in your resume, you will definitely not be able to escape. Today, let’s simulate how the interviewer goes in-depth on the topic of Redis step by step, and comprehensively examines the candidate’s mastery of Redis. Little Two: […]

  • mongodb basic concepts

    Time:2022-10-9

    Documentation It is the smallest data set unit of mongodb, a data unit in which multiple key-value pairs are ordered and tenanted together, similar to the records of relational databases gather A collection of documents. Documents store data. The structure of the collection can be different. A collection is similar to a table in a […]

  • Oracle12c New Features Daquan IO Resource Isolation

    Time:2022-10-9

    In 12cR2, two parameters MAX_IOPS and MAX_MBPS were introduced to limit the physical IO of the PDB. These two parameters only apply to PDBs, not CDBs and non-multi-tenant environments. In addition, these two parameters do not limit the writing of redo log (LGWR process) and the writing of buffer cache dirty blocks to disk (DBWR […]

  • The evolution of Sqlite concurrent read and write

    Time:2022-10-8

    Introduction The underlying storage of sqlite is based on B-tree. The basic reading and writing unit of B-Tree to the underlying storage is page, and each page is corresponding to a globally unique page number. Generally speaking, the page number starts to increase from 1. The process of modifying data by the storage engine of […]

  • A full set of Redis study notes compiled by Tencent bosses in 2 months, covering all core knowledge points

    Time:2022-10-8

    Redis is an open source, in-memory, key-value database written in C and provides APIs in multiple languages. Its data structure is very rich, and the basic data types include: string (string), list (list, doubly linked list), hash (hash, set of key-value pairs), set (set, unique) and sorted set (ordered set) gather). Mainly used for databases, […]

  • Event Registration | MongoDB Core Functions and Principle Analysis

    Time:2022-10-8

    Have more questions about MongoDB that you want answered? Welcome to the MongoDB Chinese community online live communication event! Want to get more extension and expansion information based on the text version of the image document, and learn more about the core feature analysis of MongoDB more intuitively and quickly? Want to speed up the […]

  • Summary of database injection privilege escalation (4)

    Time:2022-10-8

    Oracle Oracle Privilege Classification A permission is the user’s right to perform a function. In Oracle, according to the different management methods of the system, Oracle authority is divided into two categories: system authority and entity authority. System permissions refer to whether an authorized user can connect to the database and what system operations can […]

  • MySQL Basics

    Time:2022-10-8

    MySql basics Comparison of data storage methods in Java storage method advantage shortcoming Memory high speed It cannot be saved permanently, the storage of data is temporary document Data can be stored permanently Inconvenient to manipulate data database 1. Data can be saved permanently2. Fast query speed3. Easy to manage data Occupies resources, some databases […]