superduper icon indicating copy to clipboard operation
superduper copied to clipboard

For insertions and queries, use a unified interface

Open jieguangzhou opened this issue 1 year ago • 5 comments
trafficstars

For MongoDB and Ibis Currently:

  • MongoDB uses insert_many for data insertion and find for queries.
  • Ibis uses insert for data insertion and select for queries.

For these very frequent interfaces, we can provide a unified method:

db["table_or_collection_name"].insert(datas)
df["table_or_collection_name"].query(a=1, b=2)
  • insert_one
  • query_one
  • filter
  • limit
  • output_fields

By standardizing these common operations, similar to the most frequently used ones in superduperdb, everything will become simpler to use. For complex operations, the original logic can still be used.

As for the names, we can discuss and define query/select/find later.

jieguangzhou avatar May 17 '24 10:05 jieguangzhou