(Ahmed Charfeddine) Websocket, SSL, Json, MySQL are all combined together with Push Framework to produce a C++ server that interacts with an Angularjs web front-end. The application shows the ease of implementing CRUD.
Other News
Histograms Tidbits
(Fahd Mirza) Make sure histograms exist on columns with uneven data distributions to ensure that the optimizer makes the best choice between indexes and table scans.
‘SELECT * FROM TABLE’ Runs Out Of TEMP Space
(Randolf Geist) Now that I’ve shown in the previous post in general that sometimes Parallel Execution plans might end up with unnecessary BUFFER SORT operations, let’s have a look what particular side effects are possible due to this.
Working with XML files and APEX – Part 3: Detail elements in a row with OUTER JOIN
(Tobias Arnhold) After I described how to successfully import XML files into an APEX application and gave some basic information about the analyzing of xml data.
Loading Large Flat Files Into MySQL With LOAD DATA INFILE and Pt-fifo-split
(Ike Walker) It’s easy to load multiple rows of data from a file into a MySQL table with a single LOAD DATA INFILE command, but if the file is over a certain size you may want to load it in multiple chunks. When I have a file with millions of lines I typically use pt-fifo-split to separate the file
Database Flashback — 2
(Hemant K Chitale) Continuing my series on Oracle Database Flashback.
Implementing High Availability and Disaster Recovery in IBM PureApplication Systems V2
(Venkata Gadepalli, Rajeev Gandhi, Addison Goering, Bertrand Portier, Stanley Shieh, Sung-Ik Son and Hendrik Van Run) This IBM Redbooks publication describes and demonstrates common, prescriptive scenarios for setting up disaster recovery for common workloads using IBM WebSphere Application Server,
SQL SERVER – What is the query used in sp_cursorfetch and FETCH API_CURSOR?
(Pinal Dave) In a recent debugging exercise for performance, one of my friend recently posted a question to me:
Node.js and Express.js sessions using MarkLogic 8
(Matt Pileggi) Most web applications benefit from the use of sessions. Apps built with Node.js are no different, and the Express server makes it very easy to apply middleware to help you manage your user’s sessions. In this quick start guide we will be using connect-marklogic, which is an implementa
MVC 5 with EF 6 in Visual Basic – Working With Files
(Mike Brind) This tutorial explores how to upload files in an ASP.NET MVC applications and how to use Entity Framework to store them in a database. It builds on a series of 12 that teach you how to build MVC 5 applications using Entity Framework for data access and Visual Basic.