Transforming my micro VM in a shared host

2024-11-07 Nerd Software Sergio

I’m lending my small AWS VM as a host to a site from family (father & uncle are trying something).

It’s so odd the clash of expectations between a previous generation (where is the FTP? SSH?) and me. I wonder if I feel the same clash with the newer generation just getting out of universities now and their everything AI way of doing things.

Fountain Pens and Inks

I think I never mentioned here how much I like fountains pens and by consequence, it’s inks. It started as a curiosity, became a hobby and collection until it spiraled down into an unhealthy obsession. For some time it became really an obsession and for now let’s say it’s it’s back on track.

More than one hundred pens later and a great deal of inks, now it’s managed interest. I still buy a pen from time to time when I find something interesting: One of my latest pens is a chinese Jinhao made of wood. Cheap and simple pen, but beatiful. And it writes well for a cheap pen.

Continue reading

Search Eloquent Macro

2018-10-22 Nerd Software Sergio

Based on an interesting macro that @FreekMurze published on Twitter and later on his blog, I extended it first by multiplying the number of LIKE’s by the number of whole words in the search string and later on going back to the original logic, only substituting spaces in the search string for “%” instead.

That new version permits to search for “AAH BEE” and find “AAH ANYTHING BEE” but respecting order (it will not find “BEE AAH”), which appears to me to be a nicer implementation.

As someone on twitter already said, beware, this is a index-killer SQL condition: Its full of LIKE “%something%something%”, which is un-indexable.

But if you want to provide a handy search function to your end users, this macro is really handy and users love the functionality. It’s not a full text search, but will do the trick without any complex infra.

Continue reading

Latest Amazon Linux AMI

2018-08-24 Nerd Software Sergio

Again, found on the internet (but with some old code that was not getting the latest images), so again as the case of the latest CentOs ami post, as public memory

Assuming:

  • You want an HVM, EBS backed, x86_64 image of the latest version of Amazon Linux
  • You have configured the desired region and credentials for the AWS SDK
  • Owned by Amazon, of course.
Continue reading

Latest Centos 7 AMI

2018-07-27 Nerd Software Sergio

That’s around the internet but I keep searching for it every time, so here it is as a public memory:

Assuming:

  • You want an HVM, EBS backed, x86_64 image of the latest version of CentOS 7
  • You have configured the desired region and credentials for the AWS SDK
  • The Owner ID for the official CentOS organisation remains 679593333241
Continue reading
Older posts