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 Alex Dembo on July 14, 2014 at 9:33am: Dear Nathan, Absolutely fantastic plugin! Thank you so much!
I was woundering if there is any reference i could find what is the source code to render the meshDB in a web browser like you did?

Comment by Nate Holland on January 6, 2014 at 11:15am: Thanks Nate, but now I'm getting the same System.InvalidCastException issue Erick described, did anyone find a solution? Mine occurs when I try to query the column list from a table. The tablelist and dblist components work fine.

Comment by Nathan Miller on January 3, 2014 at 8:51am: The mesh database tool generates the sql for pushing mesh geometry... but not much else. If you need something more custom, it is probably best to set up your own table. The build from 2013.12.29 on GitHub should have a component for table creation. Also you can always just used some good old SQL strings with the command component.

Comment by Nate Holland on January 2, 2014 at 5:39pm: Nate, I just upgraded to the build you posted about a week ago and don't see any components for creating tables or columns. Is it possible to create/store extra columns of data alongside meshes in a mesh database?

Comment by Erick Katzenstein on November 22, 2013 at 2:58pm: I'm having trouble getting the "select" query to work. When submitting the query in GH 9.0064, I get this error:

System.InvalidCastException: Conversion from type 'DBNull' to type 'String' is not valid.
at Microsoft.VisualBasic.CompilerServices.Conversions.ToString(Object Value)
at SlingshotDB.GHMYSQL_Query.SolveInstance(IGH_DataAccess DA)

Is anyone able to replicate this issue?

Comment by Erick Katzenstein on December 11, 2012 at 5:38pm: When I query the face vertices from a mesh database, it shifts the face list. For example, if I have a four vertex mesh, the databse will give me a face of T{1;2;3;4} when I really want T{0;1;2;3}. I'm subtracting 1 from each value right now to get the desired result, but I just wanted to let you know in case there are issues with other users.

Comment by Philipp on September 25, 2012 at 3:13am: is it possible to make a component to somehow send a Get command with custom query to any API

Comment by Nathan Miller on July 24, 2012 at 3:31pm: That voice is like silk... and the content is even better! ;)

Comment by Nathan Miller on June 7, 2012 at 3:09am: Hello Erick,

I have corrected the syntax issue with the new build (0.882)... see the new discussion above. 2 new components are also available for testing.

-Nate