Tag：data base
-
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 […]
-
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 […]
-
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 […]
-
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 […]
-
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 […]
-
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 […]
-
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 […]
-
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 […]
-
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 […]
-
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 […]
-
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 […]
-
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 […]
