dimitarvp / xqlite

An Elixir SQLite database library utilising the rusqlite Rust crate

Hello. 👋

🧔 Programmer with a keen eye for detail, loves making the code readable and maintainable. Pragmatic and never cutting corners. Automating myself out of the job is my ultimate goal.

💼 Focused on backend programming with Elixir, Rust and Golang, know shell scripting and databases. Interested in Linux system administration and network administration and I do well there.

📖 Previous experience: C, C++, some x86 Assembly, Java, PHP, Javascript, Ruby (plus Ruby on Rails).

👷 I am open to many formats of work but have come to appreciate stability and loyalty more than anything else. I am a good and patient coach, and have made money through that, and code reviewing too.

🔖 Keen interest in game bots, financial trading, formal verification of code and super-optimization (compiler tech).

📫 Drop me a line if you want to talk, I am friendly and curious and don't refuse interesting discussions, be it about programming or anything else.

Other profiles:

• HackerNews: https://news.ycombinator.com/user?id=pdimitar
• LinkedIn: https://www.linkedin.com/in/dpanayotov/

xqlite's Issues

Support actual querying

Leave out prepared statements for now.

Add tests for setting PRAGMAs.

Since there's extra knowledge needed to be encoded in the test code, currently the PRAGMA set functions are not tested. This should be changed.

Support atom values when setting PRAGMAs.

Currently, getting the values of PRAGMAs applies conversion from the sqlite integer values to Elixir atoms, but the reverse is not happening. Let's support it. Example:

Xqlite.Pragma.put(:auto_vacuum, 0) # This works.
Xqlite.Pragma.put(:auto_vacuum, :none) # This does not work.

roadmap

is this the roadmap?

• I found a lot of configuration options for Sqlite3 which I want to expose to an underlying raw Sqlite3 library, not the Ecto adapter itself.
• I want to avoid Mix.Config since it's now deprecated (in Elixir 1.9). I'm gonna experiment in my repo with a process dictionary configuration, or GenServer state. Not yet determined.
• I am not interested in supporting very old Elixir versions, not to mention that one of the Sqlitex dependencies mandates Elixir 1.7 anyway.

sounds like you want to put it in the README for the project, not so?