I also don't understand how to be able to make sql queries to the database as I don't see any tables after loading wallet.dat. It just opens "main" db which I assume means that it didn't really open up wallet.dat at all.
Ah, sorry. You'll need to hit the textbooks about databases. BerkeleyDB is a form of NonSQL database called key-value-store. If you are at that stage where "database" has to support "sql queries" then you are at least semester away from understanding what's inside. Older editions of C.J.Date's book have most of the relevant material about "non-relational databases".Again, sorry.
Sure but I opened the database with dbsql that came with the Berkeley installation and I googled people using sql queries with that one. There's even a command to list tables but it returned nohing. I'll go RTFM if there's not some easy tools that makes it easy. Thanks!
If it's NoSQL it's a little different from regular SQL. NoSQL has another data storage model. It varies based on database type. For example, key-value stores function similarly to SQL databases, but have only two columns ("key" and "value"), with more complex information sometimes stored within the "value" columns. Document databases do away with the table-and-row model altogether, storing all relevant data together in single "document" in JSON, XML, or another format, which can nest values hierarchically.
