Re: [Jprogramming] Jd use cases

2018-05-17 Thread bill lam
I think Jd is not a good candidate for your requirement.
Jd does NOT support transaction, ie. no commit/rollback.

sqlite is more suitable for you, it has a small footprint, fast,
and is a regular sql database, and the most widely used 
database system.  I think it can even be faster than Postgresql.

Install and try addons/sqlite and documentation available in jwiki.

Чт, 17 мая 2018, S H Makdisi написал(а):
> I am a big fan of database work and am thus excited to try out Jd.
> However,I am just a hobbyist and dont operate on large data sets
> normally, nor work with numerical data as much as string.
> 
> I currently have a PostgreSQL database I use to track my library; some
> 1000 rows in all, with tables for works, editions, publishers, authors,
> sections, and the status of the books (owned, read), foreign keys
> linking all of them (mostly in edition), and then various views to
> represent the data in more clean terms. I never expect this database to
> grow beyond a few thousand rows in any table. I don't run much numerical
> processing on the data, it is mostly a structural project, rather than
> analytical. 
> 
> Scanning though the Wiki and some of the labs, I didn't find much on
> foreign keys and other kinds of SQL schema tools. 
> 
> Would Jd be a decent candidate for such a database?
> 
> --Stephen
> 
> --
> For information about J forums see http://www.jsoftware.com/forums.htm

-- 
regards,

GPG key 1024D/4434BAB3 2008-08-24
gpg --keyserver subkeys.pgp.net --recv-keys 4434BAB3
gpg --keyserver subkeys.pgp.net --armor --export 4434BAB3
--
For information about J forums see http://www.jsoftware.com/forums.htm

[Jprogramming] Jd use cases

2018-05-17 Thread S H Makdisi
I am a big fan of database work and am thus excited to try out Jd.
However,I am just a hobbyist and dont operate on large data sets
normally, nor work with numerical data as much as string.

I currently have a PostgreSQL database I use to track my library; some
1000 rows in all, with tables for works, editions, publishers, authors,
sections, and the status of the books (owned, read), foreign keys
linking all of them (mostly in edition), and then various views to
represent the data in more clean terms. I never expect this database to
grow beyond a few thousand rows in any table. I don't run much numerical
processing on the data, it is mostly a structural project, rather than
analytical. 

Scanning though the Wiki and some of the labs, I didn't find much on
foreign keys and other kinds of SQL schema tools. 

Would Jd be a decent candidate for such a database?

--Stephen

--
For information about J forums see http://www.jsoftware.com/forums.htm