01:32 <meow> Hi. Does Sandstorm now offer a database app, like mysql, that I am just too much of a newbie to identify in the app market?

01:38 <monocyclist> irc newbie here: apologies. What is name of Sandstorm database app? If we don't have one, can a wonderful person ad one?

01:38 <monocyclist> add one

02:33 <kentonv> DanC, I think there's a trick where you can use the URL <host>/.sandstorm-token/<token>

02:33 <DanC> I saw that in the websockets section, I think

02:34 <kentonv> it was created for WebSockets but I think the code actually applies to both, unless I'm reading it wrong

02:34 <DanC> that JS at the edges stuff looks cool... is there any SES going on there? or just anything goes?

02:35 <kentonv> no SES, it's "just" the standard Service Worker API

02:35 <kentonv> we might find use for SES later on, in particular with apps, where you're installing third-party code into your web site

02:40 <crab> what is this "JS at the edges stuff"?

02:40 <kentonv> crab, https://blog.cloudflare.com/introducing-cloudflare-workers/

02:40 <kentonv> (my project at Cloudflare)

02:40 <DanC> https://blog.cloudflare.com/introducing-cloudflare-workers/

02:40 <DanC> yeah, a bit off topic; sorry. I was just reminded of it when I saw kentonv's name

02:44 <crab> oh, i thought it was something to do with sandstorm. sorry.

02:45 <kentonv> It's kind of like a much-less-ambitious Sandstorm in some ways

02:47 <crab> vx32! wow, i remember playing with that ages ago.

02:47 <crab> (yes, i know you're not using it, i just saw the mention in the blog post)

02:51 <mokomull> heh, vx32's a tab in my browser I've been meaning to actually read for some time now

02:51 <mokomull> I think it got a mention at Linux Plumbers this year, but I can't remember about what

03:13 <frigginglorious> anyone else haning out on a friday working on an SS app?

04:36 <ocdtrekkie> frigginglorious: What are you working on?

04:36 <ocdtrekkie> I am too tired to do anything requiring competence tonight.

04:36 <ocdtrekkie> I was gonna work on my automation software but I just can't.

04:48 <crab> what automation software?

04:48 <crab> i'm still trying to wrap my head around the changes required in wp-4.8 to run under sandstorm.

04:48 <ocdtrekkie> Well, I wrote my own software to run my home automation devices. So it was "home automation software".

04:49 <ocdtrekkie> But now I also run it in my car.

04:54 <ocdtrekkie> At some point I need to make or find an app to handle communication between them, which I want to run on Sandstorm hopefully. But I have procrastinated the heck out of figuring out how to make that work.

05:13 <frigginglorious> ocdtrekkie: that sounds kinda badass

05:13 <frigginglorious> what kinda IOT stuff are you hooking up?

05:14 <frigginglorious> does it control your car starting and stereo and shit too?

05:14 <ocdtrekkie> It sounds that way until you realize that I write it in Visual Basic and it crashes if I typo a command. :P

05:14 <frigginglorious> oh....

05:14 <frigginglorious> oh thats no good

05:14 <frigginglorious> I'm trying to work on this damn time-tracking app

05:15 <ocdtrekkie> In the house, it runs my Insteon hardware, so lights, switches, thermostat, etc. In the car it currently plays music, logs GPS, and I'm starting to work on navigation. (Interfacing with the car's CAN is something I want to work on but haven't had time to play with.)

05:15 <frigginglorious> for freelancers. its a glorified todo list that keeps time, and lets you generate an invoice at the end.

05:15 <ocdtrekkie> I bought an adapter so I can start with ZigBee and Z-Wave as well, but I don't have any devices that use either protocol right now, and not a really good reason to buy any at the moment.

05:16 <ocdtrekkie> frigginglorious: That's pretty cool. :) Though I loathe having to account for my time.

05:16 <frigginglorious> i feel ya :P

05:16 <ocdtrekkie> Work makes me do it, and while it's supposed to be done daily, usually I dig through my archive of sent and received emails at the end of the week and fabricate it on Friday at 4:30 PM.

05:16 <frigginglorious> haha. maybe you could use it :D

05:17 <ocdtrekkie> If it was something I did that was substantial, an email probably exists about it.

05:17 <ocdtrekkie> Perhaps! I play with every Sandstorm app someone posts, so at the very least, I will try it. :D

05:41 <xet7> ocdtrekkie: You could have in your car Python script that fetches required data from Wekan board: https://github.com/wekan/wekan/wiki/Wekan-Sandstorm-cards-to-CSV-using-Python

05:43 <ocdtrekkie> xet7: I honestly didn't know the API was exposed in the Sandstorm version!

05:43 <xet7> I got that script yesterday, I did not know earlier about it

05:44 <ocdtrekkie> It may be good to figure out some documentation for this.

05:44 <xet7> Yes.

05:44 <xet7> I have not tried it yet.

05:46 <ocdtrekkie> As for with my automation app, the flow that I foresee is probably not well tailored to Wekan. Basically, I want an ordinal queue of messages, with a source ID, and then either a destination ID. The actual command/information where is all text strings. And then for each app to pull any messages addressed to it (or broadcast) since it last retrieved.

05:47 <ocdtrekkie> The closest thing to build on top of for this would probably actually be EtherCalc. If only because laying out data in a straight-up table is my default visualization in my head.

05:47 <ocdtrekkie> But if there is a relatively reasonable way to send things to Wekan, I would want to do that too. Sometimes I want to send myself notes when I'm in the car or something.

05:48 <frigginglorious> xet7: this may be awesome.

05:48 <xet7> Wekan descriptions support markdown, there could be tables :D

05:49 <xet7> card description

05:50 <ocdtrekkie> xet7: Having several thousand rows in a Wekan card would be weird. :P

05:51 <ocdtrekkie> Sometimes I go overboard on logging. My car has over 270,000 records of logged GPS coords already. Because the receiver sends the computer the information every second, and I didn't have the heart to discard most of it.

05:51 <xet7> If it's more of database thing, someone could port nuBuilder to Sandstorm https://www.nubuilder.net/

05:52 <ocdtrekkie> Neat!

05:52 <ocdtrekkie> One of the apps I want to try to package for Sandstorm is Franchise: https://github.com/HVF/franchise

07:50 <xet7> What is my password in Wekan when I'm logged in with Google Auth ? I'm trying to login with curl to Wekan REST API.

08:16 <crab> franchise seems to be well-suited to sandstorm indeed.

08:41 <xet7> Ok I added more detailed issue about my question to https://github.com/wekan/wekan/issues/1279

16:45 <dwrensha> looks like alpha.sandstorm.io is down?

16:45 <dwrensha> Error: Error: remote exception: fork(): Cannot allocate memory

16:53 <ocdtrekkie> Looks up currently.

16:54 <dwrensha> can you open grains?

16:54 <ocdtrekkie> Interestingly, the first one I clicked on, yes, but that was the app index, which I assume is already running.

16:54 <ocdtrekkie> I could no open my own grains.

16:56 <ocdtrekkie> crab: Franchise currently is entirely client side though, no storage. I have a continual debate on how people would feel about a client-only app on Sandstorm. Would people be upset if they loaded up the grain, and then closed it, and the data was gone? Or would it be handy that they don't need to download it to their PC to run it or use someone else's web server for it?