Ping CRM with Turso Database

This is a forked repository of the original Ping CRM, a demo project showcasing Inertia.js with Laravel.

You can access this demo application online at https://pingcrm.richan.id/.

This demo application illustrates how Laravel and Inertia.js work perfectly with the Turso database. The original Ping CRM uses an SQLite database, but this forked repository uses the Turso database.

This demo has adopted the Turso Embedded Replica feature, boosting the application's performance to be super fast! 🚀

The Turso database connection in this demo application is made possible by integrating the Turso Database Driver for Laravel package.

Installation

Clone the repo locally:

git clone https://github.com/inertiajs/pingcrm.git pingcrm
cd pingcrm

Install PHP dependencies:

composer install

Install NPM dependencies:

npm ci

Build assets:

npm run dev

Setup configuration:

cp .env.example .env

Generate application key:

php artisan key:generate

Save your Turso database credentials in the .env file. You can either obtain the Turso database credentials by following the instructions here or use the Turso local development server as described in the local development guide. If you're using the local development server, set the DB_URL to http://localhost:8080 and leave the DB_ACCESS_TOKEN empty.

DB_CONNECTION=turso
DB_URL=http://localhost:8080
DB_ACCESS_TOKEN=
DB_REPLICA=
DB_PREFIX=
DB_FOREIGN_KEYS=true

Run database migrations:

php artisan migrate

Run database seeder:

php artisan db:seed

Run the dev server (the output will give the address):

php artisan serve

You're ready to go! Visit Ping CRM in your browser, and login with:

• Username: johndoe@example.com
• Password: secret

Running tests

To run the Ping CRM tests, run:

phpunit