• 0 Posts
  • 37 Comments
Joined 1 year ago
cake
Cake day: August 16th, 2023

help-circle



  • 40 have been on the site longer than 2 weeks. I can only filter for less than two weeks, not greater than, so I won’t bother with that, but here’s a summary of the first 5 that have a garage, aren’t pending, and are less than $300k:

    • “This house needs work and is priced accordingly”

    • “This is a 55 and older only community.”

    • A trailer with a detached garage for $250k. That’s just insulting.

    • A nice condo for $299,900, right where I said most houses would be.

    • A kind of ugly place for $230k. The description says it only needs cosmetic improvements, so this might actually be a good one to buy.

    So hey, in the first 5 there’s one house that seems reasonable. Maybe there are a few more if I go through the rest. Still, for a city of 200k people, being able to count the reasonably priced houses on your fingers is not very good.














  • Postgres normalizes table and field names to lowercase, unless you put them in quotes. It’s also case sensitive.

    That means if you use quotes and capital letters when creating the table, then it’s impossible to refer to that table without using quotes.

    It also means if you rename the table later to be all lowercase, then all your existing code will break.

    Still a much better database than MySQL though.