but I can see the records inside the storage.sqlite file, so they must be accessible somehow
On Wednesday, December 19, 2012 3:51:37 PM UTC+2, Niphlod wrote: > > I said *messed up* just to use part of your sentence. > With referenced table, if you used the default ondelete attribute of the > field, every "child" record gets deleted as soon as the "parent" is deleted. > You can't fetch the data drom sqlite, it's definitely gone. For goods. > The fact that the sqlite file is still "large" is because by default > SQLite doesn't "release" the space: it keeps it for future records. > > On Wednesday, December 19, 2012 2:38:32 PM UTC+1, Aurelijus Useckas wrote: >> >> is there any way to extract data from sqlite? The file is still full of >> data... >> >> I don't understand, if you delete somthing that is linked, everything >> messes up? >> >> On Wednesday, December 19, 2012 3:34:31 PM UTC+2, Niphlod wrote: >>> >>> definitely messed up. no way they will "return back". That's why >>> referenced tables are for. >>> >>> Il giorno mercoledì 19 dicembre 2012 14:25:01 UTC+1, Aurelijus Useckas >>> ha scritto: >>>> >>>> i'm on SQLite >>>> >>>> On Wednesday, December 19, 2012 3:21:27 PM UTC+2, Aurelijus Useckas >>>> wrote: >>>>> >>>>> I've deleted user information from auth_users and suddenly all my data >>>>> (from other table views) disapears.. Yes, other tables are linked to this >>>>> one. Specifically for info on updates and simillar... >>>>> >>>>> If I restore the same data in auth_users other table still doesn't >>>>> show anything... I event reset the autoincrement and make it appear >>>>> totally >>>>> identical.. still nothing :( >>>>> >>>>> did i mess up??? :( >>>>> >>>> --