yortus/DBFFile

How to write sql query when open dbffile

sahaphon opened this issue · 4 comments

sahaphon commented

I want query data when open dbffile.

sahaphon commented

Help me!.

yortus commented

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.

  • 👍1
lordrip commented

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.

  • 👍1
yortus commented

Closing due to no recent activity