Sometimes you need to use a view in your database schema. Here is how we chose to manage views with Prisma.
Tag: DevOps
DevOps is a set of practices that combines software development (Dev) and IT operations (Ops). It aims to shorten the systems development life cycle and provide continuous delivery with high software quality. DevOps is complementary with Agile software development; several DevOps aspects came from Agile methodology.
Articles
-
MySQL, Prisma, and Views -
Prisma, MySQL, and max_prepared_stmt_count Over the course of a year, we have been fighting with MySQL and Prisma regarding an error referencing max_prepared_stmt_count. This is how we resolved it.
-
ViTest and TypeScript Paths How to set up TypeScript paths in a ViTest project.
-
GitHub Actions Reusable Workflows This is how I created a reusable GitHub Action workflow that can be shared and reused within a repository.
-
Changing the Origin of your Branch Today I learned that you can change the origin of your branch in Git.
-
Redis Stream Activity Feed I created a new Concept Project utilizing Redis Streams to create an Activity Feed
-
GitHub Action - Passing a Slack Message ID between Jobs How to pass a Slack Message ID (or any primitive value) between multiple GitHub Action Jobs.
-
Docker Run Internal Container Command How to run a command in a Docker container that is not the main running command of the container.
-
Get a Bash Scripts Absolute Path How to find a bash script absolute path without the use of realpath.
-
Image Generator Module an Exploration on using JavaScript and its Canvas to generate a dataurl image.
-
From REST to GraphQL - How To Build a GraphQL Server Exploring the Development of Refactoring a RESTful api to GraphQL
-
How to get GitLab Runner to push a Git Tag Some thoughts on getting a Gitlab Runner to deploy tags back to a remote.
-
How to configure Nginx to load balance between multiple Docker containers A brief exploration of using Nginx as a load balancer for multiple docker containers.
-
Next Version I created a Node.js based Command Line Interface tool for creating and updating a Node Projects Version.
-
How to make GIT ignore future changes to a committed file. A quick command to tell Git to ignore future changes to a tracked file.
-
Script to Close a Port on MacOS A very handy Bash alias for web developers to close an open port on macOS.
-
Ping Redis without CURL or NC I found this little snippet on Stack Overflow which allowed me to check the Redis connection from inside my container.
-
High Availability Redis Session with Express Recently we have needed update our session solution with Redis to use Redis as a cluster, increasing the availability of our sites in the event that we have to cycle our Redis servers.
-
How to make macOS remember my ssh password You can follow these steps to mimic the older functionality of macOS remembering your password between sessions and restarts.
-
Helpful Docker Scripts I am doing a lot of docker experiments today and needed a few scripts for cleaning up.
-
Giving a Presentation with Git Commits recently I have been creating and giving presentations on how to use certaintechnologies. Event expanding some to be more like workshops.I decided that rather than writing all my code on the fly while giving thepresentation, which would undoubtedly lead to a number of errors as I go, that Iwould pre-write all the code and stores changes as git commits.This leads me this post. How to navigate those commits quickly and easilyduring my presentation.My solution was to create three bash al
-
What's my IP Address I have recently been giving a new 15inch MacBook Pro by the office, and havespent a fair bit of time moving things over from a MacMini to it to be my newprimary console. Although there are several tools available to transition fromone mac to another, I have decided to do this as a fresh/clean install as themini has been around for 4 years. It's also allowed me to mark down everythingfor a new on-boarding process I am starting.One of the main issues in switching from a desktop unit to a la
-
Human Readable Code I have recently spent a great deal of time reviewing code from externaldevelopers. Some of it is good, some of it is rough, some of it makes my headhurt. Ultimately, if the code produces the expected result, I tend to let thingsslide to be included as part of a later refactor if needed, but this leads me tomy topic of the day; Human Readable Code.No longer do we live in an age where we need to consider how a computer is goingto process a block code, and as such, code for the compiler in t
-
Cherry-Pick with Git Sometimes things don't quite work out as planned. Okies, lets be honest, Most ofthe time things don't work out as planned from the start. But with a properworkflow, this is not always detrimental.For one of my office projects, I had a transition over to DoubleClick forPublishers (DFP). This was completed, and entered into a merge release for thestart of the month along with a few other patches and small features. However,that transition was to be pulled from the upcoming release for inter
-
Some Thoughts on Setting Up a Workflow A key component to DevOps is setting up and maintaining a workflow fordevelopers. It's not all about automation and statistics. Having a developmentbackground comes in nice and handy, but system operations is valuable too. Ifyou don't have that experience behind you, find an experienced developer and/orsystems administrator to work with on your workflow.Step 1 - Analyze What You're Already Doing.Lets start by taking some time to analyze your current process. Unless you are aone man shop
-
As a general rule when programming... As a General Rule When Programming. If you think your code is going to cause a WTF moment a year from now re-evaluate your solution.
-
I am learning to love VI I will admit that in my early developer days, that I was extremely resistant todoing anything command line. My thought was that we lived in an age where wecould easily make GUI so why wouldn't we create and use them. Now will toolslike GIT, LESS, SASS, Grunt, Gulp, Vagrant, and Docker (just to name a few) Ihave learned to love working in the command line and cant imaging workingwithout it.That being said, the one thing about command line that has always bothered was vi (or vim). I never
-
Step by Step Install of Graphite with Carbon and StatsD on CentOS 7.1.x Recently, we started to build our own Graphite StatsD Server. We tried following a couple of step by step guides, but all them were seeming out of date. And we encountered several errors, many of which did not have defined documentation.
-
The Power of Statistics Over the past couple of weeks I have been exploring Application Monitoring toolswhich has resulting in me playing with StatsD and Graphite . I quickly found a Docker Container, and plugged in an NPM library called node-statsd into an Express RESTful api to see what kind of data I could get.At firs
-
NGINX Location Rewrite with my change over to the Ghost Blogging platform from myown custom engine, I had one major problem.The URL's from my old blog did not directly match the URL's of the new blogSpecifically, the blog path.In my custom built blog, I had entered all the blog posts to sit under the /blog/ route. Ghost does not do this, nor does it directly allow me to modifythat path without modifying Ghost itself. Because the intention of thistransition is to utilize an existing communi
-
Testing Middleware Recently I wrote a small custom piece of middleware for an express applicationto consume on its requests. It takes a query parameter and reworks it for lateruse in the event loop. Nothing too fancy or overly complicated.But as is the good practice, and because this was for a production application,I wanted to test this bit of middleware with mocha . Buthow?A brief google search did not return to me any relevant information, so that'swhat prompted this post.Writing
-
What is DevOps Several Months ago, I attended a conference in Toronto called DevOpsDays. The purpose is like any other technical conference, a means to get like minded individuals together and to share new ideas. In this case, DevOps.