[sqlite] Tables and Columns of Database of Whatsapp

2015-06-29 Thread Scott Doctor
If you are attempting to teach SQL, why not just use a simple example, such as an address book. Probably more informative to work through the process of creating a simple address table, then adding a second table of people to discuss foreign keys and such. Two people may link to the same address.

[sqlite] Tables and Columns of Database of Whatsapp

2015-06-29 Thread Darko Volaric
It should be kept in mind that lawyers routinely put things in these "click-through agreements" that is unenforceable or illegal. It may be perfectly legal to reverse engineer, for example: ( from https://www.eff.org/issues/coders/reverse-engineering-faq ) "Courts have found that reverse

[sqlite] RemovableStorage in UWP for SQLite database - sqlite3_open_v2 issue

2015-06-29 Thread Howard Kapustein
You can compile SQLite using CreateFile instead of CreateFile2. That doesn't have the allowed-paths restriction (among other things). But you won't pass WACK so Store will reject your submission. The solution is to change CreateFile2 to support removable media w/the capability check (or some

[sqlite] RemovableStorage in UWP for SQLite database - sqlite3_open_v2 issue

2015-06-29 Thread Howard Kapustein
>> Thank you for your really specific answer, I will go to the IoT forum, >> insider, etc to make the request. >Don't bother. They won't change it. The inability to access these places is >intentional. It means that programs can't read each-other's files so malware >programs (e.g. spyware,

[sqlite] Tables and Columns of Database of Whatsapp

2015-06-29 Thread Darren Duncan
Actually, here's a way you can be even more clear legally... Don't download/use WhatsApp yourself, rather have someone else use it, and then give you a copy of their SQLite database it produced. You yourself only look at the SQLite database, and not the program. This is then essentially a

[sqlite] Tables and Columns of Database of Whatsapp

2015-06-29 Thread Darren Duncan
I think a WhatsApp database is analogous to a data file and falls outside the concept of reverse engineering here. If say Microsoft Word had legalize against reverse-engineering it, a reasonable person wouldn't expect that to apply to reverse-engineering the format of MS Word documents, rather

[sqlite] Tables and Columns of Database of Whatsapp

2015-06-29 Thread Simon Slavin
On 28 Jun 2015, at 1:24pm, bob_sqlite at web.de wrote: > I teach pupils SQL in school. > > I want to create exercises about the SQLite database of Whatsapp. > > Can you tell me the names of tables and the names of columns? Open the database in the SQLite command-line tool and issue this

[sqlite] Tables and Columns of Database of Whatsapp

2015-06-29 Thread John McKown
On Sun, Jun 28, 2015 at 7:24 AM, wrote: > Hi, > > I teach pupils SQL in school. > > I want to create exercises about the SQLite database of Whatsapp. > > Can you tell me the names of tables and the names of columns? > > For the tables, I'll think of data. > > Thank you, > > Bob > I'm going to

[sqlite] RemovableStorage in UWP for SQLite database - sqlite3_open_v2 issue

2015-06-29 Thread Simon Slavin
On 29 Jun 2015, at 7:29am, Juan Pablo Garc?a Coello wrote: > Thank you for your really specific answer, I will go to the IoT forum, > insider, etc to make the request. Don't bother. They won't change it. The inability to access these places is intentional. It means that programs can't

[sqlite] RemovableStorage in UWP for SQLite database - sqlite3_open_v2 issue

2015-06-29 Thread Juan Pablo García Coello
In one way I am happy to know that there is people having a great knowledge about these matters. At this moment I am sure that compiling and testing if it is possible to use that method will take me a lot of time and I do not know how much time it take. Does any have the capability to try to

[sqlite] RemovableStorage in UWP for SQLite database - sqlite3_open_v2 issue

2015-06-29 Thread Juan Pablo García Coello
Thank you for your really specific answer, I will go to the IoT forum, insider, etc to make the request. -Original Message- From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Howard Kapustein Sent: 28 June 2015