Waterlily Survey App Development

jorge ramos

Game Developer

Next.js

Node.js

SQLite

Computer Software

Waterlily Survey App

Prerequisites

Node.js (v18 or newer recommended)

npm (comes with Node.js)

Getting Started

Clone the repository:

git clone <your-repo-url>
cd waterlily-survey-app

Install dependencies:

npm install

Run the development server:

npm run dev

The app will be available at http://localhost:3000

Database:

The app uses SQLite (waterlily.db).

The database and tables are created automatically on first run.

No manual setup is required unless you want to pre-populate data.

Environment Variables:

If you need to set environment variables, create a .env.local file in the root directory.

Example:

# .env.local
# NEXT_PUBLIC_API_URL=http://localhost:3000

Linting and Formatting:

Run npm run lint to check for lint errors.

Project Structure

app/ - Main Next.js app code

public/ - Static assets

waterlily.db - SQLite database file

survey-data.ts - Database schema and interfaces

api/ - API routes

Notes

Make sure .db files and other sensitive files are not committed (see .gitignore).

For production, review security and deployment best practices for Next.js and SQLite.

Troubleshooting

If you encounter issues, ensure Node.js and npm are up to date.

Check the terminal for error messages.

Delete waterlily.db to reset the database (all data will be lost).

For questions or contributions, open an issue or pull request.

Getting Started

First, run the development server:

npm run dev
# or
yarn dev
# or
pnpm dev
# or
bun dev

Open http://localhost:3000 with your browser to see the result.

You can start editing the page by modifying app/page.tsx. The page auto-updates as you edit the file.

This project uses next/font to automatically optimize and load Geist, a new font family for Vercel.

Learn More

To learn more about Next.js, take a look at the following resources:

Next.js Documentation - learn about Next.js features and API.

Learn Next.js - an interactive Next.js tutorial.

You can check out the Next.js GitHub repository - your feedback and contributions are welcome!

Deploy on Vercel

The easiest way to deploy your Next.js app is to use the Vercel Platform from the creators of Next.js.

Check out our Next.js deployment documentation for more details.

Like this project

Posted Sep 2, 2025

Developed a survey app using Next.js and SQLite.

Likes

Views