Using Sqlite

[tiagolr]

How can i use Sqlite instead of mysql? Would be very useful for testing purposes and also its much lighter for small projects, thank you.

[tiagolr]

Found it:

Before ufrontApplication.executeRequest()

Manager.cnx = sys.db.Sqlite.open("test.db");

There are some mysteries unsolved but the hello-world seems to work fine, i think this option should be explicit in the README, it makes sense since its A LOT easier to use sqlite.

[theRemix]

for anyone else coming to this discussion,
i have an example of hello using sqlite on my fork https://github.com/theRemix/hello

[jasononeil]

I'm open to a pull request, Sqlite is certainly more sensible for a quick
"hello world" example.

My main concern is that the PHP / Sqlite / Haxe 3.1.3 combo doesn't work,
but we could leave a comment explaining that, and hopefully Haxe 3.2 will
be released sometime in the next decade (or two).

We'd also have to make sure the DB is somewhere the web server has write
permissions for, and mention it in the README.
On 18/12/2014 10:23 AM, "theRemix" notifications@github.com wrote:

for anyone else coming to this discussion,
i have an example of hello using sqlite on my fork
https://github.com/theRemix/hello

—
Reply to this email directly or view it on GitHub
#2 (comment).

[tiagolr]

Yea perhaps a macro using #if sqlite #else ....

With some code comments next to it, should be enough to show that sqlite can be used and how it can be used once a user starts looking at the source code.

theRemix want to take care of that? I can add some comments or re-add mysql, send a pull request when you're ready.

[theRemix]

i will set that up. i'll show how both can be used.

[theRemix]

@jasononeil what do you mean by

PHP / Sqlite / Haxe 3.1.3 combo doesn't work

i compiled the hello.git project with Haxe Compiler 3.1.3 and it runs fine on php5,
here's a docker image that runs hello.git: https://registry.hub.docker.com/u/gomagames/debian-lnpsqlite

opening the database shows that it's working.

$ sqlite3 ufhelloworld.db
sqlite> select * from Registration;
1|2014-12-19 10:22:04|2014-12-19 10:22:04|test|test@test.com
2|2014-12-20 00:51:45|2014-12-20 00:51:45|hello test|test@test.com

[tiagolr]

Hi, there are troubles with sqlite tho, if try to login a user using:

// somewhere in your controler class
@inject
public var authApi:EasyAuthApi;

// somewhere in your route
var username = context.request.params.get("username");
var password = context.request.params.get("password");
authApi.attemptLogin( username, password );

It will generate an invalid Sqlite query, using FALSE instead of 0, it is an issue with haxe, something ill look forward in a couple of days i think.