templates VS Prisma

Railway is a platform that provides hosting solutions for full-stack web applications. It offers developers an easy way to deploy and manage their applications without worrying about infrastructure management. it also supports various programming languages, frameworks, and databases, making it suitable for a wide range of projects. it also simple to use and it also has a free tier which is has a little benefit than Render.

Platform as a Service (PaaS) is a term that captures tools built for developers to use where they don’t need devops engineers to deploy to the cloud. Heroku was the “category-defining” product here, and modern successors include Vercel, Render, Railway, Replit, platform.sh, Aptible, Northflank, and more. We have to say that there are some amazing products in this category. Developer Experience is at a premium!

Railway is a platform that allows you to easily deploy web apps and APIs. It offers a free tier of $5 worth of free usage per month when you sign up.

So this is what I did 1. Connected to the POSTGRES database on railway.app. 2. Ran first migration command for Django (after initiating project) 3. Removed the Entire DataBase on Railway (to see how Django responds) 4. Created a New Database again on the railway.app 5. Updated the variables for new DB credentials in Django 6. After Running the DEVELOPMENT server, I Found the Session Table Missing Error 7. Tried MAKE MIGRATIONS command, result (No changes detected)

Railway is a serverless platform that makes it easy to deploy and manage applications and databases. It offers a variety of features, including automatic scaling, high availability, and support for a variety of programming languages and frameworks.

The Server and Postgres Database are hosted on https://railway.app, with the client on Netlify.com’s free tier.

Hosted on railway.app

Python, Flask: Railway.app deployment and Railway's Nixpacks Docker image build tool. -- I've successfully deployed my Australian postcodes API project to https://railway.app. I did have some problem during deployment. I'm describing how I've addressed this problem. In the process, we're also covering the following: ⓵ running Railway's own Nixpacks Docker build tool locally on Ubuntu 22.10. ⓶ Override the Nixpacks-built Docker image's CMD: we look at three (3) ways to run the Flask CLI command venv/bin/flask update-postcode, and similarly, we look at how to override the start command gunicorn wsgi:app --preload specified in the Nixpacks required Procfile.

A website that allows students to find the easiest exams at my university. This was pretty easy to build in HTML/CSS once I had gathered the data (basically just web-scraping and understanding the University API). Relevant python modules were requests, pandas and flask. I then hosted the website so I can actually show it to people (railway.app was my host of choice).

- Railway.app did the best job on DX, I can deploy my services to railway.app in minutes without having to do any Google search. But it has longer API response time because at the moment it only support US region if I'm correct

generator client { provider = "prisma-client-js" binaryTargets = ["native", "rhel-openssl-1.0.x"] } datasource db { provider = "postgresql" // NOTE: When using mysql or sqlserver, uncomment the @db.Text annotations in model Account below // Further reading: // https://next-auth.js.org/adapters/prisma#create-the-prisma-schema // https://www.prisma.io/docs/reference/api-reference/prisma-schema-reference#string url = env("DATABASE_URL") } model Post { id Int @id @default(autoincrement()) name String createdAt DateTime @default(now()) updatedAt DateTime @updatedAt createdBy User @relation(fields: [createdById], references: [id]) createdById String @@index([name]) } // ... rest of the schema

Unfortunately Prisma hasn’t supported polymorphism yet. As such, you can't use inheritance to model the entity in the same way as in your programming language, as depicted in the above class diagram. The good news is that we could intimate it using table inheritance to imitate it.

Prisma is a modern TypeScript-first ORM that allows you to manage database schemas easily, make queries and mutations with great flexibility, and ensure excellent type safety.

Prisma

There have been multiple feature requests to add native support for AsyncLocalStorage to Prisma, but they haven't been met with much enthusiasm from the maintainers. Some people solved it by extending and overriding the client (which is arguably prone to breaking with updates).

Our products microservice is also straight forward just like how the auth has been. As previously plotted, we will be using different technologies on each service and we are using PostgreSQL as a database and prisma orm(Object Relational Mapper) for querying our DB. ORMs are used to translate between the data representations used by databases and those used in object-oriented programming, and in this service, we will be using one of the most common ones in the nodejs ecosystem, Prisma. It is the only fully type-safe ORM in the TypeScript ecosystem. The generated Prisma Client ensures typed query results even for partial queries and relations.

Prisma: An ORM for seamless database interactions.

Web Sockets / Real Time built in. Again, 409 up votes on Github, and they offer 3rd party support. Version 1 had this. Edge Functions DO support web sockets. Let's get this done!

Even now, fewer full-stack developers are willing to directly talk with databases through the complexities of SQL queries and database schema management, let alone the ones that come from the front-end world. Therefore ORM has already been the standard kit for the existing framework. For instance, all three frameworks mentioned above have adopted Prisma ORM.