Python
pip install lancedb import lancedb
db = lancedb.connect(
"https://<instance>.fly.dev",
api_key="<instance token>",
)
table = db.create_table("clicks", data=[
{"id": 1, "city": "ams", "value": 2.0},
{"id": 2, "city": "ams", "value": 3.0},
{"id": 3, "city": "ber", "value": 7.0},
])
print(table.count_rows())
print(table.search().where("city = 'ams'").to_list())
JavaScript
npm install @lancedb/lancedb import * as lancedb from "@lancedb/lancedb";
const db = await lancedb.connect({
uri: "https://<instance>.fly.dev",
apiKey: "<instance token>",
});
const table = await db.createTable("clicks", [
{ id: 1, city: "ams", value: 2.0 },
{ id: 2, city: "ams", value: 3.0 },
{ id: 3, city: "ber", value: 7.0 },
]);
console.log(await table.countRows());
console.log(await table.query().where("city = 'ams'").toArray());