Tag:Database

  • Comparison of MySQL and PostgreSQL single instance pressure test

    Time:2022-5-3

    Recently, I want to choose an appropriate database as the internal database to save some internal data, so I want to make a simple pressure test and comparison of common SQL databases. test This pressure test uses the default docker container without any configuration. Use separatelysysbenchConduct 300 second pressure test of 8, 16, 32, 64 […]

  • “Xinchuang” tuyere, a new opportunity for domestic databases

    Time:2022-5-3

    Since last year, a word has been repeatedly mentioned in the IT industry – “Xinchuang“, which seems to be a hot topic and has become a phenomenal outlet. In short, Xinchuang refers to a series of information innovation technologies of hardware and software, which can be understood as digital infrastructure. It is the bottom link […]

  • Basic use of mysqli

    Time:2022-5-3

    Simple example Process oriented approach //Create database connection $connect = mysqli_connect(‘127.0.0.1’, ‘root’, ‘root’, ‘test’, 8889); //Judge whether the connection is successful if (!$connect) { Echo ‘database connection failed’; //Print reason for connection failure var_dump(mysqli_connect_error($connect)); exit(); } //Set character set mysqli_set_charset($connect, ‘utf8’); //Assemble SQL statements $sql = “SHOW TABLES”; //Execute SQL statement $res = mysqli_query($connect, $sql); […]

  • Tcallusdb Jun · industry news collection (May 20)

    Time:2022-5-3

    Tcallusdb has been paying close attention to the dynamics of the game industry and database industry. The following is a compilation of the recent news of the game industry and database industry collected by tcallusdb Jun, which is dedicated to you.(part of this article comes from the Internet) The new products of the game made […]

  • Tencent cloud logstash actual combat 2- synchronize the data in MySQL to elasticsearch

    Time:2022-5-3

    Logstash can also be used to synchronize data in relational databases such as MySQL and PostgreSQL to other storage media. The following describes how to use itTencent cloud logstashSynchronize data into the MySQL product. Create pipe On the “pipeline management” page, click the “new pipeline” button to create a pipeline: Enter the pipeline configuration page, […]

  • MySQL – Advanced CRUD

    Time:2022-5-2

    Advanced addition, deletion, query and modification I Database Constraints 1. Constraint type 2. NULL constraint 3. Unique: unique constraint 4. Default: default value constraint 5. Primary key: primary key constraint 6. Foreign key: foreign key constraint 7. Check constraints II Table design 1. One to one 2. One to many 3. Many to many III […]

  • Use redistemplate to batch add values to the set set (batch add values to variable parameters)

    Time:2022-5-2

    There was a problem adding values to redis set data types in batches today He supports multiple values, but I’m not sure how many values I add redisTemplate.opsForSet().add(“key”,”value1″,”value2″,”value3″); Click in the adding method of redistemplate to see that the number of value values specified by redistemplate is variable PS: can you see who the background […]

  • Buuctf – I have a database

    Time:2022-5-2

    Buutf – I have a database 1. Information collection (use Royal sword to scan the background) (scan to database background phpMyAdmin) 2. Analyze database vulnerabilities 3. Information collection (phpMyAdmin version 4.8.1 vulnerability found) – Myphweb is an open source [myphweb] Based( https://so.csdn.net/so/search?q=MySQL&spm=1001.2101.3001.7020 )Database management tools. Its index There is a file in PHP that contains […]

  • Mybatisplus multi table connection query

    Time:2022-5-2

    Logo picture ppt backplane 16_ 9 2.001. png 1、 Preface (1) Background content The most common selection component of Dao layer in software application technology architecture is mybatis. Friends who are familiar with mybatis know how beautiful mybatis was in the past. XML files are used to solve the problem of complex database access. Today, […]

  • SQL addition, deletion, modification and query

    Time:2022-5-2

    SQL addition, deletion, modification and query increase delete modify query SQL inserts the data of the query into another table SQL converts the data in JSON format and parses it into SQL data Unfinished to be continued increase Add a complete record –Add a whole piece of complete data, and each field name can be […]

  • Recommend an ORM framework called hasordb, which is currently version 4.3.0

    Time:2022-5-2

    introduce Hasordb is a full-featured database access tool, which provides object mapping, rich type processing, dynamic SQL, stored procedures, built-in paging dialect 20 +It supports nested transactions, multiple data sources, conditional constructors, insert policies, and multiple statements / results. And compatible with spring and mybatis usage.It does not rely on any other framework, so it […]

  • Five minutes to build blog comment component – Digital

    Time:2022-5-2

    preface Because I’m building my own blog recently, I need to have a comment function. I don’t want to build my own database. I also want to log in with a third party. After careful consideration, I decided to use digital [0]. It’s really fragrant after use, so I’ll give you a wave of Amway~ […]