I try and put together a simple script that shows this.
I was using Win64 avx on a win 8.1 system beta e
Sent from my iPhone
> On Jun 25, 2018, at 9:45 PM, bill lam wrote:
>
> what is your JVERSION ?
>
> what is the result of
> sqlite3_extversion_psqlite_ ''
>
> try also get the latest bina
what is your JVERSION ?
what is the result of
sqlite3_extversion_psqlite_ ''
try also get the latest binary again
getbin_psqlite_ ''
please also provide a minimal script which create a test database and
reproduce the bug. thanks.
On Tue, Jun 26, 2018, 10:56 AM John Baker wrote:
> I have put
I have put the SQLite addon and the e beta 807 build through a good test. I
used it to build a cross-reference
database of my online images. This involved creating a SQLite db from j,
reading a large 400 mb Thumbsplus SQLite db,
making numerous column inserts, and executing some updates as well.
B
I finally got around to testing the new sqlite addon for J 8.07.
Just as Chris noted insert speed is now MUCH faster. I've been able to
insert a million integers in test columns in a few seconds.
The entire process of loading sqlite databases has been reduced from a pain
to a pleasure.
sqlite is
Thanks, I can reproduce this and will fix
On Tue, Mar 21, 2017 at 7:48 AM, Tom Arneson wrote:
> I have a sqlite database with a table of gas purchase information
>
>
>
> NB. sqlhead works as expected when selecting a field using sql 'from'
>
>
>
> 1 sqlhead__db 'date from gaspur where car = 1'
>
I have a sqlite database with a table of gas purchase information
NB. sqlhead works as expected when selecting a field using sql 'from'
1 sqlhead__db 'date from gaspur where car = 1'
+--+
¦date ¦
+--¦
¦2015-12-02¦
+--+
1 sqltail__db 'date from gaspur where c
t;
> Linda
>
> -Original Message-
> From: Programming [mailto:programming-boun...@forums.jsoftware.com] On
> Behalf Of Raul Miller
> Sent: Monday, March 13, 2017 12:40 PM
> To: Programming forum
> Subject: Re: [Jprogramming] sqlite addon
>
> Which temp folder,
: Monday, March 13, 2017 12:40 PM
To: Programming forum
Subject: Re: [Jprogramming] sqlite addon
Which temp folder, specifically?
Also, which version of J are you running?
Thanks,
--
Raul
On Mon, Mar 13, 2017 at 11:50 AM, Linda A Alvord
wrote:
> I have been doing that. I can't access al
J805 is on a 32 bit machine.
J64-806 on my 64 bit machine.
Linda
-Original Message-
From: Programming [mailto:programming-boun...@forums.jsoftware.com] On Behalf
Of Raul Miller
Sent: Monday, March 13, 2017 12:40 PM
To: Programming forum
Subject: Re: [Jprogramming] sqlite addon
Which
cess in jhs.
>
> Linda
>
> -Original Message-
> From: Programming [mailto:programming-boun...@forums.jsoftware.com] On Behalf
> Of Eric Iverson
> Sent: Monday, March 13, 2017 10:34 AM
> To: Programming forum
> Subject: Re: [Jprogramming] sqlite addon
>
&g
nda
>
> -Original Message-
> From: Programming [mailto:programming-boun...@forums.jsoftware.com] On Behalf
> Of Eric Iverson
> Sent: Monday, March 13, 2017 10:34 AM
> To: Programming forum
> Subject: Re: [Jprogramming] sqlite addon
>
> When JHS automatically bri
ch 13, 2017 10:34 AM
To: Programming forum
Subject: Re: [Jprogramming] sqlite addon
When JHS automatically brings up Internet Explorer, just close it, and then use
your Chrome browser and use it.
You can stop the auto start of IE by editing the file:
c:/users/user/j805/addons/ide/jhs/config/jhs.cfg
amming [mailto:programming-boun...@forums.jsoftware.com] On
> Behalf Of bill lam
> Sent: Monday, March 13, 2017 6:10 AM
> To: programm...@jsoftware.com
> Subject: Re: [Jprogramming] sqlite addon
>
> Sqlite addon and its binary is updated and available on all platforms
> includin
Message-
From: Programming [mailto:programming-boun...@forums.jsoftware.com] On Behalf
Of bill lam
Sent: Monday, March 13, 2017 6:10 AM
To: programm...@jsoftware.com
Subject: Re: [Jprogramming] sqlite addon
Sqlite addon and its binary is updated and available on all platforms including
androids. Howev
the future?
>
> -Original Message-
> From: Programming [mailto:programming-boun...@forums.jsoftware.com] On Behalf
> Of bill lam
> Sent: Wednesday, March 8, 2017 17:09
> To: Programming forum
> Subject: Re: [Jprogramming] sqlite addon
>
> binary is not availa
lto:programming-boun...@forums.jsoftware.com] On Behalf
Of bill lam
Sent: Wednesday, March 8, 2017 17:09
To: Programming forum
Subject: Re: [Jprogramming] sqlite addon
binary is not available for android.
On 9 Mar, 2017 6:04 am, "Tom Arneson" wrote:
I tried the sqlite addon with the following result
software.com] On
> > > Behalf Of bill lam
> > > Sent: Wednesday, March 8, 2017 17:09
> > > To: Programming forum
> > > Subject: Re: [Jprogramming] sqlite addon
> > >
> > > binary is not available for android.
> > >
> > &g
7 17:09
To: Programming forum
Subject: Re: [Jprogramming] sqlite addon
binary is not available for android.
On 9 Mar, 2017 6:04 am, "Tom Arneson" wrote:
I tried the sqlite addon with the following results:
NB. PC running Windows10
load'data/sqlite'
getbin_psqlite_'
8, 2017 17:09
> To: Programming forum
> Subject: Re: [Jprogramming] sqlite addon
>
> binary is not available for android.
>
> On 9 Mar, 2017 6:04 am, "Tom Arneson" wrote:
>
> > I tried the sqlite addon with the following results:
> >
Will the sqlite binary for android be released in the future?
-Original Message-
From: Programming [mailto:programming-boun...@forums.jsoftware.com] On Behalf
Of bill lam
Sent: Wednesday, March 8, 2017 17:09
To: Programming forum
Subject: Re: [Jprogramming] sqlite addon
binary is not
Sent: Wednesday, March 8, 2017 17:20
> To: Programming forum
> Subject: Re: [Jprogramming] sqlite addon
>
> I cannot duplicate this, and it works for me on Win10. Can you experiment a
> bit and give more info?
>
> What is your J version?
>
>JVERSION
> Engine: j
Chris,
My answers are inserted in your questions below:
-Original Message-
From: Programming [mailto:programming-boun...@forums.jsoftware.com] On Behalf
Of chris burke
Sent: Wednesday, March 8, 2017 17:20
To: Programming forum
Subject: Re: [Jprogramming] sqlite addon
I cannot
I cannot duplicate this, and it works for me on Win10. Can you experiment a
bit and give more info?
What is your J version? What is cder'' after the error? Do you get the
error after restarting J?
On Wed, Mar 8, 2017 at 2:04 PM, Tom Arneson wrote:
> I tried the sqlite addon with the following
binary is not available for android.
On 9 Mar, 2017 6:04 am, "Tom Arneson" wrote:
> I tried the sqlite addon with the following results:
>
>
>
> NB. PC running Windows10
>
> load'data/sqlite'
>
> getbin_psqlite_''
>
> getbin_psqlite_''
>
> Sqlite binary installed.
>
> db=: sqlopen_psqlite_ '~add
I tried the sqlite addon with the following results:
NB. PC running Windows10
load'data/sqlite'
getbin_psqlite_''
getbin_psqlite_''
Sqlite binary installed.
db=: sqlopen_psqlite_ '~addons/data/sqlite/db/sandp.db'
|domain error: cd
| SQLITE_OK~: sqlite3_open_v2 file;handle;flags;<<0
N
hat attempted the same SELECT query and it returned
>>>> data.
>>>>> My point being I dont think it is a database issue.
>>>>> By the way, since this was a test database it only had one table amd
>> two
>>>>> records, and was created using s
his was a test database it only had one table amd
> two
> > > > records, and was created using sqlite browser application.
> > > >
> > > > --- Original Message ---
> > > >
> > > > From: "bill lam"
> > > >
one table amd two
> > > records, and was created using sqlite browser application.
> > >
> > > --- Original Message ---
> > >
> > > From: "bill lam"
> > > Sent: November 27, 2014 6:42 PM
> > > To: "Programming forum&q
it only had one table amd two
> > records, and was created using sqlite browser application.
> >
> > --- Original Message ---
> >
> > From: "bill lam"
> > Sent: November 27, 2014 6:42 PM
> > To: "Programming forum"
> > Subject: Re: [J
database it only had one table amd two
> records, and was created using sqlite browser application.
>
> --- Original Message ---
>
> From: "bill lam"
> Sent: November 27, 2014 6:42 PM
> To: "Programming forum"
> Subject: Re: [Jprogramming] SQLITE with Mac
&
this was a test database it only had one table amd two
records, and was created using sqlite browser application.
--- Original Message ---
From: "bill lam"
Sent: November 27, 2014 6:42 PM
To: "Programming forum"
Subject: Re: [Jprogramming] SQLITE with Mac
Will the testdb wor
Will the testdb work if copied to linux and run there?
On Nov 27, 2014 3:41 PM, "Jon Hough" wrote:
>
> I got SQLITE working with J on Linux, but now I'm tryingon Mac (Yosemite,
> J803).I have a preexisting database which I'm trying to access.
> ch =: ddcon__db 'database=',(jpath '~/testdb') NB. n
I got SQLITE working with J on Linux, but now I'm tryingon Mac (Yosemite,
J803).I have a preexisting database which I'm trying to access.
ch =: ddcon__db 'database=',(jpath '~/testdb') NB. no error so far, database
exists in home directory.
query =: 'SELECT * FROM names' NB. this table name exis
Oh,Marc, thank you. This did the trick:
[ch=. ddcon__db 'database=',(jpath'~/j803/testdb')
I should read the wiki more carefully.
Thanks again,
Jon
> From: m...@0branch.com
> Date: Sat, 22 Nov 2014 19:25:29 +0530
> To: programm...@jsoftware.com
> Subject: Re:
Hi Jon,
Your connection string is wrong; please see
http://jsoftware.com/jwiki/JDD/Methods/Connect
Working example:
require'data/ddsqlite'
db=: ''conew'jddsqlite'
ddcon__db'database=',(jpath'~temp/test.db'),';nocreate=0'
4349166272
If you only want to access existing databases, you can
try add jpath to supply a real file path.
On Nov 22, 2014 4:50 PM, "Jon Hough" wrote:
> I am attempting to use the Sqlite addon (ddsqlite) with J and am
> struggling to get a db connection.
> Environment:Linux Ubuntu 14.x, J802/3Sqlite 3
>
> My code so far is:
>
> load 'data/ddsqlite'
>
>
>
>
> d
Sorry, that is a typo in the original question. I made sure the strings were
the same in the code.
--- Original Message ---
From: "Brian Schott"
Sent: November 22, 2014 9:44 PM
To: "Programming forum"
Subject: Re: [Jprogramming] Sqlite addon with J802/3
Jon,
This may
Jon,
This may be obvious, but your test fread and your ddcon__db strings are
different.
On Sat, Nov 22, 2014 at 3:50 AM, Jon Hough wrote:
> I am attempting to use the Sqlite addon (ddsqlite) with J and am
> struggling to get a db connection.
> Environment:Linux Ubuntu 14.x, J802/3Sqlite 3
>
> M
I am attempting to use the Sqlite addon (ddsqlite) with J and am struggling to
get a db connection.
Environment:Linux Ubuntu 14.x, J802/3Sqlite 3
My code so far is:
load 'data/ddsqlite'
db =: '' conew 'jddsqlite'
[ch=. ddcon__db '~/j803/testdb'
this returns -1. It seems it cannot find
Many thanks for that Bill!
On 28 August 2014 14:09, bill lam wrote:
> Please elaborate how the shader demo in qt demo of j802 failed.
>
It didn't! I have just seen it and it seems to work fine, Pleased about
that - at least I've got something to go on now.
> opengl 1.x had been decommitted.
Please elaborate how the shader demo in qt demo of j802 failed.
opengl 1.x had been decommitted.
ddsqlite was documented in jwiki, please use the search box.
No one maintains data/sqlite, so it was removed.
On Aug 28, 2014 8:42 PM, "Alex Giannakopoulos"
wrote:
> On 28 August 2014 13:26, Raul M
On 28 August 2014 13:26, Raul Miller wrote:
> Something that "works out of the box" and "linux" is unlikely given
> the current state of things.
>
Too true, too often...
Hope everything turns out OK.
--
For information about J f
Something that "works out of the box" and "linux" is unlikely given
the current state of things.
We are experiencing a rather massive attack on our computing
infrastructure (including the people involved) at the moment, on a
variety of levels of abstraction and it's really hard to anticipate
just
Thanks Raul. Yeah, OpenGL SORT OF worked for me under 7 too, can't
remember details, I got too frustrated and dumped the whole thing in
disgust, I seem to remember it was working (partially) under Linux32, OKish
under Windows64 (but I don't want to have to use Windows), and I think it
worked very
On Thu, Aug 28, 2014 at 7:23 AM, Alex Giannakopoulos
wrote:
> I have to say that one of my greatest frustrations with J is that a lot of
> good work of the past seems to get lost in the process of updates.
> E.g. I was really looking forward to doing some OpenGL work with J, yet
> this does not se
Does anyone know what the current state of play is with regard to SQLite
support?
The documentation under jwiki/Addons/data/sqlite is not valid anymore, and
PacMan only offers a data/ddsqlite, which however does not seed to be
documented anywhere.
I have to say that one of my greatest frustratio
46 matches
Mail list logo
