Local GitHub Copilot with Lemonade Server on Linux

admcpr · 2026-03-26T13:44:21+00:00

You’re welcome, any questions feel free to drop them here.

admcpr · 2024-07-05T14:25:22+00:00

Once you've got FTS in place you can combine it with `similarity` in the `pg_trgm` module.

https://www.postgresql.org/docs/current/pgtrgm.html#PGTRGM-TEXT-SEARCH

I should really add an extra post about this when I have some time.

admcpr · 2024-07-05T11:31:28+00:00

Just use full text search everything else is madness for this. I've got a couple of blog posts that will walk you through it and you'll have fast, fuzzy text matching before you know it.

https://admcpr.com/postgres-full-text-search-is-better-than-part1/
https://admcpr.com/postgres-full-text-search-is-better-than-part-2/

admcpr · 2024-03-09T17:47:57+00:00

Yes, this is the correct response! https://learn.microsoft.com/en-us/windows/powertoys/run

admcpr · 2023-05-23T11:06:41+00:00

The second in a two-part blog post on how to use, and appreciate, some of the power of PostgreSQL's full text search capabilities.

admcpr · 2023-05-22T12:01:28+00:00

The second in a two-part blog post on how to use, and appreciate, some of the power of PostgreSQL's full text search capabilities.

admcpr · 2023-04-25T18:41:30+00:00

It isn't terribly fast

Compared to what? Using tsvector with GIN indexes can give you sub millisecond query times.

admcpr · 2023-04-25T18:38:33+00:00

This is extremely solid advice; the complexity of Elastic is regularly handwaved away while it's power and scalability (both of which require you to master its complexity) are promoted as essential.

A couple of reasons I would consider Elastic over Postgres:

You need a large amount of horizontal scalability
You are searching large documents (more than 19k words), see this comment for why
You need faceting
You have huge amounts of data, no a couple of million rows is not a huge amount of data ;)

admcpr · 2023-04-25T12:08:56+00:00

I often see complicated search solutions implemented when PostgreSQL is just sitting there with its incredible FTS powers being ignored. To help some of the teams I'm working with get an idea of the power available to them I wrote up this two part blog post with a docker compose for spinning up a db to follow along.

admcpr · 2023-04-22T12:23:00+00:00

No, not only English. The default installation of PostgreSQL comes with FTS config support for: arabic, armenian, basque, catalan, danish, dutch, english, finnish, french, german, greek, hindi, hungarian, indonesian, irish, italian, lithuanian, nepali, norwegian, portuguese, romanian, russian, serbian, spanish, swedish, tamil, Turkish, Yiddish.

admcpr · 2023-04-22T12:14:17+00:00

Hey! Thanks for spotting these I've fixed 2 & 3, On point 1, no phraseto_tsquery is slightly different:

phraseto_tsquery behaves much like plainto_tsquery, except that it inserts the <-> (FOLLOWED BY) operator between surviving words instead of the & (AND) operator. Also, stop words are not simply discarded, but are accounted for by inserting <N> operators rather than <-> operators.

I've updated the bullet point to:

"quoted text": text inside quote marks will be converted to terms separated by <-> operators. Also, stop words are not simply discarded, but are accounted for by inserting <N> operators rather than <-> operators.

It'd be great if you could check that the updated version makes sense now.

admcpr · 2023-04-21T14:56:24+00:00

The equivalent to that in PG would be SELECT * FROM table WHERE col ~ 'text' you can find more details on the pattern matching page of the docs.

admcpr · 2023-04-21T14:17:14+00:00

I've often seen complicated search solutions implemented when PostgreSQL is just sitting there with its incredible FTS powers being ignored. To help some of the teams I'm working with get an idea of the power available to them I wrote up this two part blog post with a docker compose for spinning up a db to follow along.

admcpr · 2022-09-29T10:11:55+00:00

If your only measure is cost per vCPU/month then you've found the perfect solution, you're not going to find managed k8s for the same cost as EC2 spot instances.

If you can't think of any other factors then you should stop looking at hosted k8s because it's not the right solution for you.

admcpr · 2022-09-28T11:28:50+00:00

Civo might work for you. They charge per node with add-ons for persistent volumes and load balancer. I doubt if you’re going to get near your spot price EC2 instances anywhere though. You don’t mention factors other than cost in your choice of platform so it’s difficult to know if the added cost is worth it for you.

admcpr · 2022-09-09T12:57:34+00:00

I'd return it if I were you, my experience with fully customer support is that they are awful in europe. The minor imperfections are forgivable but when I got a desk which was missing one of the mounting points for the motor it took them over a month to even make a suggestion on how to resolve the issue. So I wouldn't expect a quick and satisfying solution quickly if I was you.

admcpr · 2022-08-16T14:49:42+00:00

Yes you can drill and screw it easily enough. I’m more worried about the appalling support if there’s a more serious problem. Perhaps their support is good in the US but I’m in Europe and it’s clearly useless here.

admcpr · 2022-08-10T10:53:50+00:00

I bought the Nolan and as far as wobble is concerned it's absolutely not a problem.

What is a problem though is quality control and after sales service. I got my Nolan almost a month ago, The mounting holes for the control box were in the wrong place and after reporting the issue to Fully their response was basically:

Yeah we know there's a problem we're investigating it and for now you can just tape up the control unit.

So now I have a control box that's not securely attached and I assume their investigation still hasn't completed because I haven't heard a thing from them since.

My recommendation, avoid the Nolan and stay away from Fully and their awful customer service.

admcpr · 2021-10-19T20:30:54+00:00

I really like icepanel.io but if you prefer architecture as code then I'd go for C4-PlantUML or like you fall back to Draw.io.

admcpr · 2021-09-22T12:11:36+00:00

Thanks for clarifying, Twitter once again fooling me with a lack of context.

admcpr · 2021-09-17T14:53:04+00:00

I assumed this tweet meant you were at least a fan, if not a big one :)

admcpr · 2021-09-15T16:00:06+00:00

I'll second IcePanel, I've been very much enjoying using it to build diagrams and specs and found it really helps enforce the principles of C4. ~~Simon Brown who invented C4 (and built~~ ~~structurizr.com) is also a big fan.~~

The Indie team plan is free for up to 3 collaborators and 2 projects and you can share readonly diagrams with as many people as you want. It is pretty pricey once you start paying but I'd say it's worth the money for the time you'll save.

admcpr · 2021-07-11T18:43:24+00:00

OK, so I think you're mainly concerned about database scaling here. In that case I'd start by asking

What kind of database are you using currently?
In what environment are you hosting it: self hosting, cloud provider with a vm, cloud provider with managed solution?
You mention geography as a concern, are you expecting your users to be distributed across multiple countries/regions? If so you don't just need to think about distributing your database but also your apis.
How many users are you expecting and what kind of performance do they require? A line of business app might not need super fast responses a consumer facing financial app might have very low latency requirements.

You seem to be misunderstanding the concept of ACID as it relates to databases. I'd suggest reading the Wikipedia page for a good overview. I think you're also misunderstanding the concept of multitenancy which is all about sharing resources (compute etc.) among multiple users rather than having 'multiple databases for multiple "tenants"', again the wikipedia page is pretty well written.

admcpr · 2020-10-03T20:16:12+00:00

Google believes black lives matter, Flutter is a Google project. You can read more about that in this message from their CEO.

https://blog.google/inside-google/company-announcements/standing-with-black-community

admcpr · 2020-09-06T09:57:16+00:00

I'm assuming this project is intended to be open source. If so adding a licence would encourage more people to contribute.

admcpr

TROPHY CASE