Author Topic: Indexes Project  (Read 9427 times)

Offline nijineko

  • DnD Handbook Writer
  • ****
  • Posts: 2413
  • two strange quarks short of a graviton....
    • View Profile
    • TwinSeraphim
Re: Indexes Project
« Reply #20 on: February 26, 2013, 04:42:36 PM »
i don't think so, as my list has all powers from every source and every list.

maybe you have an older version? let's see if i can find the google drive link again for you....



edit: here you go. only slightly out of date. i'll try to upload the latest one sometime soon, i hope.
and here is the lastest version, i had some time, squeezed it in.

Quote
https://docs.google.com/file/d/0B5-fMljT1LYxWTVTSlNrblJOeG8/edit?usp=sharing
« Last Edit: February 26, 2013, 04:54:00 PM by nijineko »

Offline Psithief

  • Lurker
  • *
  • Posts: 35
  • Can I haz your PP?
    • View Profile
Re: Indexes Project
« Reply #21 on: February 27, 2013, 07:44:07 AM »
The link you posted isn't public, and no I'm not going to request access.
Quote
You need permission to access this item.
Updates
- Been fixing some data. The apostrophes went missing form all the Teamwork benefits.
- Put in basic soulmeld data from Magic of Incarnum, Dragon Magic and The Mind's Eye.
« Last Edit: February 27, 2013, 09:17:44 PM by Psithief »

Offline nijineko

  • DnD Handbook Writer
  • ****
  • Posts: 2413
  • two strange quarks short of a graviton....
    • View Profile
    • TwinSeraphim
Re: Indexes Project
« Reply #22 on: February 28, 2013, 01:15:11 AM »
that was... not intended. huh. i'll go figure out how to fix that. sorry about the mess up.

ah, i see what i did wrong. try this link, please:

https://docs.google.com/file/d/0B5-fMljT1LYxWTVTSlNrblJOeG8/edit?usp=sharing

Offline Psithief

  • Lurker
  • *
  • Posts: 35
  • Can I haz your PP?
    • View Profile
Re: Indexes Project
« Reply #23 on: March 15, 2013, 01:02:53 PM »
Sorting 12 thousand queried records with a merge sort
Chrome 25: 10 seconds
Firefox 19: 2 seconds

Damn, Gecko really murders WebKit here, probably because it has a heavy-duty JavaScript compiler.
I won't be happy until Chrome can sort faster.

Offline nijineko

  • DnD Handbook Writer
  • ****
  • Posts: 2413
  • two strange quarks short of a graviton....
    • View Profile
    • TwinSeraphim
Re: Indexes Project
« Reply #24 on: March 17, 2013, 11:42:25 AM »
so, was that link/content any better or at least useful?

Offline KicktheCAN

  • Lurker
  • *
  • Posts: 20
  • I'm new!
    • View Profile
Re: Indexes Project
« Reply #25 on: March 19, 2013, 08:50:38 PM »
If you want, I have everything from Dragon #309 to Dragon #359 in a database.

Offline Psithief

  • Lurker
  • *
  • Posts: 35
  • Can I haz your PP?
    • View Profile
Re: Indexes Project
« Reply #26 on: March 20, 2013, 02:31:23 AM »
so, was that link/content any better or at least useful?
No, it seems to be the same data. I chose not to import the 3.0 stuff at this point. Differentiating between editions will require more effort.
Thanks regardless, as I'm still using 6/7ths of your data.

If you want, I have everything from Dragon #309 to Dragon #359 in a database.
What kind of database?

Offline KicktheCAN

  • Lurker
  • *
  • Posts: 20
  • I'm new!
    • View Profile
Re: Indexes Project
« Reply #27 on: March 20, 2013, 02:31:34 PM »
It is just a normal MySQL database. I can export it to CSV or Excel or whatever format you want. The data has some html formatting in it and I had to reformat a couple of things (namely, I reformatted all of the variant character classes into ACFs).

To clarify, the database includes all feats, ACFs, spells, items, weapons, and armor from all 3.5 issues of Dragon Magazine as well as some assorted stuff from various books and web-enhancements. I have the prestige classes laid out in a document file but I haven't gotten around to setting up a table for that. I also have some of the monsters from Dragon Magazine but haven't gotten around to finishing that up.

Offline Psithief

  • Lurker
  • *
  • Posts: 35
  • Can I haz your PP?
    • View Profile
Re: Indexes Project
« Reply #28 on: March 21, 2013, 12:33:44 AM »
I would welcome that data. I'd prefer only  the tables that are complete. :)
At the moment CSV is the best option, but I could use the raw SQL dump if pressed.

Note:
Only a few more weeks until Firefox gets the <a download> attribute.

Offline nijineko

  • DnD Handbook Writer
  • ****
  • Posts: 2413
  • two strange quarks short of a graviton....
    • View Profile
    • TwinSeraphim
Re: Indexes Project
« Reply #29 on: March 24, 2013, 01:45:28 AM »
i too would welcome that data. may i have a copy? csv or excel works for me.

Offline Psithief

  • Lurker
  • *
  • Posts: 35
  • Can I haz your PP?
    • View Profile
Re: Indexes Project
« Reply #30 on: March 26, 2013, 02:19:39 AM »
One more week until Firefox supports local downloads.
When that comes I'll release a new, more robust version with:
  • pagination.
  • draggable / resizable popup windows.

Edit: Also, Chrome's extreme search delay appears to have vanished in the newly released Chrome 26.
« Last Edit: March 28, 2013, 09:00:01 AM by Psithief »

Offline Psithief

  • Lurker
  • *
  • Posts: 35
  • Can I haz your PP?
    • View Profile
Re: Indexes Project
« Reply #31 on: April 07, 2013, 08:05:26 AM »
Feature Changes
  • Download links appear as notifications in the top right
  • Advanced-usage buttons are hidden by default
  • Default search is now INTERSECT. (For example: alternate rogue searches for 'alternate AND rogue' instead of 'alternate OR rogue')
  • Firefox supports downloads!

Data changes
  • Added Alternate class features / substitution levels.

(Format for substitution levels isn't final)
  • Spells fixed for Spell Compendium, unrecognised spells removed.

New recommendation
Don't use the online version. Dropbox is not a reliable webhost except for individual files.
« Last Edit: April 08, 2013, 01:52:01 AM by Psithief »

Offline Psithief

  • Lurker
  • *
  • Posts: 35
  • Can I haz your PP?
    • View Profile
Re: Indexes Project
« Reply #32 on: April 28, 2013, 10:21:25 AM »
Feature changes
  • Individual results can be double-clicked to open an editor.
  • Some display bugs fixed.

Data changes
  • Added all the Domains I could find.