sync tries to always create a table about denodb HOT 7 CLOSED

Hey Antonis,

You are right, it actually tries to create the tables every single time.
I will work on this right now and update this issue.

from denodb.

Even with no parameter (and implicit drop: false)?

await db.sync();

sync will by default drop the table if it exists if drop is set to true, and recreate it if does not exist. So I am not sure why it wipes the data every time?

from denodb.

yeah, my bad, I forgot the "drop: true".
I removed that and it's fine.

thanks 👍

from denodb.

It should now be functional.
Just remember to use --reload to make sure you get the last library version.

Feel free to get in touch if you're still facing an issue! Or anything else obviously :)

from denodb.

Hey @eveningkid
Thanks for getting a fix to this.
I don't get any errors anymore, but I think it wipes out the table every time I start it :/
Cannot persist any data in the table...

from denodb.

I'm still getting this error. If I use drop: true then data is wiped.

$ deno run  --allow-all index.ts
error: Uncaught (in promise) SqliteError: index email already exists
    return new SqliteError(msg, code);
           ^

if i remove it, then it gripes that table already exists.

from denodb.

I have the same issue here, with drop it removes the table and recreates it. Without it, it throws an issue that the table already exists.
There is no solution to persist the data of the created tables and not erase them for every server restart?

from denodb.