LOGIN
Harsha Alva
86
Community Expert
Mechanical Engineer + Software Developer
 · MangaluruIndia
Share
Report
Get Link
IDEA

Steven Reubenstone, here is my idea for the Raspberry Pi server.

  1. 3.5" TFT screen to display the console output.
  2. 16x2 character LCD to show the latest event.
  3. Piezo buzzer to alert when new events are downloaded.

If the cost of the 3.5" TFT screen is a concern, we can do without it.

What do you think?

2 likes 
Like
Award Contribution
Steven Reubenstone
39
Community Expert
Mechanical Engineer & Tinkerer of Things. (Project Leader)
 · New YorkU.S.
Share
Report
Get Link

Just reviewed the entire repo and read me’s. Excellent work, but have a few questions. First i’ll respond here.

  • What is your goal with the Pi server for this project? I assume it is purely to create a more efficient/reliable device correct? As the current set up does work with Arduino?

  • The pi Server will cut out the need entirely for a web server middle man? So essentially the new design would be

Mixpanel <----------> Raspberry Pi Node Server and DB <-------------> LCD
                         

Also, does the Pi have wifi?

I am not really worried about any sound, as I see this being used on a desk. Thus, we wouldn’t want to annoy people with buzzing.

Like
0 like 
Award Contribution
Steven Reubenstone
39
Community Expert
Mechanical Engineer & Tinkerer of Things. (Project Leader)
 · New YorkU.S.
Share
Report
Get Link

Also one other question – our mixpanel structure is obviously different than what you’re using. I am going to need to know how to plug in our jql or request to mixpanel.

Can you show me the jql request you’re making? I am having trouble finding this.

Like
0 like 
Award Contribution
Harsha Alva
86
Community Expert
Mechanical Engineer + Software Developer
 · MangaluruIndia
Share
Report
Get Link

Hi Steven Reubenstone. Here are my replies to your queries.

What is your goal with the Pi server for this project? I assume it is purely to create a more efficient/reliable device correct? As the current set up does work with Arduino?

I want to implement this configuration. So the RPi will download Mixpanel data and will display it on its LCD. Plus, it’ll also act as a server for nearby Arduino/NodeMcu clients.
Basically, it’s a replacement for a PC running Node.

Mixpanel <----------> Raspberry Pi Node Server and DB <-------------> Arduino/NodeMcu
                                  +                                         +
                           LCD + (buzzer)	                           LCD
Like
0 like 
Award Contribution
Harsha Alva
86
Community Expert
Mechanical Engineer + Software Developer
 · MangaluruIndia
Share
Report
Get Link

Also one other question – our mixpanel structure is obviously different than what you’re using. I am going to need to know how to plug in our jql or request to mixpanel.
Can you show me the jql request you’re making? I am having trouble finding this.

  1. I’ve updated the README to show how that can be done. In the Project README, please read sections 1-3 under Important Stuff.
    The schema for tracking Mixpanel events and how downloaded events are stored in the database are shown there.

 

  1. I’m actually using the Mixpanel REST API instead of JQL. It is much simpler.
    The URL to download Mixpanel data, with constraints, is generated at function mixpanel.getMpRequestUrl() in Node_Server\mixpanel.js (line 36)
    Data from Mixpanel is downloaded by the function mixpanel.getMpData() in Node_Server\mixpanel.js (line 67)
    You also need to change the corresponding database schema in Node_Server\db.js (line 43)

If you want me to use the same Mixpanel schema/structure that you are using, please send me the event names and properties that you use.

Like
1 like 
Award Contribution
NYSC MEMBER
 · ShiroroNigeria
Share
Report
Get Link

please can some one confirm to me if this if statement is correct using rtc module
if (now.hour() == 7 && now.minute() == 50 && now.second() == 0){

}
I actually want to using time to automate a program

Like
1 like 
Award Contribution
Leave a reply...
DISCOVER
CHAT
ALERTS
DISCUSSIONS
FEED
New Post
Start Project
Online Users
Share Link
Help