Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
yasserf
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
13 ms
·
61.
▲
by
yasserf
5y ago
I’m facing an issue where I store small binary data blobs within a Postgres column in order to benefit from delete cascades. I’m considering moving the binary data into S3 and then doing the sync layer on the server (which means the front e
62.
▲
by
yasserf
5y ago
I agree with your point that adding multiple layers = more attack vectors and abstraction of a really good domain specific language. But what seems to happen on most of the projects I work on is we end up hiding away extremely common logic
63.
▲
by
yasserf
5y ago
Note: Posted again here ( https://news.ycombinator.com/item?id=28327008 ) since the repo was private
64.
▲
by
yasserf
5y ago
hey HN! This is a simple typescript wrapper around the npm pg-node library which provides autocomplete and validation for basic crud queries out of the box, without having to use an ORM. I do alot of refactoring on my projects and I find cr
65.
▲
Show HN: Node Typescript Postgres Query Builder
(github.com)
2 points
by
yasserf
5y ago
|
1 comments
66.
▲
by
yasserf
5y ago
hey HN! This is a simple typescript wrapper around the npm pg-node library which provides autocomplete and validation for basic crud queries out of the box, without having to use an ORM. I do alot of refactoring on my projects and I find cr
67.
▲
Show HN: Typed Postgres CRUD Queries
(github.com)
29 points
by
yasserf
5y ago
|
3 comments
68.
▲
by
yasserf
5y ago
SEEKING WORK | UK | Remote Only I'm a full stack developer with 12 years of experience, focused mainly on NodeJS and Javascript. Previous experience includes working for a few banks/hedges fund, freelance with a few startups, and
69.
▲
React and VanillaJS State Models
(vramework.io)
1 points
by
yasserf
5y ago
|
0 comments
70.
▲
Vramework.io: A mini framework for running functions via express and lambda
(vramework.io)
2 points
by
yasserf
5y ago
|
0 comments
71.
▲
Show HN: Vramework.io (RC): Functions as a Design
(vramework.io)
2 points
by
yasserf
5y ago
|
0 comments
72.
▲
Packagecloud.io says payment required for Git-lfs
(github.com)
1 points
by
yasserf
5y ago
|
0 comments
73.
▲
by
yasserf
5y ago
this seems likely, thanks for the link!
74.
▲
Ask HN: Hacked Ionos Email Account
1 points
by
yasserf
5y ago
|
3 comments
75.
▲
by
yasserf
5y ago
No idea! Hopefully someone else might know, first time I heard about alot of these typescript tooling libraries today.
76.
▲
by
yasserf
5y ago
This is awesome! the json types part is perfect. If I found your fork earlier I would have just used that as its what I need for jsonb. The dates solution I fixed in a rest API wrapper on the client side. It's not great but it hides aw
77.
▲
by
yasserf
5y ago
@jbaudanza sorry my response actually didn't reflect your suggestion at all! Yeah I would love that sort of tool! I think theres some magic you can do with the es6 templating parsing, but that would be a bit complex to do as a supporti
78.
▲
by
yasserf
5y ago
Honestly I don't know what the tradeoffs are . I usually rely on the db to create the id (regardless if its SERIAL / UUID). The only time I get create a UUID outside is if the client needs a UUID in its initial state. For example
79.
▲
by
yasserf
5y ago
I am looking to release the setup I use for deployment but tbh it isn't tested (via tests, since I rely on typescript for most of my data shuttling) and there's alot to it so need to write alot of documentation which i don't
80.
▲
by
yasserf
5y ago
I think the comment I made above in in regards to our db crud updates might help answer that! But short answer is we just use node-postgres. If the get/update/delete/insert is a simple fields/table/where we use a he
81.
▲
by
yasserf
5y ago
Yeah the good thing about using such a low level tool is that everything remains typed until you reach the query statement. Postgres and typescript enums work great together. For one of my projects I check in the generated types and replace
82.
▲
by
yasserf
5y ago
The form building part I don't no, I built it for a client that has a few dozen forms with hundreds of fields / options which is hard to keep up with. So we settled on using a csv file that is essentially a products owner way of s
83.
▲
by
yasserf
5y ago
It looks like Kanel is actually alot more feature rich, I wouldn't see any advantage of switching. I started using schemats because it's a single CLI interface and gives me all I need. I put together a few tools for a typescript h
84.
▲
by
yasserf
5y ago
Thanks Peter!
85.
▲
by
yasserf
5y ago
Yup! I actually use that in my own node-postgres api. So the code itself with typescript is here: https://github.com/vramework/vramework/blob/main/backend-com... But the general gist is we have generic c
86.
▲
by
yasserf
5y ago
Thats good to know. As long as their database in docker is being incrementally updated (using the same migration scripts as on production which only apply new ones) is this hit only when spinning up a clean docker image? I'm consideri
87.
▲
by
yasserf
5y ago
That's an interesting approach. I usually run a postgres db (as a docker image on circleCI) when I'm running the build. I'm not sure how scalable it is (currently we have a hundred migrations and it's a few seconds so no
88.
▲
by
yasserf
5y ago
Thats very cool! I'm also massively in favour of having the db as the source of truth. When I first started looking into building my own SaaS I actually tried to go down the database first design, where most of your functionality runs
89.
▲
by
yasserf
5y ago
So far I have addressed the issues related to using it with node 14, package dependency issues and getting it inline with modern typescript (removing concept of namespaces and favouring Pick/Omit helpers instead). That being said given
90.
▲
Postgres to TypeScript Interfaces and Enums
(github.com)
105 points
by
yasserf
5y ago
|
64 comments
More ›