Interesting finds: <SQLite JSON Superpower: Virtual Columns + Indexing>
- Store JSON document raw
- Create virtual generated columns using json_extract
- Add indexes to those generated columns
- Query JSON at full speed
dbpro.app/blog/sqlit...
#sqlite #interestingfinds
I’m taking you guys with me on a walk.
#morningstroll #interestingfinds
I came across this news article the other night. They discovered a Civil War era artillery shell near Little Round Top in Gettysburg back in 2023.
🔗 www.smithsonianmag.com/smart-news/c...
#Pennsylvania #CivilWar #Historic #History #HistorySky #InterestingFinds #BattleOfGettysburg #LittleRoundTop
