Factor out into a library.

[kdar]

I definitely have a use for this in my own project. It would be nice if textql was a library I could import, and then you would have a textql/textql directory that contained main.go that would import the library and provide a CLI interface to it.

[dinedal]

I agree, this is good practice, and should be done, but am curious as to what you would like to see for an exposed API

[tadev]

Seems interesting, would be useful indeed.
Something like a basic static query_csv("/path/to/csv",";""select * from tbl where users are idiots")
Or something like this:

csvdb := textql.load("/path/to/csv", ":", true, 2) // where true is for "header" and 2 is the line textql should start at
//then you could do something like this:
userCount = csvdb.query("select count(users) from tbl where users.idiot = 0")

BTW, i love textql and i love you for creating it. Since i know of it i am using it nearly every single day!

[kdar]

Could also have a LoadStream(), LoadString(), LoadBytes() that would loads from io.Reader, string, and []byte respectively. I feel like other things I would like to do (like creating indexes) could be done with the sql.DB object that is returned.

[dinedal]

This is done for V2, and released