Sessions
Wakanda is an open-source platform for developing business web and mobile applications in Javascript.
|
Look ma, “update DB to HTML5 using C++”, no...
by Alex Fabijanic
Agenda Not Set Yet
Room Not Assigned
Web landscape is changing rapidly; while AJA[X|J] was an improvement from the user interface responsiveness standpoint, the underlying data transport mechanism was still based on the request/response polling model. WebSocket specification removed the last obstacle for a seamless, event-driven data pushing from storage to the non-proprietary HTML5 user interface. Data transports naturally calling for event-driven model can now be implemented in a straightforward and standard fashion, improving performance by significantly lowering the network and web server overhead of the request/response model. Using POCO framework Net library, an HTTP server generating WebSocket HTML5 page will be built. Next, we’ll use POCO Data library to add SQL database communication capabilities to the server and establish a callback hook; the hook opens the path for database modifications to transparently trigger web page changes. The solution building blocks, Poco::Dynamic module for datatype erasure and Poco::Data::RowFormatter class for dynamic output formatting, will be explained in detail.
The session offers a practical solution to few acute problems – delivering data from storage over the network to the web end-user seamlessly, efficiently and independently from transported data types.
Alex is C++ Portable Components (POCO) Project Lead. He is professionally consulting on C++, POCO as well as developing steel manufacturing automation and process control software since 1998. He has master's degree in mechanical engineering from Faculty of Engineering (University of Rijeka, Croatia) and master's degree in software engineering from Citadel Graduate College in Charleston, South Carolina. Alex is also IEEE (Computer Society) Certified Software Development Professional. Alex Fabijanic Alex is C++ Portable Components (POCO) Project Lead. He is professionally consulting on... http://pocoproject.org /Presenter/2013/Alex-Fabijanic-8696 TN @aleskxf
9
Database
33
Web development
212
Web services
632
WebSocket
641
C++
|
||
|
Advanced Data Modeling with Entity Relationship...
by Mark Abramson
Agenda Not Set Yet
Room Not Assigned
In this session we will dive in deeper and work on specific challenges that crop up with database designs. This session will be interactive and will benefit from your specific database-related issues. Please hit me on Twitter (@mark__a) or use the "email the speaker" button with your challenges and we'll do our best to cover some approaches for you in the class. Need the basics? Check out my other session on "Intro to DB Design."
Mark Abramson is CEO of Forward Thought, Inc., a software company in Sausalito; co-founder of Medicine of Cycling and Vice Chairman of USA Cycling. A veteran of both early-stage startups and enterprise software projects, he has particular technical expertise in complex global supply chains for high-growth companies. He's also a dad, runs the Microsoft BizSparkSF group for Bay Area startups, collects antique woodworking machines and mentors on Lean Startup methods. Mark Abramson Mark Abramson is CEO of Forward Thought, Inc., a software company in Sausalito; co-founder... twitter.com/mark__a /Presenter/2013/Mark-Abramson-5443 CA @mark__a
9
Database
24
SQL Server
374
SQL Azure
599
SQL
|
||
|
Intro to Relational Database Design &...
by Mark Abramson
Agenda Not Set Yet
Room Not Assigned
Mark will cover the basics of designing and setting up a database schema. He'll define some common business scenarios, build out some tables, create relationships, and then demo usage, pitfalls, problems and design tradeoffs.
With so many database-driven projects for consumer desktop software applications, websites and enterprise software systems, the database design plays a crucial role in the success of your project.
You'll see real-life examples and issues such as:
Creating a new table;
Choosing data types;
Normalization (and when to denormalize);
Types of relationships;
Referential integrity;
Join/relationship tables;
1-to-many, many-to-many;
How to actually use these structures in your application;
While the examples will focus on SQL Server, the techniques and SQL code will work for virtually any SQL database. There will be discussion of various commercial and open source tools to streamline your work.
Mark Abramson is CEO of Forward Thought, Inc., a software company in Sausalito; co-founder of Medicine of Cycling and Vice Chairman of USA Cycling. A veteran of both early-stage startups and enterprise software projects, he has particular technical expertise in complex global supply chains for high-growth companies. He's also a dad, runs the Microsoft BizSparkSF group for Bay Area startups, collects antique woodworking machines and mentors on Lean Startup methods. Mark Abramson Mark Abramson is CEO of Forward Thought, Inc., a software company in Sausalito; co-founder... twitter.com/mark__a /Presenter/2013/Mark-Abramson-5443 CA @mark__a
9
Database
24
SQL Server
374
SQL Azure
599
SQL
|
