Detailed explanation of Android external storage and internal storage, from entry to mastery
The complete code is as follows:
public class ExternalActivity extends AppCompatActivity {
private EditText infoEdt;
private TextView txt;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_external);
infoEdt = ...
Posted by hammerloaf on Thu, 16 Dec 2021 21:42:49 +0100
Full coverage of MySQL Foundation
Database benefits
1.Persistent data to local
2.It can realize structured query and facilitate management
Database related concepts
1,DB: Database, a container that holds a set of organized data
2,DBMS: Database management system, also known as database software (product), is used for management DB Data in
3,SQL:Structured query langu ...
Posted by keyurshah on Thu, 16 Dec 2021 18:35:38 +0100
Principle and practice of mysql master-slave synchronization (the most complete)
1. Why master slave copy
In a system with complex business, there is a scenario in which an sql statement needs to lock the table, resulting in the temporary inability to use the read service, which will greatly affect the running business. Use master-slave replication, and let the master database be responsible for writing and the slave datab ...
Posted by Conjurer on Thu, 16 Dec 2021 15:55:31 +0100
95 quantile delay requires about 5ms. How to optimize the performance
The data system in the group cannot meet the performance requirements when undertaking a business requirement, so some optimizations are made for this scenario, and an article is written here for records.
The business scenario is as follows: the caller obtains hundreds of characteristics of a user at a time (characteristics can be understood a ...
Posted by MrTL on Thu, 16 Dec 2021 15:27:32 +0100
SQL lab shooting range explanation
sql injection is
When the user enters some sql statements that are not the user name or password
These statements are not filtered
After execution, the injector obtains the information of the database through echo and other methods
Water has been used for several days for visual studio 2022 and windows 11, so this article is a little ...
Posted by not_john on Thu, 16 Dec 2021 15:23:39 +0100
The difference between IQueryable and IEnumerable
When using Linq to sql in C#, IQueryable and IEnumerable are often confused. This article briefly analyzes the differences and usage scenarios between them.
preface
Whether Linq to object, Linq to sql or Linq to Entity, IQueryable and IEnumerable are delayed execution. The only difference between them lies in the parameter types of extension ...
Posted by robtbs on Thu, 16 Dec 2021 11:56:18 +0100
Redis series - redis persistence (an article lets you know about redis RDB and AOF persistence)
Persistence
Redis is an in memory database. It needs to be persistent in case of power failure and power loss. RDB is used by default. Generally, we can use it without modifying RDB configuration.
RDB (Redis DataBase)
What is RDB
Redis will create a fork subprocess separately for persistence. In the subprocess, it will cycle all data and wr ...
Posted by mewright on Thu, 16 Dec 2021 06:47:21 +0100
Python learning log 17 - Python database programming
Python learning log
Home page of RBHGO Welcome to pay attention
Warm tip: creation is not easy. If reprinted, indicate the source. Thank you for your cooperation~
catalogue
Python learning log Lesson 17 - Python database programming
DCL (data control language)
DCL - > grant or recall user permission - > grant / revoke
In ...
Posted by huzefahusain on Wed, 15 Dec 2021 18:38:56 +0100
Oracle database creation user, specifying default (create) tablespace, user permission assignment (empowerment) script (dba, ETL required)
Oracle database create user, specify default (create) tablespace, and grant permissions (dba, ETL are required)
preface
In the actual development process, creating users in the database, specifying tablespaces and assigning permissions to users are the basic operations. The script commands are introduced below.
Tip: the following ...
Posted by zarp on Wed, 15 Dec 2021 16:18:13 +0100
Connecting to external data sources using SAP HANA Virtual Table
Access Remote Sources with SAP HANA Database Explorer
Remote sources are connections to other databases. Virtual tables use remote sources to create local tables that point to data stored in another database. Federated queries use virtual and non virtual tables.
To illustrate these concepts, a table will be created in the remote database cont ...
Posted by Steveo31 on Wed, 15 Dec 2021 14:54:04 +0100