I would like to invite you to attend one or two events on February 2nd: Analyzing Twitter Social Data using Scala and Akka Actors and Social Media Metrics using SQL Engines.
- 2:00 PM Doors open
- 2:30 PM Hackaton — Analyzing Twitter Social Data using Scala and Akka Actors
- 5:00 PM Beer & Pizza, sponsored by Seevibes
- 6:30 PM Workshop — Social Media Metrics using SQL Engines
- 9:00 PM Socializing
The event will be at the Notman House, 51 Sherbrooke W. We have a limited number of places available, so be sure to reserve your seat now. There are two events, both are free to attend, and both are bilingual French and English.
- Reserve for Analyzing Twitter Social Data using Scala and Akka Actors
- Reserve for Social Media Metrics using SQL Engines
Before you come in, please be sure to follow these instructions to get you started:
The Scala Hackaton is an event where you’ll build whatever you wish: word counter, word frequency, hashtag frequency, etc. You get to choose. There will be people more familiar with Scala and Akka at the event which can help you. The first 30 minutes of the event will be reserved for a quick introduction to Scala.
- Clone the scala-hackaton Git repository, or download a ZIP
- In the repository / project, run
mvn exec:java -Dexec.mainClass=seevibes.HelloActor
The two Maven steps are to download all necessary dependencies. If you don’t, you’ll lose a lot of time at the event downloading your dependencies.
If you are unfamiliar with Java and Scala, I strongly recommend you use an IDE, which will help with code completion and syntax awareness. I happen to prefer JetBrains’ IDEA, but this is like Vim vs Emacs. You can use Eclipse if you prefer. If you use Eclipse, be sure to use the Scala IDE extension. In the case of IDEA, download and install the Scala plugin.
If you have any issues, please email me, François Beausoleil, and I’ll help you out. I’ll post updates to this page if common errors pop up.
The SQL workshop will be a series of directed examples:
1. I will present a problem, a report or a question we want answered, and some details on how you can accomplish the goal;
2. You will answer the question with the knowledge you have;
3. I’ll ask people to present their solutions;
4. I’ll present my solution and discuss specifics
I have 6 exercises planned out, from 15 to 45 minutes each. The topics range from indexing to joining to using intersections and unions and ending with windowing functions. The workshop is for people who wish to learn more about SQL and how to more effectively use thecapabilites of their favorite SQL engines.
- Install PostgreSQL 9.1 (latest is currently 9.1.2)
- Load this PostgreSQL database dump svworkshop.sql.bz2 (315 MiB) in your cluster using the following command:
1 bzcat svworkshop.sql.bz2 | psql
The dump file expects to create a new database named
svworkshop using your default user.
- Familiarize yourself with the entity-relationship diagram (PDF) of the dump
Hope to see you there!