# TypeORM SQLite Example

Steps to run this project:

1. Run `npm i` command
2. Run `npm start` command

## Notes

This is an ESM (ECMAScript Modules) example using TypeORM with SQLite. It demonstrates:

* ESM module usage
* Modern async/await patterns
* Proper database connection handling with cleanup
* TypeScript decorators and entity definitions

The example uses `sql.js` as the database driver, which creates an in-memory SQLite database.

## Available Commands

```bash
# Start the application
npm start

# Build the TypeScript code
npm run build

# Run TypeORM commands (if needed)
npm run typeorm
```

## What the Demo Does

When you run `npm start`, the application will:

* Initialize an in-memory SQLite database
* Create the User table with columns for id, firstName, lastName, email, and isActive
* Insert a sample user (John Doe)
* Retrieve and display the user data

## Project Structure

```
src/
  ├── entity/
  │   └── User.ts         # User entity definition
  ├── index.ts            # Main application code
  └── ormconfig.ts        # Database configuration
```

## Note

Since this project uses an in-memory database, all data is temporary and will be cleared when the application stops. This makes it perfect for testing and development purposes.

The use of sql.js makes this project compatible with browser environments like Stackblitz, as it doesn't require any native dependencies.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://orkhan.gitbook.io/typeorm/playground.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.