Tag:data base

  • [soul torture] do you really understand the management and use of MySQL?

    Time:2019-12-15

    By jeskson Source: front end tavern of dada MySQL management, database management and data table management, user management. Initialize database, create database, view database, delete database. Create data table, view data table, modify data table, delete data table. User management, creating and deleting users, granting and retrieving user rights, setting and changing user passwords. Database […]

  • Forced benchmarking of relational database with mongodb and elasticsearch

    Time:2019-12-15

    Structural benchmarking RDBMS MongoDB Elasticsearch Table Collection Index Row Document Document Column Field Field Schema Schema Mapping SQL DSL Noun interpretation RDBMS RDBMS is the relational database management system, which organizes data into related rows and columns. The computer software for managing RDBMS is the relational database management system. The commonly used database software includes […]

  • Smproxy 1.2.9 release! New status command monitoring panel function

    Time:2019-12-15

    Swoole MySQL Proxy A MySQL database connection pool developed by swoole based on MySQL protocol. principle The database connection is stored in memory as an object. When the user needs to access the database, the connection will be established for the first time. Instead of establishing a new connection, an established free connection object will […]

  • N multi environment n multi application personality configuration management how from chaos to simple?

    Time:2019-12-15

    Abstract:In order to debug and observe the application runtime performance in the development process of many projects, it is often necessary to package and release the application code and configuration items frequently to update the application version or even roll back the code in the constant configuration scenario. Based on this scenario, any application configuration […]

  • PY => PySpark-Spark SQL

    Time:2019-12-15

    Spark SQL Spark SQL is divided into three types: SQL Dataframe (reference pandas, but slightly different) Datasets (Python is not supported because it is dynamic) Initial environment: import findspark findspark.init() from pyspark.sql import SparkSession Spark = spark session. Builder. AppName (‘myspark ‘). Getorcreate() (initialize session) #Spark. Sparkcontext. Parallelize ([1,2,3,4]). Collect() ා, which contains the sparkcontext […]

  • Spring boot Security Learning (07) web login integration JDBC

    Time:2019-12-15

    Define users in the database Previously, we defined the user as the dead default user in the configuration file and code. Generally, we will not do this in the development. Our users are all from our user table and stored in the database. There are many technologies to operate the database. Spring security supports a […]

  • MySQL create user and authorization

    Time:2019-12-15

    MySQL create user and authorization Privilege management We know that our highest authority manager is root, which has the highest authority operation. Including select, update, delete, update, grant and other operations. In general, DBA engineers will create a user and password after the company, let you connect to the database operation, and set the permissions […]

  • Database objects

    Time:2019-12-15

    Synonyms are aliases of database objects; sequences are used to generate unique and continuous sequence numbers; View is a virtual table based on one or more tables; index is an optional structure related to tables, which is used to improve the performance of SQL statement execution I. database object: Mode object: Database object is a […]

  • Introduction to SQLite3 in C + +

    Time:2019-12-14

    I. Introduction to SQLite3 1. Personal opinions SQLite3 (official document) is a lightweight and widely used relational database. SQLite3 database can run on UNIX like and window like systems. Most UNIX like systems (such as Linux) have SQLite3 database installed by default, and the system used by individuals is Ubuntu 16.04. By default, SQLite3 database […]

  • The heterogeneous transition of automobile home from SQL server to tidb

    Time:2019-12-14

    Author: Automotive home Technical College – Technical Architecture Group SQL Server +. Net is the standard technology stack of many early Internet enterprises. Although tidb is a MySQL compatible and ecological database, the applicable business scenarios of tidb are universal. In the era of open source and new technology, how to seamlessly migrate from SQL […]

  • . NETCORE ORM visit domestic daydream database

    Time:2019-12-14

    Preface Founded in 2000, Wuhan Dameng database Co., Ltd. is a basic software enterprise under China Electronic Information Industry Group (CEC). It specializes in the research and development, sales and service of database management system, and provides users with services such as big data platform architecture consultation, data technology plan, product deployment and implementation. Over […]

  • How jushuitan builds a massive real-time data warehouse platform based on analyticdb for PostgreSQL

    Time:2019-12-14

    Introduction of data warehouse business in jushuitan Shanghai jushuitan Network Technology Co., Ltd. was established in 2014. At the beginning of jushuitan’s establishment, it entered the market with e-commerce SaaS ERP, and quickly gained the market leading position with its excellent products and services. With the continuous change of customer demand, now jushuitan has developed […]