Grasshopper

algorithmic modeling for Rhino

Database Plugin GHEloqueraDB v0.1 available for download



GHEloqueraDB  v0.1


i just finished v 0.1 of my database plugin for grasshopper. it might be helpful for all of you who are parsing txt files like i did. i use eloquera (http://eloquera.com/), which is an embeddable open source object database like the more popular db4o.



at this time the included components can:
- write data to an eloquera desktop database
- read data to from an eloquera desktop database
- read the stored item.origin Ids from all groupmembers
- execute a simple sql query
- backup the database
- open a stored database

installation:
copy all files in the components directory. (GHEloqueraDB.gha + 4 eloquera files)

the database is stored in "c:\grasshopper_general.eq", the backups are stored in "c:\" too.



the simple example shows how to work with the components.

i hope some of you find these components as useful as i do,
matthias standfest


Views: 1368

Attachments:

Replies to This Discussion

Permalink Reply by Giulio Piacentino on October 31, 2010 at 3:40pm
Wow this a good idea!
I'll install it as soon as I can. Thank you for sharing this.

Can you explain a little more if the write components perform serialization of all types to database. How should they be used?

Which version of Grasshopper did you compile GHEloqueraDB with?

Thanks again,

- Giulio
_____________________
giulio@mcneel.com
McNeel Europe, Barcelona
Permalink Reply by David Rutten on October 31, 2010 at 4:09pm
Well done Matthias. I'm sure a lot of people will find this very useful.

--
David Rutten
david@mcneel.com
Seattle, WA
Permalink Reply by Benjamin Golder on October 31, 2010 at 6:02pm
WOW. Very cool. What an extremely useful tool!

Thank you!
Permalink Reply by Dimitrie Stefanescu @idid on October 31, 2010 at 6:09pm
sweet!
Permalink Reply by Luis Fraguada on October 31, 2010 at 6:37pm
Super Cool! Any demos or example files (Besides the one shown...meaning an example showing an application)? Looking forward to installing this!
Permalink Reply by nirulfen on October 31, 2010 at 10:20pm
Thx for sharing!
Permalink Reply by Philipp on November 1, 2010 at 1:14am
wow.
Can you explain what can we do wuth this?
Permalink Reply by David Stasiuk on November 1, 2010 at 4:53am
Great stuff, Matthias! Thank you so much for sharing. I think that this tool could be incredibly useful.

I am curious...from the little tinkering I've done with it, it appears that each "write database" component will take a single group name assignment. Is this correct? Or is it possible to assign different group names to multiple objects? It also looks like the simple SQL query operates for selecting items by Group ID. I tried executing some Count, Group By and Order By commands according to the Eloquera directions, but they didn't seem to work. Is it possible that I'm using the wrong syntax, or are these functions not supported? I'm so sorry to ask so many questions...I appreciate your work, and can only imagine how much time you've put into this tool. I'm just really excited about the prospect of having a really robust tool for reading from and writing to a database system that also allows for sophisticated SQL operation.

thanks again!
Permalink Reply by Ángel Linares on November 1, 2010 at 6:14am
Wohooo!! Great plugin man :) Thanks for sharing.

Best regards.

Ángel Linares.
Permalink Reply by Matthias Standfest on November 1, 2010 at 9:15am
i'm glad you like it!
this winter i'm working on my master thesis on the theoretical background of multiagent systems and collaborative design networks in architecture. the database part is just a spin off of the whole work, i hope to publish the rest in january. for this components i plan to:
1) improve sql capability, data should be stored in it's native type
2) build network / multiuser access to the database

first of all i added another example on how to handle the components, and some info on how the objects are stored. but in detail:

@giulio
i used gh 8.01, rhino 4 sr8, eloquera 3.0.0.21, c# .net 3.5. i', not sure what "serialization" means in this context, but the objects (GH_line, GH_Point) are stored as Listand also read this way, without converting into sth else.

@luis
i don't have any example of my actual work i can show you yet, my university is very restrictive in this matter. i work on a multiagent system and needed a db backend to read my environment from, but i'm sure you can use the component for any type of animation. (the agent code and the other modifications are going to be published in january.)

@david
in this version you cant assign multiple group names to the component, i consider it for future improvements. other sql query code is supported, because of the storing as object and not e.g. GH_Line many of the tools are still useless. you may apply this code on the group, type or id string. please see my example for further information.

Attachments:
Permalink Reply by Miguel Vidal on November 1, 2010 at 9:33am
bravo!
been waiting a lot of time for this

thanks for sharing!

RSS

About

Scott Davidson created this Ning Network.

Translate

Search

Photos

  • Add Photos
  • View All

Videos

  • Add Videos
  • View All

© 2024   Created by Scott Davidson.   Powered by

Badges  |  Report an Issue  |  Terms of Service