search

apache / opendal

Apache OpenDAL: access data freely.
https://opendal.apache.org
Apache License 2.0
3.05k stars 423 forks source link

Add `fn scan` for sql dbs #4604

Open GG2002 opened 2 months ago

GG2002 commented 2 months ago

I‘ve noticed that SQLite has impl scan fn, while MYSQL, PostgreSQL, D1, and SurrealDB have not yet impl it. Since they are all SQL dbs (actually, I'm not quite sure if SurrealDB is SQL db), I thought the operation they perform should be similiar.

I'd like to add scan fn to these dbs as well. Could anyone give me some advice?

Xuanwo commented 2 months ago

I prefer to refactor https://github.com/apache/opendal/issues/3639 first so we have a more solid base for adding more services.

Current design requires us to list all keys at once.