start

Dynamically created startpage / bookmarks page. Practice project for trying out Svelte.

Goals / To-Do

• Create admin page that talks to the Sqlite DB & let's me add categories and bookmarks
• Have a button that lets me export the whole bookmarks page to a html file that I can use in matkv.dev
• Play around with the styling more (Tailwind works already)

Setup

Using sqlite for the DB this time. So it's not needed to run docker like in the previous example with a MySQL DB.

Settings I used during the setup:

• Template -> SvelteKit minimal
• TypeScript -> Yes
• Added eslint, tailwindcss, drizzle
• Added typography plugin for tailwindcss
• Drizzle -> SQLite
• SQLite client -> libSQL

Running the app

If not done yet, set a DATABASE_URL in a .env file:

DATABASE_URL="file:./db.sqlite"

Then push the schema to the DB:

npm run db:push

Running the svelte app:

npm run dev

Accessing DB in CLI (in project root folder):

sqlite3 local.db

.tables # show all tables

SELECT * FROM user; # show all users (temp table for trying out for now)