[new series] database - Githubissues

ambersun1234 / chirpy.ambersun1234.github.io

ambersun1234's personal blog, powered by Jekyll

https://ambersun1234.github.io

MIT License

0 stars 0 forks source link

[new series] database #8

Open ambersun1234 opened 3 years ago

ambersun1234 commented 3 years ago

[x] b+ tree
[ ] sql, nosql, newsql
[ ] ER model
[x] b tree vs hash index
[ ] cascade

[ ] stored procedure
[ ] how to speed up query
[ ] why is it a bad idea to store blob in database instead of pointer to file
[ ] full table scan
[ ] regex like performance
[ ] elastic search
[ ] varbinary, varchar

[x] select N + 1 problem

[x] redis
- [x] transaction post link

[x] transaction

[ ] dao
[ ] repository pattern

ambersun1234 commented 2 years ago

Is it safe to expose mongoDB ObjectID in URLs/APIs? Using UUIDs instead of ObjectIDs in MongoDB Why do we need "Relationships" between tables at all? What does the word "SARGable" really mean? 8.3.6 Multiple-Column Indexes