How to configure phoenix for sqlite

[staymetal]

Can one guide me step by step in configuring phoenix with sqlite ?

P.S. im on elixir 1.6 and latest phoenix

Thanks a ton !!

[AstonJ]

You might find this thread of interest:

So what is the problem with sqlite?

I seems like sqlite is kind of a no-go in phoenixworld - why is this the case? Certainly for development or smaller apps sqlite does very well with all kinds of programming languages - so what’s the issue with elixir/phoenix? Thanks!

And this post:

So what is the problem with sqlite?

@lambrospetrou

And I have to ask, why not just use Postgres?

[sergio]

Some of the replies in that thread are a trainwreck.

This guy comes in with a clear question and some people just go “use postgresql”. Thankfully Chris came in and replied with some actual information.

@staymetal check out this link: http://twentyeighttwelve.com/creating-a-phoenix-framework-application-with-sqlite/

Seems like a simple adapter switch.

[AstonJ]

If the replies are helpful (and aren’t too off-topic) then that can definitely be a good thing

Sometimes I put myself in the shoes of the person asking the question, and ask myself, if it were me, what would I wish I was told or made aware of? Postgres is excellent and I can’t see any good reason to use Sqlite over it in Phoenix - so why not help the OP by sharing this info?

I think in topics like this it can not only advance the OP, but be generally progressive as well - just like we’ve seen with the shift from MySQL to Postgres, PHP to Rails, and now, people recommending Phoenix in cases where it makes sense to do so as well

[gon782]

@AstonJ

Postgres is excellent and I can’t see any good reason to use Sqlite over it in Phoenix - so why not help the OP by sharing this info?

While I agree that Postgres works fine and is a good enough solution for most people to start with, SQLite is much simpler than all of the “real” databases. It works on a library level, requires no setup (meaning it doesn’t require any privileges on the box you’re working on) whatsoever and has bindings in every language out there. You get trivial database copying out of the box and all in all it’s a much better fit for small projects.

[staymetal]

Thank you for your replies guys…truly elixir has an awesome community !!

[staymetal]

Im learning elixir on archlinux running on android.Postgresql and mariadb are segfaulting on it so im left with sqlite !

[gon782]

@staymetal

Im learning elixir on archlinux running on android.

Wow, that is an odd environment. Does that usually work well (apart from apparently with DBs)?

[staymetal]

Yes sir !!..its great !!!

Working : full linux arch environment
Elixir
Phoenix
Java and JVM
Erlang
Gcc,g++
asm
Python
Ruby
sqlite
Haskell
Metasploit
Hydra
Backdoor factory
And a ton of penetration tools

Not working :

             Mariadb
             Postgresql
             Nodejs and Npm

[kokolegorille]

Oh… funny tools. I wonder if we could take advantage of Elixir concurrency with Hydra and Metasploit.

[AstonJ]

@gon782

While I agree that Postgres works fine and is a good enough solution for most people to start with, SQLite is much simpler than all of the “real” databases. It works on a library level, requires no setup (meaning it doesn’t require any privileges on the box you’re working on) whatsoever and has bindings in every language out there. You get trivial database copying out of the box and all in all it’s a much better fit for small projects.

I would still not recommend it is used over Postgres with Phoenix - it’s better to use the same DB in development as production if at all possible. Postgres is not that much more difficult to set-up either Imo (least not on Mac and Linux - not sure about Windows).

Having said that, the OP’s use-case is different - they don’t have any choice

@staymetal

Im learning elixir on archlinux running on android.Postgresql and mariadb are segfaulting on it so im left with sqlite !

That’s interesting! What kind of hardware is that on?

[staymetal]

Nexus 5 - armv7