Typesense Part 3 adding an id field for each record and more Typesense Part 3 adding an id field for each record and more

January 14, 2023

laravel londinium

I saw an update to version 0.24 of typesense and I have built a new database of around 300,000 websites so it was time to install it on a live server!

curl -O https://dl.typesense.org/releases/0.24.0/typesense-server-0.24.0-amd64.deb
sudo apt install ./typesense-server-0.24.0-amd64.deb

check the status:

sudo systemctl status typesense-server.service

and do a healthcheck

curl http://localhost:8108/health

all ok!

One suggestion I saw to improve the typesense database import, is to give each entry a unique id, to make updating easier. So I have added an id field like so to the database query

    nwr
    ->selectRaw("CONCAT( points.nwr, '/', points.id)  AS id)
    londinium
    ->selectRaw(" CONCAT( seo.route)  AS id")

If you would like to contact me with this form on londinium.com, ilminster.net or via Twitter @andylondon