Technology Sharing

The application of bit operations in databases - taking MySQL and PG as examples

2024-07-11

한어Русский языкEnglishFrançaisIndonesianSanskrit日本語DeutschPortuguêsΕλληνικάespañolItalianoSuomalainenLatina

Table of contents

Preface

1. Two different database designs

1. Status field stores JSON

2. Use bitwise operations

2. Bit Operation Practice in Database

1. Bitwise operations in MySQL

2. PostgreSQL median operation practice

Conclusion

Preface

Personal profile

I have devoted myself to the research of technology for more than 30 years. I am proficient in various languages ​​such as Java, Linux, JavaScript, PHP, CSS, etc. I have made many contributions in the field of open source. I have established a developer documentation site to share some problems in technology development for everyone to read.

my contact information

Mail