Home › Installation

Installation

Get SIMPLE_SQL set up in your Eiffel project.

Prerequisites

Step 1: Get the Library

Clone or download SIMPLE_SQL to your development environment:

git clone https://github.com/yourorg/simple_sql.git D:/prod/simple_sql

Step 2: Set Environment Variable

Set the SIMPLE_SQL environment variable to point to the library location:

Windows

setx SIMPLE_SQL "D:\prod\simple_sql"

Linux/macOS

export SIMPLE_SQL="/path/to/simple_sql"

Step 3: Add to Your ECF File

Add SIMPLE_SQL as a library in your project's ECF file:

<system name="my_app" xmlns="...">
    ...
    <library name="simple_sql" location="$SIMPLE_SQL/simple_sql.ecf"/>
    ...
</system>
Alternative: Absolute Path

If you prefer not to use environment variables, you can use an absolute path:

<library name="simple_sql" location="D:/prod/simple_sql/simple_sql.ecf"/>

Step 4: Verify Installation

Create a simple test to verify everything works:

class TEST_SIMPLE_SQL

create
    make

feature

    make
        local
            db: SIMPLE_SQL_DATABASE
        do
            create db.make_memory
            db.execute ("CREATE TABLE test (id INTEGER PRIMARY KEY, value TEXT)")
            db.insert_into ("test").value ("value", "Hello SIMPLE_SQL!").execute
            print ("SIMPLE_SQL installed successfully!%N")
            db.close
        end

end

SQLite Dependencies

SIMPLE_SQL depends on eiffel_sqlite_2025, which bundles SQLite 3.51.1 with these extensions enabled:

Project Structure

simple_sql/
├── simple_sql.ecf          -- Library configuration
├── src/                    -- Source files
│   ├── simple_sql_database.e
│   ├── simple_sql_result.e
│   ├── simple_sql_row.e
│   └── ...
├── testing/                -- Test suite
├── docs/                   -- Documentation (you're reading it!)
└── README.md

Troubleshooting

Library Not Found

If EiffelStudio can't find the library:

  1. Verify the SIMPLE_SQL environment variable is set
  2. Restart EiffelStudio after setting environment variables
  3. Check that the path contains simple_sql.ecf

SQLite Linker Errors

If you see linker errors related to SQLite:

  1. Ensure eiffel_sqlite_2025 is properly installed
  2. On Windows: verify Visual Studio C++ compiler is accessible
  3. Try "Compile from scratch" to rebuild all C components

Next Steps

← Quick Start | Basic CRUD →