derflocki, 14 days ago

@nyamsprod neat idea. I'm curious have you experimented with (does this even work in php) the csv support in sqlite? https://www.sqlite.org/csv.html

nyamsprod, 14 days ago

@derflocki there are a couple reasons why I do not use SQLite. First the package needs no dependencies, two, the feature was already present in the package like 7 years ago I only updated the UX around it and last but not least I seldom encounter CSV that adheres fully to the draft/informal RDC. Hence using the SQLite extension would not solve CSV parsing in real world IMHO.

derflocki, 14 days ago

@nyamsprod Thanks for the explanation!

thomas_shone, 14 days ago

@nyamsprod love it. Possibly typo in the documentation though. Should it be addWhere or andWhere? The list of 3 logical xxWhere methods contain andWhere but the example shows addWhere.

nyamsprod, 14 days ago

@thomas_shone should be andWhere will fix the document thanks for the quick look👍

kaystrobach, 14 days ago

@nyamsprod will you add pseudo sql support?

nyamsprod, 14 days ago

@kaystrobach it was already present now just making it a bit more obvious and easy to use I hope.
It feels like SQL but it's 100% PHP at its core