News for hackers. Stuff that matters.
Re:Full text search on 400M US court cases by rpedela on Thursday November 19, 2020 @06:07PM (#25155446)
Yeah. What I do is create a view that does all the joins then the middleware just needs to do "SELECT * FROM my_view". If the DB has good JSON support, I will also convert the data into an ES index request with SQL so the middleware becomes even simpler.
Re:Full text search on 400M US court cases by lolive on Friday November 20, 2020 @01:20AM (#25157775)
Let’s say you have a mostly read-only DB (otherwise things are different).

Does it work when the view is insanely big? [i am not an expert at DBs, so my vision of a big DB might amuse you, but let’s say I have millions of rows to assemble as a view].