DEV Community: Alexander6

The purpose of Edge functions?

Alexander6 — Mon, 12 Aug 2024 13:24:34 +0000

Holy shit, I can't obersever table changes using supabase's edge functions. It means I have to launch a service by myself, so what is the purpose of edge functions? #supabase

Create an App with EXPO (1)

Alexander6 — Thu, 13 Jun 2024 23:43:42 +0000

Hi，guys，after finishing my fullstack project with Nest.j/Typeorm/Mysql/Aws/Vue3, I am going to start a new application with React Native. what is this app for? I don't know for now. the first function that comes to my mind is that it should support chatting and posting.

So let't start it.

As my past experience, we'd better do anything from zero unless for a studying purpose. After searching for many starter template, I decided to use this starter bio.

As for the node package manager,I very recommend using pnpm instead of npm or yarn.for the reason, you can just google it.but pay attention here, sometimes the project maybe failed when running 'pnpm install' or 'pnpm dev'. in that times you should fix errors accourding to console outputs, and you have to change back to npm to resolve that problem. it's confusing but work.

And there are also many unexpected problems when using biotemplate like obytes, because it has combined so many libs, so you may have to deal with dependencies installing error.

Here is one error I met when running pnpm ios, it will exec pod install ,and the MMKV used by react-native-mmkv blocked my way.

error: 11397 bytes of body are still expected fetch-pack: unexpected disconnect while reading sideband packet fatal: early EOF this error is often when installing a javascript dependency whose link is in this pattern: "https://github.com/xxxx/dependency.git".

ChatGPT told me that I can change the protocol from https to git.But this MMKV lib is called by react-native-mmkv, I can't just change it's link. Here is the solution

first ,change the global git config by running this command

git config --global url."git@github.com:".insteadOf "https://github.com/"
check the command runs successfully,and the URL rewrite rule has been added correctly:

git config --global --get-regexp url
you will see an output similar to this

url.git@github.com:.insteadof https://github.com/

After doing this, I tried `pnpm ios`, wating for the installation

Fine， I stuck here for 1 hour

it looks like a problem of my network, after changing a WIFI, the installation finished and successfully run in iOS simulator.

Now, we have some basic features

Login Page
post list & tabs
issue post

we can modify the interface and add new tabs according our specific needs.

I will summarize main features about the application.

Rename all files and directories in the current folder

Alexander6 — Mon, 20 May 2024 01:24:09 +0000

This command is created by ChatGPT, it will recursively go through all files and directories in the current directory, change every "Dicexxxx" into "Ringxxxxx"

#!/bin/bash

# Recursive function to handle files and directories
rename_files_and_directories() {
  local dir=$1
  cd "$dir"

  # First handle files
  for file in *; do
    if [[ -f $file && $file == *Dice* ]]; then
      mv "$file" "${file//Dice/Ring}"
    fi
  done

  # Then handle subdirectories
  for subdir in *; do
    if [[ -d $subdir && $subdir == *Dice* ]]; then
      mv "$subdir" "${subdir//Dice/Ring}"
      subdir="${subdir//Dice/Ring}"
    fi
    if [[ -d $subdir ]]; then
      rename_files_and_directories "$subdir"
    fi
  done
  cd ..
}

# Call the recursive function starting from the current directory
rename_files_and_directories "$(pwd)"

A confusing problem of the Mysql timestamp

Alexander6 — Wed, 15 Nov 2023 01:29:10 +0000

Background

when I synced data using Navicat from local to RDS, I found the SQL query results with order by create_time DESC was incorrect.
I guessed that may be relative to the SQL client's time_zone setup, cause I have met such a problem before when I work as a Frontend Engineer.
So I decided to dig into this issue and get the proper resolution.

Firstly

, look at the time_zone setup of your Mysql client using this command

show variables like '%time_zone%'.

result of my local Mysql client

result of RDS

The time_zone setup is absolutely different!. Let's make a query by SELECT create_time FROM order_deposits WHERE id=37;

result of local

result of RDS

The result of this query is absolutely the same.

Problems while setting up Nginx on AWS EC2

Alexander6 — Wed, 18 Oct 2023 02:05:28 +0000

`Error: listen EACCES: permission denied 0.0.0.0:81`

error img:
after a search, I found the reason is that, "EC2 doesn't allow users to run a process that listens on low ports (below 1024) without root privileges."

Nginx's user must be the one that you login via SSH, normally it would be `ec2-user`

(help)Deploy Nest.js Application to Vercel

Alexander6 — Sat, 30 Sep 2023 11:27:23 +0000

Such a puzzle trip.
If you are also trapped in the issue that deploying Nest.js App to Vercel, you can just refer to this Video
I have searched and tried many other articles for a whole day, and all of them didn't help a little, and I also looked through Vercel's documents 2-3 times, I am still in the puzzle now.
Even if I successfully deployed it, I also don't know what this configuration means
is anyone know how can I get a deep understanding of how Vercel works?

why putting main.ts file here, does it mean that in the production, it directly executes the ts file instead of running the compiled main.js?
- if the answer is yes, it seems we don't need to run nest build in Vercel.
- if the answer is no, what Vercel did to main.ts then?

Set up Prod and Dev environments of Database

Alexander6 — Thu, 28 Sep 2023 12:53:23 +0000

These days I have finished the primary logic of the backend and run it successfully. I launched a local Postgres instance via Docker, and the Nest project writes and reads data from it using Prisma. all things run smoothly locally.
But about 2 days ago, I tried to deploy the whole project. As for the database, I chose ** Supabase **. And the Nest project, I want to deploy it on Vercel.
How to sync my database migration to Supabase ?
What is the command like?

These issues are worth documenting

3rd day: set up Axios & React-Query

Alexander6 — Mon, 18 Sep 2023 12:14:15 +0000

Today

have created a record into database through Axios and React-Query.
- Because I have already been using Axios for many years, there are no challenges to integrating it.
- The document of React-Query is very clear and practical, so it is also very easy to set up it.

Problems

no technical problems today, it's time to focus on the functionalities.

What to do next

Collect all opened tabs, and save them to the database
Create a SPA project to show data collected by the extension.

2nd day of my development

Alexander6 — Sun, 17 Sep 2023 12:48:45 +0000

Today:

just duplicated a previous project using Nest&Prisma, did some modifications, and set up a local database through Docker , successfully launched the first API to create a record.

Problems:

before, I had used Sqlite because it is easy to learn and use, but in this project, I think it's better to use PostgreSQL, as I am using Prisma, so for many situations, I can just use functions provided by Prisma, instead of learning new acknowledgment of PostgreSQL now.
there was also another thought that came up to me. if you are going to write a simple API such as creating a record, you have to code in controller, service, and dto. I heard that Ruby on Rails is more efficient, but I don't know if it has code recommendations and official plugins for PostgreSQL
for now, I think it's better to use Nest.js, I can improve my skills in the backend and database through this project soon.

Tasks for tomorrow:

setup Axios and React-Query in my frontend project
post and fetch data from the backend

The first day of my solo project

Alexander6 — Sat, 16 Sep 2023 13:37:02 +0000

I am going to create a Chrome extension where people can share their tabs and comments with the same link in real time.
Here is the first-day record of my development.

Sep 16:

Completed:

completed basic setup of the whole project, intergrated TailwindCSS and ChakraUI

Problems:

as ts-loader can't compile a class with private keyword, so I change the ts-loader into babel-loader, and used babel-loader's plugin to compile ts file
webpack is so slow, because I have been using vite for a long time, maybe someday I should change webpack5 to vite

upcoming tasks:

implement the function of "recommend my tabs", especially the server part,
the server part consists of SQL and backend logic
and the deployment flow of the backend service

DEV Community: Alexander6

The purpose of Edge functions?

Create an App with EXPO (1)

So let't start it.

After doing this, I tried pnpm ios, wating for the installation

Rename all files and directories in the current folder

A confusing problem of the Mysql timestamp

Background

Firstly

result of my local Mysql client

result of RDS

result of local

result of RDS

Problems while setting up Nginx on AWS EC2

Error: listen EACCES: permission denied 0.0.0.0:81

Nginx's user must be the one that you login via SSH, normally it would be ec2-user

(help)Deploy Nest.js Application to Vercel

Set up Prod and Dev environments of Database

These issues are worth documenting

3rd day: set up Axios & React-Query

Today

Problems

What to do next

2nd day of my development

Today:

Problems:

Tasks for tomorrow:

The first day of my solo project

Sep 16:

Completed:

Problems:

upcoming tasks:

After doing this, I tried `pnpm ios`, wating for the installation

`Error: listen EACCES: permission denied 0.0.0.0:81`

Nginx's user must be the one that you login via SSH, normally it would be `ec2-user`