Main Site Documentation

SQLite - what's supported?


#1

Hi!

Whats supportet in SQLite from the GHI Library? I know that the datatypes INTEGER, DOUBLE and TEXT are supportet, but which queries are possible? SELECT, DELETE, INSERT - but is WHERE, GROUP BY, HAVING, ORDER BY possible? I can’t find a documentation about it.

Thanks for info.

Andi


#2

I am not sure what was tested but we didn’t remove anything from SQLite do all should work. I also remember an issues with date time field.


#3

DateTime? The Library Documentation says, that only INTEGER, DOUBLE and TEXT is available?


#4

Yeah, That what Gus meant no DateTime.


#5

ok, but the rest of the sqlite-standard is implemented?


#6

I have already answered your question.

If you do not own the hardware and you have specific query you want us to try for you then let us know.


#7

I have a ChipworkX Board - I’ll try…