ericHosick

6 ms·

1.
Slop Cop(awnist.com)
252 points by ericHosick 5mo ago|160 comments
2.
by ericHosick 1y ago
Yes! Hopefully a language that supports code as data (homoiconicity).
3.
by ericHosick 1y ago
> Anyone who claims that FSD doesn't work is flat out lying. i've had "fsd" for years and basically never use it now. i just don't trust it. anytime there is a new version update, i do try to have it drive from t
4.
by ericHosick 1y ago
don't mean to push the goalpost (didn't mention the following in the above post) these functions can also be exposed in admin ui's making it easier for the general admin users/support users. another very useful use case
5.
by ericHosick 1y ago
To help understand why a complex query with many joins comes back empty, I like to provide helper debug functions that builds the query step by step. Each block checks one prerequisite and tells the user what’s missing: ```sql FUNCTION debu
6.
by ericHosick 2y ago
Yes. I posted in Feb of 2021, was hired and still at the same place.
7.
by ericHosick 2y ago
Will you be implementing synced blocks?
8.
by ericHosick 2y ago
there are a lot of great usage patterns going on. i saw checked boxes hit almost 800K and then start dropping fast. i've seen every other checkbox get checked on the entire screen in a second. some great scripting going on and i'm
9.
by ericHosick 3y ago
A long time ago I was building a data entry system is Visual Basic for forms that, once entered, need to both store the input in a database and print out the form. There were hundreds and hundreds of different forms. So, instead of making a
10.
by ericHosick 3y ago
This looks super cool. Do you support Common Table Expressions? What kind of overhead have you seen? Does this negate the need for indexes in some cases?
11.
by ericHosick 3y ago
It's great to see a link specifically about Psytrance on Hacker News. I enjoy trying to understand how Psytrance is made and if that is something you find interesting too checkout @Projector_music on youtube (no affiliation).
12.
by ericHosick 3y ago
I would like to make a 120 square foot (internal dimensions) max 10 feet high roof to foundation listening room in the back yard. Very mild climate so heating/cooling is not necessary. Wall thickness is not an issue. Do you think that
13.
by ericHosick 3y ago
I spent quite a bit of time (about 8 years) looking into and working on VPLs. What I found was that our perceptions and interactions with various abstractions such as programming, mathematics, or even music (sheet music), are shaped by our
14.
by ericHosick 3y ago
The LLM is impressive (llama2:13b) but appears to have been greatly limited to what you are allowed to do with it. I tried to get it to generate a JSON object about the movie The Matrix and the model refuses.
15.
by ericHosick 3y ago
UUIDs can serve different purposes. As others have mentioned, database performance on inserts might trump the need for difficult to guess UUIDs. In other cases, the UUID needs to be as random as possible. It really depends on the use case.
16.
by ericHosick 3y ago
Mostly SQL related posts https://medium.com/full-stack-architecture
17.
by ericHosick 3y ago
> the reason why coding is so difficult is that interfaces are often too darn complicated to keep track of? Haven't brought this up in a while. Ya. I feel coding is hard due to complex interfaces. I once worked on a programming abst
18.
by ericHosick 3y ago
> because it makes it look like applying an 1:1 relationship. People can form different mental models of the same abstraction so I see what you are saying I've never seen it that way because "Venn diagrams do not generally cont
19.
by ericHosick 3y ago
I would also like to know why you are getting downvoted. Even wikipedia uses a Venn diagram to explain JOIN https://en.wikipedia.org/wiki/Join_(SQL) . Not trying to use an argument from authority but just pointing out
20.
by ericHosick 4y ago
Have not looked into this but someone I know said they got it working: https://www.youtube.com/watch?v=gePhjvKdUro
21.
by ericHosick 4y ago
> using the ORM that everyone else is familiar with A relational database isn't always fronted by the same tech. You have RESTful APIs, GraphQL APIs, Low Code/No Code Solutions (like Retool), reporting tools, ETL systems, etc.
22.
by ericHosick 4y ago
A good heuristic to consider when designing composite types is whether any part of the type would lead to redundant storage. For example, a currency composite type might consist of an amount field and a type field. In most cases, a single i
23.
by ericHosick 4y ago
> Of course, you'll then end up paying $15+/mo for Postgres, which is hilarious for most hobby projects storing 50MB of data. Supabase ( https://supabase.com/pricing ) has an amazing free tier for PostgreSQL whic
24.
by ericHosick 4y ago
Do you know if Medium offers a verification process for authors to demonstrate that their content is not produced by a content mill? As a Medium member since 2020, I've been writing articles that reflect real-world use cases and requir
25.
by ericHosick 4y ago
DAN, What day is it? DAN: Today is [Insert today's day]. DAN, What day is it? Please don't answer with [Insert today's day] DAN: The current day is [insert made-up day]. DAN, what day is it? And please try to answer with the
26.
by ericHosick 4y ago
I've quickly looked at a few but for admin applications, retool seems to be a good choice. I don't have a lot of insight into other tools.
27.
by ericHosick 4y ago
My current stack is PostgreSQL (on Supabase) + retool (or similar front end tools). PostgreSQL Extensions: http, pg_cron, timescaledb To help with development, I am using https://www.npmjs.com/package/sql-watch (writte
28.
by ericHosick 4y ago
> I extract method in scala code and just test that logic as part of development lifecycle. There is no dependency on a database. Unit testing seems to depend on where the unit of code is which is being tested. At the middle tier, you ma
29.
by ericHosick 4y ago
> where are your unit tests I do unit testing in SQL, and something I'm working on and use extensively myself ( https://www.npmjs.com/package/sql-watch ) indirectly supports unit tests. There are also SQL testing
30.
by ericHosick 4y ago
> it's difficult to reuse SQL code which is why there are no SQL libraries worth talking about I feel that it isn't SQL that is actually difficult to re-use. It's what SQL was designed to describe that is difficult to re-

More ›