kirby, 3 months ago the robot told me i have to do this. i think i can trust the robot thistime
the robot told me i have to do this. i think i can trust the robot thistime
icedquinn, 3 months ago @kirby :blobcatpolicedonut: why are you using LLMs these things are only good for shitposting
@kirby :blobcatpolicedonut: why are you using LLMs these things are only good for shitposting
kirby, 3 months ago @icedquinn will you tel me the answer to the problemo
@icedquinn will you tel me the answer to the problemo
icedquinn, 3 months ago @kirby what are you doing full text search?
@kirby what are you doing full text search?
kirby, 3 months ago @icedquinn yes
@icedquinn yes
icedquinn, 3 months ago @kirby sqlite has a service for this https://www.sqlite.org/fts5.html
@kirby sqlite has a service for this https://www.sqlite.org/fts5.html
kirby, 3 months ago @icedquinn oh cool thanks
@icedquinn oh cool thanks
kirby, 3 months ago @icedquinn integer types no longer work with the fts5 tables
@icedquinn integer types no longer work with the fts5 tables
kirby, 3 months ago @icedquinn [i need those for future queries in the application]
@icedquinn [i need those for future queries in the application]
icedquinn, 3 months ago @kirby so use subqueries :neocat_woozy:
@kirby so use subqueries :neocat_woozy:
mia, 3 months ago @icedquinn @kirby iceshrimp uses postgres’ pg_tgrm (trigram matching) extension for this, it’s very fast (near-instant for me with 7 million posts in the db)
@icedquinn @kirby iceshrimp uses postgres’ pg_tgrm (trigram matching) extension for this, it’s very fast (near-instant for me with 7 million posts in the db)
icedquinn, 3 months ago @mia @kirby kirby is using sqlite. though postgres search is decent https://rachbelaid.com/postgres-full-text-search-is-good-enough/ for pre-neural code.
@mia @kirby kirby is using sqlite. though postgres search is decent https://rachbelaid.com/postgres-full-text-search-is-good-enough/ for pre-neural code.
Add comment