Skip to content

Latest commit

 

History

History
87 lines (59 loc) · 1.99 KB

README.md

File metadata and controls

87 lines (59 loc) · 1.99 KB

Discord Twitter MIT License

sqlt

SQLT :: PostgeSQL

A simple Ecto-ORM logger written in pure Elixir.


Written in Elixir

elixir

Tested with PostgreSQL

postgresql


Get started

First you have to install Elixir (v13.2+) with OTP Version 23+

  • Clone the repository
$ git clone https://github.com/vkxni/sqlt

$ cd sqlt
  • Install the dependencies
$ mix deps.get
  • Check if mix is working
$ mix status
  • Setup the database
  • Info: Your first have to fill out the .env file.

If there is data in the database, you can drop it.

$ mix ecto.drop

Then create the database (tables, schemas ...)

$ mix ecto.create


# optional (advanced)
$ mix ecto.migrate
  • Launch iex
$ iex -S mix
  • Run Queries

Inserting, editing, deleting and purging data.

iex> Query.insert

iex> Query.multi_insert

iex> Query.edit

iex> Query.delete

iex> Query.purge

  • Showcase

Once ran, a raw.sql file will be created in the root directory of your folder.

Showcase