📙About

Create instant MySql gratification with a light, types safe ORM offering time saving tools. Pain-pleasure principle am I right?

⚙️Installation

[Step - 1 Create]

Or
npx create-next-app https://github.com/lnxAv/next-drizzle-mysql

[Step - 2 Connect]

I'm using Vercel

1. In your browser, go to your deployment settings > Environment Variables
2. Fill the following variable accordingly
( Note: You can separate production & development env's for security purpose )

DATABASE_USER, DATABASE_PASSWORD, DATABASE_HOST, DATABASE_PORT, DATABASE_SCHEMA

3. In your project terminal type

Vercel env pull

( Note: You can also type "vercel env ls" to list them )

I'm using npm create-next-app

1. In your project root add a `.env.local` file
2. Copy paste and fill accordingly

    # Development variables
    DATABASE_USER="root"
    DATABASE_PASSWORD="admin"
    DATABASE_SCHEMA="database"
    DATABASE_HOST="localhost"
    DATABASE_PORT="3306"

[Step - 3 Migrate]

I'm using a new database

1. Push the example tables in your new database with

npx drizzle-kit push:mysql

2. Populate your database with the magic button
3. Read the documentation below and enjoy :)

I'm using my own database

1. Pull your database DDL with

npm run pull-db

2. Copy/Paste the content From => To

database/drizzle/schema.ts => database/db_tables.ts

2. Get your data by modifying the example in

app/api/route.ts

4. If needed, modify the "magicAction" to populate your database.
5. Read the documentation below and enjoy :)

🔰Database Setup

For unfamilliar users, you can easily deploy your own database,
Grab a coffee and learn the basics in 17 minutes.
MySQL - The Basics // Learn SQL in 23 Easy Step

🤖Commands

npm run	Description
dev	Launch the project in development mode
build	Build the project, great to see package size
start	Launch the built project
prettier	Clean files according to `.prettierrrc.json`
lint	Verify files according to `.eslintrc.json`
Migrate	Run the migrations with Drizzle
drop	Lets you delete previously generated migrations from migrations folder
pull-db	Lets you pull DDL from existing database and generate a `schema.ts`
push-db	Lets you push your schema changes directly to the database
studio-db	Drizzle Studio is a new way for you to explore SQL database on Drizzle projects.

🛠️Tools documentation

Categories	Links
Cores	Next.js, Vercel, Drizzle ORM
Traductions	next-international
Providers	Next-Themes
Fetcher	SWR.js
Animation	Motion.dev
Dev Dependencies	husky, dotenv, drizzle-kit
	Total: 50kb