 | | is the Peeron Database available?
|
|
Hi, I guess the inventories on the peeron site are database based. Is it possible to (nightly?) export the data and make it available for automated processing, the way the lugnet set reference is made available? I'd love to have the inventories (...) (24 years ago, 27-Mar-01, to lugnet.db.inv)
|
| |
| | Re: is the Peeron Database available?
|
|
(...) actually, the backend is completely custom written by me in perl, so there's no formal database to export... maybe one day I'll set up some sort of export function, that will take all the sets and dump them out into one big file... (24 years ago, 28-Mar-01, to lugnet.db.inv)
|
| |
| | Re: is the Peeron Database available?
|
|
(...) Why not use MySQL for the backend and then you can just export the tables? KL (24 years ago, 28-Mar-01, to lugnet.db.inv)
|
| |
| | Re: is the Peeron Database available?
|
|
(...) Oops ;-) (...) So how do you do updates if, say, the name of one piece changes or if you make a picture of a new part that you haven't had in your inventories up to that date? I tried the perl-and-textfile solution myself, but the task of (...) (24 years ago, 28-Mar-01, to lugnet.db.inv)
|
| |
| | Re: is the Peeron Database available?
|
|
(...) two reasons... first, MySQL wasn't installed on the server I set peeron up originally. and second, I need to learn a lot more SQL before I could use it effectivly... yes, it's in my Little Plan (tm), but need to find the time... :) Besides, (...) (24 years ago, 28-Mar-01, to lugnet.db.inv)
|
| |
| | Re: is the Peeron Database available?
|
|
(...) well, we update the master list, and I have a script that I can run against any number of inventories (or all of them), and update all the files automatically. (...) heh, it might defenitly be interesting to see another way of going at it, not (...) (24 years ago, 28-Mar-01, to lugnet.db.inv)
|
| |
| | Re: is the Peeron Database available?
|
|
(...) Have they added txn support yet? If not, make sure you're single threaded through any parts that modify the DB... ++Lar (24 years ago, 28-Mar-01, to lugnet.db.inv)
|
| |
| | Re: is the Peeron Database available?
|
|
(...) I see. That was enough for me at the beginning, too, but then I needed to re-order the lines in the inventory, too. I like to build by inventory files in the order they are in they are in the instructions, noting any extra parts, but the (...) (24 years ago, 28-Mar-01, to lugnet.db.inv)
|
| |
| | Re: is the Peeron Database available?
|
|
(...) Could I have a look at your scripts, too? Perhaps I could Then I could generate data that fits your system better. Regards, Hakan (24 years ago, 28-Mar-01, to lugnet.db.inv)
|
| |
| | Re: is the Peeron Database available?
|
|
(...) I just registered a new project at sourceforge and am waiting for final approval. After (I hope they do so ;-) ) the sourceforge admins approve the project, I'll start uploading my scripts. Regards, Hakan (24 years ago, 2-Apr-01, to lugnet.db.inv)
|
