How to write sql query when open dbffile
Closed this issue · 4 comments
I want query data when open dbffile.
Help me!.
Hi @sahaphon, there's no SQL interface in this package, so somebody has to create one. It would involve first parsing SQL strings into an AST, then creating and executing a query plan from the AST.
If anyone wants to have a crack at this, I had a similar wish a few years ago to query ADT database files using SQL, and wrote https://github.com/yortus/sql2adt. That would be a good starting reference for what is required.
Hi, just my 2cents here. Since the records of the file are being returned in an array, could be a reduce / map combination a workaround for this?
What kind of SQL statement do you wanna issue? Apart from that, if the project is not multiplatform, maybe you could add this data into sqlite file and issue the queries there.
Closing due to no recent activity