Slingshot!

Information

Slingshot! is an Open Source plug-in for connecting Grasshopper to relational databases

Slingshot! features collection of components for reading, writing, and managing relational database systems using SQL.

Website: http://wiki.theprovingground.org/slingshot
Members: 176
Latest Activity: Sep 8, 2023

Querying a Mesh

Queries are used to progressively assemble a mesh within Grasshopper using information stored in MySQL database tables on a remote computer.

Visualize the Database using a Web Browser

A Grasshopper model being generated and visualized in Google Chrome.

Search a Genome Database

Store iterations from Galapagos to search through alternatives.

More videos and tutorials are available at the Slingshot! Wiki.....

Discussion Forum

Problem with connection 2 - the mission 1 Reply

Hi!I'm using an old version of Slingshot for quite while. In my definition, I access a remote PostgreSQL database via ODBC Driver. Consequently, I use the ODBC query component. Since this version (of…Continue

Tags: postgresql, connectionproblem, slingshot

Started by eugênio moreira. Last reply by naysok Sep 8, 2018.

SQLite - how to connect to Slingshot?

Hi Everyone This might be an easy one for someone - I'm just a little bit new to this.Just wondering if someone could provide some guidance on how to set up Slingshot to work with SQLite?The…Continue

Started by David Schwarzman Apr 12, 2018.

Slingshot Reading Excel 1 Reply

Hi, I'm trying to use the Slingshot from the updated installer (64bit) to read an excel file (.xlsx). I'm also using Office 2016 64bit. But I got errors like these: System.NullReferenceException:…Continue

Tags: excel, slingshot

Started by David Chen. Last reply by Sean Carr Mar 6, 2018.

How to deal with Twitter node? 8 Replies

Maybe I just cant find the relevant information but how to decode this search result?how,…Continue

Started by Philipp. Last reply by book learnin Oct 26, 2017.

View All

News From the Development Site

Comment Wall

Comment

You need to be a member of Slingshot! to add comments!

Comment by Nathan Miller on June 6, 2012 at 3:17pm: Erick,

Since you are just using MySQL, see if you get the same error with version 0.82 available on Food4Rhino. http://www.food4rhino.com/project/slingshot

The SQL syntax for that component in that version seems to be correct.

I was trying out some vertex color in the new version and must have forgotten to circle back before releasing v0.88... sloppy work on my part. I will correct in the next release. For now, stick with v0.82 if you need that component.

-Nate

Comment by Erick Katzenstein on June 6, 2012 at 3:06pm: Thanks for looking into this. I'm using the most recent version of Slingshot and MySQL.

Comment by Nathan Miller on June 6, 2012 at 2:08pm: Hello Erick,

I just took a look and it might have to do with the INSERT statement for the vertices is expecting a 'color' value for that column... which is not being provided with the values. I tested the component on my end before release so I will verify if this is, indeed, the problem.

Can I ask if you are using the most recent version or an older one? I'll add this fix to my list for my next build.

-Nathan

Comment by Erick Katzenstein on June 6, 2012 at 12:30pm: Nathan, thanks for all your hard work.

I'm having trouble with the Create Mesh Database component. When I insert a mesh (basic mesh sphere), and put this into the command line, I get this error:

MySql.Data.MySqlClient.MySqlException (0x80004005): Column count doesn't match value count at row 1

I checked the mySQL database and the table seems to log faces but there are not values for the vertices. Any suggestions?

Comment by Simon Moreau on May 30, 2012 at 1:08am: Hello

I have found a syntax error in the SQL Code of the Create Point Database component. The closing brackets of the CREATE TABLE line seems to be missing (In red on the following picture).

Comment by Pedro Arrobas da Silva on May 13, 2012 at 4:08pm: Hello Toussaint,

I did it with a ODBC connection to a postgreSQL server. So yes, it is possible. You have to store the shape file into the database and then convert the geometry from WKB to text, so that grasshopper can draw the polygons.

Comment by Toussaint Jimenez Rojas on May 7, 2012 at 8:30pm: Nathan its posible to link any GIS to GH with Slingshot, the GIS its in Shape Format File just Guess ?

Comment by Nathan Miller on January 18, 2012 at 9:45pm: Site is back up... here is the Twitter component engaged in some opposition...!

Comment by Nathan Miller on January 18, 2012 at 12:06pm: The Slingshot! development wiki (along with my other pages) have gone into blackout mode in protest of SOPA and PIPA. Sorry for any inconvenience... but this is important. Learn what this is all about.

Comment by Nathan Miller on January 8, 2012 at 1:17am: Greetings,

I have created a page for Slingshot! documentation and tutorials... It is still a work-in-progress but hopefully it is information new users will find helpful.

http://slingshot-dev.wikidot.com/tutorials