Friday, July 19, 2024

Moving from ids to slugs

Slugs are nicer to look at and easier to quickly understand so we're transitioning to them!

Should have planned them in from the beginning!

Thursday, July 18, 2024

Queries list

 I added a link to saved queries next to links for new queries and schemas.

Wednesday, July 17, 2024

How to be steady on vacation mode and dog fooding

 I'm going to try to do at least one little thing every day while on vacation mode and then report here.

Today I made it more convenient to make a new query from the schema by changing the default query when you click on a field from 

SELECT [field] from [table] limit 1;

to 

SELECT * from [table] where [field]=? limit 10;

Then from there you can replace the question mark.

It's much more common that I care about a column name because I want to use it as a filter than that I care about it because I want to look at only that column.  In fact, the latter pretty much never happens!

So that's the good thing about dog fooding and then coding.

Tuesday, July 16, 2024

I'm back

 I missed Saturday and Monday but I'm back.

So then here are the main things:

  1. Try to improve things every day.
  2. If for some reason you miss a day, get back on the wagon and start up again!

Friday, July 12, 2024

On the road

 I got a little bit done on the plane today without wifi, slightly improving the pricing page and the flow there and investing a bit into automating changes to the site.

But yeah, most of my time was spent first working for Loanpass, then traveling across the country, and now at a family reunion.

Thursday, July 11, 2024

Astro and registration

Today I switched the pgscope website over to Astro.

Before today I just used html and css, but once you have multiple pages that share html or styling, which you need to do if you want consistency, some kind of automation becomes the way to go. I haven't really tried Astro before but it's reasonably intuitive and I got the site refactored into Astro!

I also got registration working, so you can now make an account without asking me for permission!

More basics: pricing, faq, and registration page

 Yesterday somehow I didn't include making a blog post in the checklist.

But to report, I added new pages to the site for pricing and FAQs.  And those encouraged me to add a new registration page to the app.

Now I need to make the registration page work!

Moving from ids to slugs

Slugs are nicer to look at and easier to quickly understand so we're transitioning to them! Should have planned them in from the beginni...