A good database SDK – deepSQL is recommended
Well, it's a recommendation, but it's actually a database component that I wrote to introduce to you. This is the first edition, we hope you...
Read More
Tag: sql
Latest json and SQL data for China province, city and region
January 21, 2024
by 楊怡婷
No Comments
Latest json and SQL data for China province, city and region
Read More
Tired of writing SQL statements? Try GreenDAO
January 21, 2024
by Mandy Gray-Dunn
No Comments
Android base development library to make development easier. I used GreenDAO when I was choosing a database framework, but I didn't use it because it...
Read More
Diary 10 (Jenkins + aggregation)
January 21, 2024
by David Batchelar
No Comments
Today I listened to Jenkins + GitLab's automated build sharing. The road ahead is long...... In the old days of relational databases, multiple table queries...
Read More
Wechat full text search optimization road
January 21, 2024
by Craig Patchett
No Comments
Full-text Search (FTS) based on local data plays an important role in mobile applications. Different from the server-based search service, mobile terminal is limited by...
Read More
I’m going to do data persistence for Android
January 20, 2024
by 陳志豪
No Comments
In this day and age, data is becoming increasingly important, not only for countries, but also for individuals and companies. But the volume of data...
Read More
No mole! Let’s get some dry stuff! SQL optimization and diagnostics
January 20, 2024
by 邵雅涵
No Comments
SQL optimization and diagnosis Explain Diagnosis Explain parameters are described as follows: Column Name Description ID Execution number, which identifies the row to which the...
Read More
MYSQL import/export. SQL files
January 20, 2024
by Lance Stevenson
No Comments
MYSQL > Desktop > Computer > Properties > Environment Variables > New >PATH= "; The path \ mysql \ bin." Path indicates the installation path...
Read More
Some understanding, practice and traps about Netty
January 20, 2024
by Kashvi Sane
No Comments
Netty abstracts the network layer by using a Channel to represent connections. Read and write are events that occur on a Channel, and ChannelHandler is...
Read More
The difference between a SQL WHERE clause and a HAVING clause
January 20, 2024
by Angela Martinez
No Comments
MAX,MIN, COUNT, AVG, etc. The fundamental difference between these functions and others is that they typically operate on multiple records. SELECT SUM(sal) FROM emp where...
Read More
SQLite underlying query principles
January 20, 2024
by Veronica Farley
No Comments
The main feature of SQL (among all databases that use SQL statements, not just SQLite) is that it is an expressive programming language, not a...
Read More
The most complete SQL optimization solution in history (2)
January 20, 2024
by Ishaan Vyas
No Comments
Locate the problem point sucking: Hardware > System > Application > Database > Architecture (high availability, read/write separation, sub-library sub-table). Processing direction: clear optimization objectives,...
Read More
The third generation OF DRDS distributed SQL engine is released
January 20, 2024
by Jeffrey Warren
No Comments
DRDS (ali cloud distributed relational database service, https://www.aliyun.com/product/drds) released version 5.3 on April 30, annual update, with many new features, welcome to sample. DRDS (Ali...
Read More
Ten years of industry experience and words | attached to big data development beginners tutorial
January 20, 2024
by Robert Williams
No Comments
Some beginners often ask me in blogs and QQ that they want to develop in the direction of big data, what technologies they should learn...
Read More
[VIP video website project V1.0.3] VIP video website project and source code sharing based on Nodejs Express framework development
January 20, 2024
by Seth Harvey
No Comments
If the Windows environment, this program provides a visual installation. The user can enter the database name, database host address, database user name, database password...
Read More
Severless SQL on OSS experiment (DataLakeAnalytics on OSS)
January 20, 2024
by Jeffery Pineda
No Comments
Abstract: After data is stored in OSS, you can query and analyze OSS data in various ways, such as Spark, Presto, Impala (Ali Cloud EMR...
Read More
Net most detailed SQL syntax summary, quickly to secretly collect learning bar
January 20, 2024
by Bridget Johnson
No Comments
Schemas define information about how data is stored, what data is stored, and how the data is decomposed. Both databases and tables have schemas. Primary...
Read More
SQL optimizer principles – Query optimizer overview
January 20, 2024
by 林宜君
No Comments
This paper is an overview of database query optimizer, including query optimizer classification, query optimizer execution process and CBO framework Calcite. This is part of...
Read More
Hibernate does not support complex subqueries from (select…) The solution
January 20, 2024
by Robert Olson
No Comments
A complex subquery such as from (select......) was involved in the maintenance of a previous project. Form HQL statements are not supported. To put it...
Read More
SQL concepts and basic operations of database tables
January 20, 2024
by Hamish Richards
No Comments
SQL, database related concepts, TYPES of SQL statements, basic writing rules, basic operations of databases and data tables and other SQL basic knowledge.
Read More
How can you learn MySQL database quickly
January 20, 2024
by 韓雅惠
No Comments
Interest is the best teacher, no matter what knowledge to learn, interest can greatly improve learning efficiency. Learning MySQL 5.6 is no exception. The technology...
Read More
Proper use of indexes (SQL optimization), limit paging optimization, execution schedule, slow log query
January 20, 2024
by 寧靜怡
No Comments
Because indexes are designed to speed up searches, query efficiency goes through the roof when they are added. Adding an index to a database table...
Read More
Mybatis code practice
January 20, 2024
by Beverly Lewis
No Comments
Mybatis is a persistence layer framework. Java through Mybatis, procedures can be very convenient to operate the database. Enables developers to focus on SQL statements...
Read More
PostgreSQL database from beginner to master
January 20, 2024
by Christina Webb-Murphy
No Comments
PostgreSQL is the most powerful open source database in the world. It is an object-relational database management system based on POSTGRES 4.2 developed by the...
Read More
JEESZ Distributed Framework – Technical Documentation
January 20, 2024
by Matthew Skinner
No Comments
Hibernate is harder to really master than Mybatis. The Mybatis framework is relatively simple and easy to use, but also relatively crude. Personally think to...
Read More
Get N offers in two months and look how I did it!
January 20, 2024
by Rebecca O'Brien
No Comments
Beijing - three years of experience -Java. During the two months of golden three silver four (I also interviewed several companies in early May, mainly...
Read More
The nuggets x of the technique salon of the hungry? | special architectural practice
January 20, 2024
by Jayan Chandran
No Comments
Nuggets X Ele. me Technology Salon is co-hosted by Nuggets and Ele. me. This event is a special event for architecture practice, focusing on Java....
Read More
753 awards invite new and old bloggers to enter the cloud habitat, ask technical staff to advertise
January 20, 2024
by Michelle Miller
No Comments
With a computer, a cell phone, a network, it seemed to own the world. However, while enjoying the convenience brought by the information life, have...
Read More