Here's some more info:
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (13) |
See the Overview:
<http://wiki.nsbasic.com/SQLite_made_Simple>
George Henne
NS BASIC Corporation
http://www.nsbasic.com
>I'm tinkering with the example that opens the "students.db" file in
>SQLite. The sample runs fine in Chrome and it's obvious that the data
>is being placed there but I search for "students.db" and can't find it
>anywhere. Where does NSBasic keep it? The directory from which I
>loaded the sample doesn't have it, nor is it anywhere on my local
>machine. Is this cached somewhere?
>
>
LOL ... nope, it's not there either! I can even get to a DOS prompt and do a hard drive scan "dir /b/s students.db" and it doesn't show up on the hard drive ANYWHERE!-bruceOn Friday, June 10, 2016 2:09 PM, "'SEF Mediapro Inc' sef.me...@sympatico.ca [nsbasic-app]" <nsbas...@yahoogroups.com> wrote:
Try looking under:%username%\AppData\Local\Google\Chrome\User Data\Default\databasesHTHJamesFFrom: nsbas...@yahoogroups.com [mailto:nsbas...@yahoogroups.com]
Sent: June 10, 2016 2:02 PM
To: nsbas...@yahoogroups.com
Subject: Re: [nsb-appstudio] SQLite database fileI've been reading that, George. The code works, but I can't find the "student.db" on the system anywhere after running it. I even made the SqlOpenDatabase() call in one of my projects and ran it in Chrome. I can't find the [damned] file anywhere (and the overview hasn't yet explained where it physically creates it!)Thanks-bruce
On Friday, June 10, 2016 1:57 PM, "'George Henne' g...@nsbasic.com [nsbasic-app]" <nsbas...@yahoogroups.com> wrote:See the Overview:
<http://wiki.nsbasic.com/SQLite_made_Simple>
George Henne
NS BASIC Corporation
http://www.nsbasic.com
>I'm tinkering with the example that opens the "students.db" file in
>SQLite. The sample runs fine in Chrome and it's obvious that the data
>is being placed there but I search for "students.db" and can't find it
>anywhere. Where does NSBasic keep it? The directory from which I
>loaded the sample doesn't have it, nor is it anywhere on my local
>machine. Is this cached somewhere?
>
>
We don't put it anywhere. It's hidden (by Chrome) in Chrome's sandbox. You're not meant to get at it directly.
>What's the point of naming it "students.db" if that isn't the name of
>the file? Besides, the documentation states that's the actual file name
>anyway. I've scanned for .db and looked at all occurrences to see if
>one is called "students", I've scanned for all files called "students.*"
>it isn't showing up ANYWHERE. C'mon, George, where'd you put it? ;-)
>
>
>O n Friday, June 10, 2016 2:33 PM, "sef.me...@sympatico.ca [nsbasic-
>app]" <nsbas...@yahoogroups.com> wrote:
>
>
>
>I don't think the extension is .db
>Try *.*
>
>Sent from my BlackBerry 10 Passport
>From: Bruce Roeser bruce....@yahoo.com [nsbasic-app]
>Sent: Friday, June 10, 2016 2:31 PM
>To: nsbas...@yahoogroups.com
>Reply To: nsbas...@yahoogroups.com
I'm tinkering with the example that opens the "students.db" file in SQLite. The sample runs fine in Chrome and it's obvious that the data is being placed there but I search for "students.db" and can't find it anywhere. Where does NSBasic keep it? The directory from which I loaded the sample doesn't have it, nor is it anywhere on my local machine. Is this cached somewhere?
That's unofficial. Formally, the SQLite database is hidden inside the browser's sandbox. It is not intended that it be accessed from outside the browser.
>Try looking under:
>
>%username%\AppData\Local\Google\Chrome\User Data\Default\databases
>
>
>
>HTH
>
>JamesF
|
From: Bruce Roeser bruce....@yahoo.com [nsbasic-app]
Sent: Friday, June 10, 2016 2:31 PM
Reply To: nsbas...@yahoogroups.com
Subject: Re: [nsb-appstudio] SQLite database file
|
Thanks for the kind words!
George Henne
NS BASIC Corporation
http://www.nsbasic.com
>George,
>
>I finally got to the bottom of the "Using SQLite" tutorial where you
>explain how to see the DB's created in Chrome. I see now what you guys
>mean about the sandbox. I was wrong, you guys did explain it, I
>apologize if I was premature in my comments. I continue to be impressed
>by the depth of functionality this product seems to have. Thanks man!
>
>-bruce
>
>
>On Friday, June 10, 2016 5:55 PM, "Bruce Roeser bruce....@yahoo.com
>[nsbasic-app]" <nsbas...@yahoogroups.com> wrote:
>
>
>
>Thanks, I'll look into that!
>
>- bruce
>
>
>On Friday, June 10, 2016 3:33 PM, "lch...@austin.rr.com [nsbasic-app]"
><nsbas...@yahoogroups.com> wrote:
>
>
>
>Here's some more info:
>in c:\users\username\appdata\local\google\chrome\userdata\default
>\databases\foldername\
>you will find a file named with just a number. If you use a SQLite
>management tool (ManagementStudio for SQLite) you can see the structure
>and contents of that file, which is actually a SQlite database.
>Foldername is assigned by app address; I have no idea how Chrome decides
>on the file numbering scheme.
>
>
>
>
>
LOL ... nope, it's not there either! I can even get to a DOS prompt and do a hard drive scan "dir /b/s students.db" and it doesn't show up on the hard drive ANYWHERE!
-bruce
On Friday, June 10, 2016 2:09 PM, "'SEF Mediapro Inc' sef.me...@sympatico.ca [nsbasic-app]" <nsbas...@yahoogroups.com> wrote:
Try looking under:%username%\AppData\Local\Google\Chrome\User Data\Default\databasesHTHJamesF
From: nsbas...@yahoogroups.com [mailto:nsbas...@yahoogroups.com]
Sent: June 10, 2016 2:02 PM
To: nsbas...@yahoogroups.com
Subject: Re: [nsb-appstudio] SQLite database file
I've been reading that, George. The code works, but I can't find the "student.db" on the system anywhere after running it. I even made the SqlOpenDatabase() call in one of my projects and ran it in Chrome. I can't find the [damned] file anywhere (and the overview hasn't yet explained where it physically creates it!)Thanks
-bruce
On Friday, June 10, 2016 1:57 PM, "'George Henne' g...@nsbasic.com [nsbasic-app]" <nsbas...@yahoogroups.com> wrote:
See the Overview:
<http://wiki.nsbasic.com/SQLite_made_Simple>
George Henne
NS BASIC Corporation
http://www.nsbasic.com
>I'm tinkering with the example that opens the "students.db" file in
>SQLite. The sample runs fine in Chrome and it's obvious that the data
>is being placed there but I search for "students.db" and can't find it
>anywhere. Where does NSBasic keep it? The directory from which I
>loaded the sample doesn't have it, nor is it anywhere on my local
>machine. Is this cached somewhere?
>
>
Try looking under:
%username%\AppData\Local\Google\Chrome\User Data\Default\databases
HTH
JamesF
From: nsbas...@yahoogroups.com
[mailto:nsbas...@yahoogroups.com]
Sent: June 10, 2016
2:02 PM
To: nsbasic-app@yahoogroup
s.com
Subject: Re: [nsb-appstudio] SQLite database
file
I've been reading that, George. The code works, but I can't find the "student.db" on the system anywhere after running it. I even made the SqlOpenDatabase() call in one of my projects and ran it in Chrome. I can't find the [damned] file anywhere (and the overview hasn't yet explained where it physically creates it!)
Thanks
-bruce
On Friday, June 10, 2016 1:57 PM, "'George Henne' g...@nsbasic.com [nsbasic-app]" <nsbas...@yahoogroups.com> wrote:
See the Overview:
<http://wiki.nsbasic.com/SQLite_made_Simple>
George Henne
NS BASIC Corporation
http://www.nsbasic.com
>I'm tinkering with the example that opens the
"students.db" file in
>SQLite. The sample runs
fine in Chrome and it's obvious that the data
>is being placed
there but I search for "students.db" and can't find it
>anywhere. Where does NSBasic keep it? The directory
from which I
>loaded the sample doesn't have it, nor is it
anywhere on my local
>machine. Is this cached somewhere?
>
>