Database

1. Sqlite

Applicable version

>=3.4.1

2. PgLite

Applicable version

>3.3.7 & <=3.4.1

2.1. Start service

1. cd dev path

2. Enable node environment: cmd execute node

3. Execute script

   const { PGlite } = await import("@electric-sql/pglite");
   const { createServer } = await import("pglite-server");
   
   const start = async () => {
     // Connect to the database, the database address is your own physical address
     const db = new PGlite('/Users/HiramWong/Library/Application\ Support/zyfun/database');
     await db.waitReady;
     const PORT = 5432;
     const pgServer = createServer(db);
     pgServer.listen(PORT, () => {
       console.log(`Server bound to port ${PORT}`);
     });
   }
   
   start();

2.2. Connection

Follow Navicat