postgres-typed
awayto
postgres-typed | awayto | |
---|---|---|
5 | 25 | |
26 | 19 | |
- | - | |
0.0 | 0.0 | |
over 1 year ago | over 1 year ago | |
TypeScript | TypeScript | |
MIT License | MIT License |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
postgres-typed
-
Kysely: TypeScript SQL Query Builder
This is really cool, will look into using it in future projects!
I also made a tool (https://github.com/vramework/schemats) that generates the types directly from the db, which means whenever you do a DB migration your database types automatically update. Was forked from the original schemats library a couple years ago.
I also created a lightweight library ontop of pg that is less of a query builder and more of a typed CRUD + SQL for non trivial queries (https://github.com/vramework/postgres-typed). Most queries I deal with in a day to day is usually crud so I find it a little easier, but it's much less powerful then Kysely! I fall more into the camp of writing complex queries in SQL with small helpers and writing simple ones with util functions and typescript
-
Ask HN: Who Wants to Collaborate?
I'm working on a few projects, from one/two days to platforms.
The first is OS and is a simple nodeJS environment to deploy applications via lambda and express quickly. Sort of like nestJS except less decorators and more functional (https://vramework.io/). I already know of a few other colleagues that rolled their own propriety versions of this to support enterprise and cloud deployments so decided to OS it.
The other OS project is a strongly typed postgres/mysql driver. The idea is to generate typescript definitions directly from postgres (https://github.com/vramework/schemats) and then have a think layer ontop of pg-node that gives you strongly typed queries (https://github.com/vramework/postgres-typed).
An open-source project I spent a few years on the core team is https://deepstream.io/, a realtime-server that allows you to mix and match multiple streaming protocols (mqtt/websocket/others) and allow those clients to talk to each other using pub-sub and records. I'm not longer working for it but wanted to give it a shout out!
On a non OS project, I have been working on an immersive audio platform for a while now. The main goal is to allow users to pick and choose how audio books progress, and also have a live session mode which allows users to record their pulse / answer questions and a few other metrics and associate it with sentences. I pretty much built and deployed all of it but require some advice/brainstorming on how to proceed now. I built it to satisfy an itch when I was practicing shamanism during the first lockdown when I was in-between contracts / taking time off.
I also want to build a simple web-pages strategy game based around eco-education, but don't have the bandwidth . If anyone is interested in mixing together gamification and eco-village building might be a fun conversion to bounce ideas!
All the OS projects above were used to support my personal/a couple professional projects over the last few years.
Email in profile
-
Write an SQL query builder in 150 lines of Python
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 behind helper functions. It always starts off with SQL and then slowly gets moved into higher level functions that offer a better developer experience.
Shameless plug, but I just posted a library I wrote (for node https://github.com/vramework/postgres-typed/blob/master/READ...) which pretty much is a tiny layer ontop of pg-node (which is query based / with value parameters) and provides small util functions with typescript support derived straight from postgres tables.
In an ideal world (one I think we are getting very close to) I think we will end up having SQL queries validated in our code against the actual DB structure the same way we have any other compilation error. But until then we'll need to rely on tests or helper libraries, and for the purpose of refactoring and development I find the latter more enjoyable (although still far from perfect).
- Show HN: Node Typed Postgres Query Builder
- Show HN: Typed Postgres CRUD Queries
awayto
-
Show HN: Awayto v2 short demo; an actual all-in-one framework
Hey folks, just putting this up as a demo link for people to try out. It's a project I've been working on since January and in light of recent framework posts lately I figured I'd start talking about my own.
The link is a demo site of Awayto v2 [1] (ignore the front page info that's all from version 1). Awayto [0] started out as a quick deploy app which grew to exist via AWS. I felt the need to make something that wasn't so closely tied to cloud infra, and Awayto v2 is that. Currently deployed on hetzner vms, using Tailscale for networking, there is a great deal of things going on. There is a local installation path planned, as long as you provide your own servers, etc, as it all just works on Tailscale anyway. I'm still working on docs, but the goal is to spit out _everything_ a dev might want to control in their stack. My current version of deploying to hetzner sets up 7 servers (2 ns, exit, build, app, db, svc). Git profile [2] for more info, tech stack info.
This is just a short demo and will only be up a limited time. There's no email validation or anything, gibberish is welcome. You are not being tracked. I know I need how-to docs, video assists, and all that. Slow and steady. It's being hosted from a single warehouse in the Pacific Northwest, be kind. Caching is in play and not perfectly tuned so maybe wait a few minutes if something doesn't automatically show up. Any feedback is awesome. Cheers!
[0] https://github.com/keybittech/awayto
-
Functional Web App (FWA)
This is really cool to see in this format. Over the last few years I have spent my free time crafting a framework under similar ideologies. I think a lot of web devs end up making similar tools throughout their career, but perhaps never get to the point of sharing what they make. I finally formalized my framework last year and am well into battle testing it with clients and different projects. https://awayto.dev
In a similar light to what this FWA group is presenting, I also have put forth some points about why this style of web dev architecture is important and effective. https://awayto.blog/posts/webapps/
Actually, I started out reading Million Dollar Consulting last year and one of the first chapters essentially talks about the importance of having a portfolio of work, and being able to capitalize off that body of knowledge within to grow more as a consultant. Well, I took that as a sign to formalize a framework that would allow me to do my development work in a much more effective manner, as well as provide more out of the box functionality for my clients.
Overall, the experience has been really positive. Obviously I don't get to use my own framework with every client, and that's a good thing. But, when working with clients who need basic business problems solved, having an FWA style framework is going to allow you to iterate so much faster than traditional MVC platforms. At least this has been my experience. Specifically to that point, with templated and loosely coupled parts, you don't have to spend too long building your web app to get it to do something exceptional.
-
Ask HN: Who wants to be hired? (March 2022)
Location: Pacific Northwest
Remote: Yes
Willing to relocate: For Contract or Consulting Only
Technologies: Java, C#, Javascript, Typescript, HTML, CSS, React, Redux, Material UI, NodeJS, Webpack, Postgres, Cognito, Lambda, CloudFormation, CloudFront, S3, API Gateway, HITRUST, FERPA
Résumé/CV: https://www.linkedin.com/in/joe-mccormick-76224429/
Email: [email protected]
My name is Joe. If you are looking for a consulting- or contract-based resource, I am interested and open to take on projects of many varieties. Over the last 10 years, my professional experience has touched on Education, Professional Consulting, IT Management, E-Commerce, and I hold my MA in English teaching. I have helmed numerous, extremely successful software development teams within the companies I have worked at, on projects of large complexity, some with millions of users and in revenue.
Check out https://awayto.dev which is a free open source web application platform. It uses React, Redux, Material UI, NodeJS, Typescript, Webpack, Postgres, Cognito, Lambda, CloudFormation, CloudFront, S3, API Gateway, as well as my own custom scripts. Awayto makes it fast to deploy low-cost web applications and then have a skilled developer come in and build up your application.
Thank you for your time.
-
Ask HN: Freelancer? Seeking freelancer? (February 2022)
SEEKING WORK - Pacific Northwest - Contract/Consulting Remote/Onsite
If you are looking for a consulting- or contract-based resource, I am interested and open to take on projects of many varieties. Over the last 10 years, my professional experience has touched on Education, Professional Consulting, IT Management, E-Commerce, and I hold my MA in English teaching. I have led multiple successful development teams within the companies I have worked at, on projects of large complexity, some with millions of users and in revenue.
For my most recent completed work, I created https://awayto.dev, a free open source web application generation platform. It uses React, Redux, Material UI, NodeJS, Typescript, Webpack, Postgres, AWS Cognito, Lambda, CloudFormation, CloudFront, S3, API Gateway, as well as my own custom scripts. Awayto makes it fast to deploy low-cost web applications and then have a skilled developer come in and build up your application. https://github.com/keybittech/awayto
Thank you for your time.
Javascript, Typescript, Java, C#, HTML, CSS, HITRUST, FERPA
Inquiries: [email protected] Website: https://awayto.dev LinkedIn: https://www.linkedin.com/in/joe-mccormick-76224429/
-
Ask HN: Who wants to be hired? (February 2022)
Willing to relocate: For Contract or Consulting Only
Technologies: Java, C#, Javascript, Typescript, HTML, CSS, React, Redux, Material UI, NodeJS, Webpack, Postgres, Cognito, Lambda, CloudFormation, CloudFront, S3, API Gateway, HITRUST, FERPA
Résumé/CV: https://www.linkedin.com/in/joe-mccormick-76224429/
Email: [email protected]
If you are looking for a consulting- or contract-based resource, I am interested and open to take on projects of many varieties. Over the last 10 years, my professional experience has touched on Education, Professional Consulting, IT Management, E-Commerce, and I hold my MA in English teaching. I have led multiple successful development teams within the companies I have worked at, on projects of large complexity, some with millions of users and in revenue.
For my most recent completed work, I created https://awayto.dev, a free open source web application generation platform. It uses React, Redux, Material UI, NodeJS, Typescript, Webpack, Postgres, AWS Cognito, Lambda, CloudFormation, CloudFront, S3, API Gateway, as well as my own custom scripts. Awayto makes it fast to deploy low-cost web applications and then have a skilled developer come in and build up your application. https://github.com/keybittech/awayto
Thank you for your time.
-
Ask HN: Who Wants to Collaborate?
I made a web application generation tool built on top of AWS. It deploys all the basics you need for a web application in the modern era (db, ui, api, users, groups, roles).
https://awayto.dev -- Check out the video
https://github.com/keybittech/awayto
If you like making tools for developers, contractors, and the business world. Come check us out and join the discord!
Hey there, I work on a project called Awayto. It generates and deploys web applications to AWS with all the base line bells and whistles (db, api, ui, user mgmt, react, typescript). I enjoy working on tools for developers and this is a project that's supposed to help developer consultants. It's a full stack framework, and there are of course many ways you could help or be involved, so if it sounds interesting please check it out!
https://github.com/keybittech/awayto
https://awayto.dev
-
You Don't Need the Cloud
A lot of the comments here are about difficulty cloud tech navigation/adoption. I create a framework built on top of AWS to try to alleviate a great deal of the infra management aspects of running web applications. It sets you up with all the basics out of the box in about 10 minutes (db, api, ui, users, groups, roles).
https://awayto.dev
https://github.com/keybittech/awayto
Along the same vein as other posts in this thread, startups and contractors need instantaneous test bed environments that support a lot out of the gate, and which can be the basis to scale from. I've been a contractor off and on for a few years and have seen this need first hand. So my tool is meant to fill in the foundations of great ideas, so those ideas can grow faster. I think that's an essential trait of cloud services that you will be hard-pressed to find elsewhere.
-
Ask HN: Freelancer? Seeking freelancer? (January 2022)
SEEKING WORK - Pacific Northwest - Contract/Consulting Remote/Onsite
If you are looking for a consulting- or contract-based resource, I am interested and open to take on projects of many varieties. Over the last 10 years, my professional experience has touched on Education, Professional Consulting, IT Management, E-Commerce, and I hold my MA in English teaching. I have led multiple successful development teams within the companies I have worked at, on projects of large complexity, some with millions of users and in revenue.
As a side project, I created https://awayto.dev, a free open source web application generation platform. It uses React, Redux, Material UI, NodeJS, Typescript, Webpack, Postgres, AWS Cognito, Lambda, CloudFormation, CloudFront, S3, API Gateway, as well as my own custom scripts. Awayto makes it fast to deploy low-cost web applications and then have a skilled developer come in and build up your application.
Thank you for your time.
Java, C#, Javascript, Typescript, HTML, CSS, PHP, Ruby, Python, HITRUST, FERPA
Inquiries: [email protected]
-
Ask HN: Who wants to be hired? (January 2022)
Remote: Yes
Willing to relocate: For Contract or Consulting Only
Technologies: Java, C#, Javascript, Typescript, HTML, CSS, React, Redux, Material UI, NodeJS, Webpack, Postgres, Cognito, Lambda, CloudFormation, CloudFront, S3, API Gateway, HITRUST, FERPA
Résumé/CV: https://www.linkedin.com/in/joe-mccormick-76224429/
Email: [email protected]
If you are looking for a consulting- or contract-based resource, I am interested and open to take on projects of many varieties. Over the last 10 years, my professional experience has touched on Education, Professional Consulting, IT Management, E-Commerce, and I hold my MA in English teaching. I have led multiple successful development teams within the companies I have worked at, on projects of large complexity, some with millions of users and in revenue.
As a side project, I created https://awayto.dev, a free open source web application generation platform. It uses React, Redux, Material UI, NodeJS, Typescript, Webpack, Postgres, AWS Cognito, Lambda, CloudFormation, CloudFront, S3, API Gateway, as well as my own custom scripts. Awayto makes it fast to deploy low-cost web applications and then have a skilled developer come in and build up your application.
Thank you for your time.
What are some alternatives?
PyPika - PyPika is a python SQL query builder that exposes the full richness of the SQL language using a syntax that reflects the resulting query. PyPika excels at all sorts of SQL queries but is especially useful for data analysis.
spicedb - Open Source, Google Zanzibar-inspired permissions database to enable fine-grained access control for customer applications
sql-athame - Python tool for slicing and dicing SQL
nextjs-tailwind-ionic-capacitor-starter - A starting point for building an iOS, Android, and Progressive Web App with Tailwind CSS, React w/ Next.js, Ionic Framework, and Capacitor
sql-assassin - Unfancy node.js SQL builder for ES6
php - 🐘 PHP Runtime for ▲ Vercel Serverless Functions (support 7.4-8.3)
Typesense - Open Source alternative to Algolia + Pinecone and an Easier-to-Use alternative to ElasticSearch ⚡ 🔍 ✨ Fast, typo tolerant, in-memory fuzzy Search Engine for building delightful search experiences
futurecoder - 100% free and interactive Python course for beginners
vox - Vox language compiler. AOT / JIT / Linker. Zero dependencies
quickjs-emscripten - Safely execute untrusted Javascript in your Javascript, and execute synchronous code that uses async functions
deepstream.io - deepstream.io server
Personal-Site-Gourav.io - My personal site & blog made with NextJS, Typescript, Tailwind CSS, MDX, Notion as CMS. Deployed on Vercel : https://gourav.io