Skip to content

Software Development News: .NET, Java, PHP, Ruby, Agile, Databases, SOA, JavaScript, Open Source

Methods & Tools

Subscribe to Methods & Tools
if you are not afraid to read more than one page to be a smarter software developer, software tester or project manager!

Open Source

PostgreSQL 9.5 RC1 Released

PostgreSQL News - Fri, 12/18/2015 - 01:00

The PostgreSQL Global Development Group announces that the first release candidate is available for download. This release should fix all outstanding issues with PostgreSQL 9.5, and be identical to the final release, pending bug fixes. All users intending to upgrade to PostgreSQL 9.5 should download and try PostgreSQL 9.5 RC1 now.

Changes Since Beta2

All outstanding issues and known bugs in version 9.5 have been fixed in this release. As such, any issues you encounter are new and should be reported to us. Fixes since Beta2 include:

  • Fixed issues in multxact truncation behavior
  • Prevent incorrect trigger invocation in UPSERT
  • Fixed password handling by multiprocess vacuumdb
  • Made Foreign join pushdown work with EvalPlanQual
  • Fixed bug in track_commit_timestamp
  • Drop policies with objects during DROP OWNED
  • Make pg_rewind work if both servers are on the same timeline

If you reported an issue while testing PostgreSQL 9.5, please download RC1 and test whether that issue has been fixed. If you have not yet tested version 9.5, now is the time for you to help out PostgreSQL development.

Release Schedule

This is the first release candidate of 9.5, indicating that it is expected to be identical to the final release. If new major issues are found, the PostgreSQL project will release additional release candidates. Otherwise, 9.5.0 will be released in early January. For more information, and suggestions on how to test the release candidate, see the Beta Testing page.

Full documentation and release notes of the new version is available online and also installs with PostgreSQL. Also see the What's New page for details on some features.

Links
Categories: Database, Open Source

Eclipse Newsletter - Happy Holidays

Eclipse News - Thu, 12/17/2015 - 15:31
This is your chance to share what you think about the Eclipse Newsletter. Win one of three $100 Amazon gift cards!
Categories: Open Source

COFIQ - Get Your SOA Act Together

Date Created: December 17, 2015 - 05:34Date Updated: February 3, 2016 - 14:27Submitted by: Ad Min

COFIQ allows service portfolio management the easy way. No cumbersome XML/XSD/WSDL/JSON-SCHEMA manipulation. COFIQ generates these for you from a single repository with vocabularies, message and service definitions. Ofcourse available as SAAS solution.

COFIQ guards interoperability and recognizes obsolete services, triggering you to define new versions and determining the impact of vocabulary changes before committing them.

COGIQ generates single file WSDL's (1.1) and/or JSON HYPER SCHEMA (!!!NEW!!!) for direct tool consumption. These can be imported into Eclipse for subsequent generation of Java stubs and skeletons, making it a loosely coupled component in your Eclipse webservice development process. Other development tools that can import WSDL's or JSON HYPER SCHEMA's are supported also ofcourse.

For human consumption COFIQ uses its user interface and PDF reports allowing you to capture and review semantics and syntax precisely.

Use the free 14 day trial. And don't hesitate to contact us for any question. Our SOA approach is focussed on keeping things as simple as possible and really reaping the benefits of SOA that have escaped many of us.

2016 Februari 3: NEW!!! Support for JSON HYPER SCHEMA.

Categories: Open Source

EclipseCon NA 2016 - Accepted Talks

Eclipse News - Wed, 12/16/2015 - 15:22
The program committee has carefully selected the talks for EclipseCon NA 2016, March 7-10 in Reston, VA.
Categories: Open Source

“Community Choice” Project of the Month Vote – February 2016

SourceForge.net: Front page news - Wed, 12/16/2015 - 07:08

The vote for February 2016 Community Choice SourceForge Project of the Month is now available, and will run until January 15, 2016 12:00 UTC.


UltraDefrag

UltraDefrag is a disk defragmenter for Windows, which supports defragmentation of locked system files by running during the boot process. It is easy to use, without any complicated scripting or a huge load of configuration settings. You can filter the files processed by size, number of fragments, file name, and path. You can also terminate the process early by specifying an execution time limit.
[ Download UltraDefrag ]


K-Meleon

K-Meleon is a fast and customizable web browser that can be used instead of Internet Explorer on Windows. Powered by the same Gecko engine as the Firefox and Mozilla browsers, K-Meleon provides users with a secure browsing experience.
[ Download K-Meleon ]


NamelessROM

The main goal of NamelessRom is to provide quality development for Android devices, phones, and tablets alike. NamelessRom developers are available nearly 24/7 and respond to bug reports and feature requests almost instantly.
[ Download NamelessROM ]


Roundcube Webmail

Roundcube Webmail is a browser-based, multilingual IMAP client, with an application-like user interface. Roundcube provides the full functionality you’d expect from an email client, including MIME support, address book, folder manipulation, message searching, and spell check. Roundcube is written in PHP and JavaScript.
[ Download Roundcube Webmail ]


MediaPortal

MediaPortal turns your PC into a very advanced MediaCenter and HTPC. It allows you to listen to your favorite music and radio, watch and store your videos and DVDs, view, schedule and record live TV as a digital video recorder, and much more.
[ Download MediaPortal ]


Equalizer APO

Equalizer APO is a parametric/graphic equalizer for Windows. It is implemented as an Audio Processing Object (APO) for the system effect infrastructure introduced with Windows Vista. It features a virtually unlimited number of filters, works on any number of channels, has low CPU usage, has a modular graphical user interface, and is very low latency which makes it well suited for interactive applications.
[ Download Equalizer APO ]


Bodhi Linux

Bodhi is a minimalistic, enlightened, Linux desktop.
[ Download Bodhi Linux ]


SMPlayer

SMPlayer is a media player for Windows and Linux, with built-in codecs that can also play and download Youtube videos. It also remembers the settings of all files you play, so you can leave a video and later resume at the same point you left it, and with the same settings: audio track, subtitles, volume, etc. SMPlayer also features the ability to download subtitles.
[ Download SMPlayer ]


fldigi

Fldigi is a modem program for most of the digital modes used by radio amateurs today: CW, PSK, MFSK, RTTY, Hell, DominoEX, Olivia, and Throb are all supported. It can help calibrate a sound card to a time signal and do frequency measurement tests.
[ Download fldigi ]

Categories: Open Source

PostgreSQL PHP Generator 15.12 released

PostgreSQL News - Wed, 12/16/2015 - 01:00

SQL Maestro Group announces the release of PostgreSQL PHP Generator 15.12, a powerful GUI frontend for Windows that allows you to generate feature-rich CRUD web applications for your PostgreSQL database.

The new version is immediately available at
http://www.sqlmaestro.com/products/postgresql/phpgenerator/.

Online demo: http://demo.sqlmaestro.com/.

Top 15 new features:
  1. New modern look and feel.
  2. 100% responsive design.
  3. PHP 7 support.
  4. Top side drop-down menus.
  5. Enhanced Filter Builder.
  6. Multi-column sorting.
  7. Keyboard shortcuts.
  8. A number of new and updated controls.
  9. 18 color themes.
  10. Font-based icons.
  11. Event management enhancements.
  12. Less preprocessor syntax for user-defined styles.
  13. HTML filter.
  14. New and updated data access drivers.
  15. PHP Generator UI improvements.

There are also some other useful things. Full press release is available at the SQL Maestro Group website.

Categories: Database, Open Source

MusicBrainz’ Gelato Summit 2015

Google Open Source Blog - Tue, 12/15/2015 - 23:35
MusicBrainz is an open music encyclopedia maintained by a global community of users, collects metadata and makes it available to the public. The team just wrapped up their annual summit in Barcelona, sponsored in part by the Google Open Source Programs Office.
From October 30th through November 1st, the MusicBrainz Summit 15 took place in Barcelona, Spain. All of the MetaBrainz employees were there in addition to a handful of contributors from our community — two lead developers of BookBrainz, a long-time volunteer developer on MusicBrainz and the lead of AcousticBrainz. Between us, we represented seven countries and nine languages.Talking around the table.
We managed to cover a lot of ground on serious topics including how to avoid data/MBID loss, how to version data, dealing with record labels, unresolved style issues and integrating the various Brainz projects a bit better. The official notes for the summit are stored in a public Google Docs document. Feel free to read through and contribute your own comments.
Our group has discussed releasing the translations of MusicBrainz for years — but this time we actually did it! It is now available in English, German, Dutch and French. At some point in the not-too-distant future we will also enable the translation of all of our documentation.
We also used this time together to talk about how and why MBIDs get lost and what we can do to prevent this. As part of this discussion, we decided to make more edits “autoedits” for all users. The goal is to have shorter queue of open edits (although there has been a significant drop in open edits since mid November) but also to avoid losing MBIDs once they have been generated. More in depth discussion of our reasoning and some of the community’s response can be seen in the server release blog post and its comments.
Most of our time was productive, but you cannot visit a city like Barcelona and not enjoy the surroundings. In addition to the more obvious local sights, we were introduced to an amazing gelato place within walking distance from our summit. It’s definitely worth a visit! A MusicBrainz summit would not be complete without copious amounts of chocolate. A huge thank you to our attendees for supplying Ritter Sport direct from the factory!
Finally, a big thank you to Google and Spotify for helping to fund this meeting. It would have been a lot harder to bring all these people together from around the world without their (continued, no less!) support. Here’s to 2016 and summit 16.
By Frederik “Freso” Sandberg, MetaBrainz Community Manager
Categories: Open Source

Dojo Winter 2015-2016 Events

The Dojo Toolkit - Announcements - Tue, 12/15/2015 - 13:39

There are a number of Dojo events this winter Some of these events are still tentative, so we’ll add links once they are confirmed. We hope to meet you at one of these events. Let us know if there’s an event you would like to host in your area.

Conferences

Conferences we’re planning to attend and/or deliver talks.

  • HIMSS, Las Vegas, February 29 – March 4, 2016
  • Esri DevSummit, Palm Springs, March 7-11, 2016
Meetups
  • CMV, Palm Springs, March 9, 2016
  • London Ajax, London, March 14, 2016
Training Workshops

Let us know if you’re speaking at an event, and we’ll add you to our listings!

Categories: Open Source, RIA

Dojo Recap – Week Ending December 11, 2015

The Dojo Toolkit - Announcements - Tue, 12/15/2015 - 12:45
Recently in Dojo 1.x

Last week we made one enhancement to Dojo 1.x:

DojoX Up next in Dojo 1.x

We are starting to put together a release plan for 1.11, and updated point releases for earlier versions of Dojo. We have about 30 more issues to resolve, and then we’ll be ready for the 1.11 release! The main things we are considering for 1.11 are as follows:

Recently in Dojo 2

We’re making further progress on Dojo 2 as well. Last week our focus was on Compose, core, and parser:

Compose core parser Upcoming Dojo 2 efforts

Here we’ve identified a few of our aspirations for near future. This week in Dojo 2, we have more code reviews to complete and pull requests to land. If you’re interested in helping out in these areas, or other parts of Dojo 2, just let us know, either in the comments or on IRC.

  • Review and improve the Compose and parser prototypes
  • Define and refine the approach to widgets and application architecture for Dojo 2
  • Continue to review and land code for Core, Crypto, DOM, dstore, i18n, Loader, and Routing

We are also actively working on the following:

Core package-template parser

Over the last couple of months we’ve also been working on evaluating other projects out there to determine how they can benefit or inspire our efforts, or offer possible integration options. We’ve also been working on a reference application that we will be using to document and validate the APIs in Dojo 2. Work on these efforts will continue as we work to refine the vision and approach for Dojo 2.

Weekly IRC meeting

As usual, our weekly IRC meeting is on irc.freenode.net #dojo-meeting at 9am Pacific time on Tuesday.

View the Dojo weekly meeting logs

This week’s agenda
  • 1.11 release plan (we’re aiming for January for the release)
  • Discuss open 2.x challenges
Thanks!

The Dojo 2 loader, core, and dom are near an alpha state! Progress is being made on routing, crypto, i18, dstore, Compose and parser. Please let us know if you plan to work on any features, or would like to get involved, so we can collaborate.

Categories: Open Source, RIA

Projects of the Week, December 14, 2015

SourceForge.net: Front page news - Mon, 12/14/2015 - 07:08

Here are the featured projects for the week, which appear on the front page of SourceForge.net:


NetHack

NetHack is a single player dungeon exploration game that runs on a wide variety of computer systems, with a range of graphical and text interfaces all using the same game engine. Unlike many other Dungeons & Dragons inspired games, the emphasis in NetHack is on discovering the detail of the dungeon, instead of simply killing everything in sight. Each game presents a different landscape to explore, as the random number generator provides an essentially unlimited number of variations of the dungeon and its denizens.
[ Download NetHack ]


NSIS: Nullsoft Scriptable Install System

NSIS, Nullsoft Scriptable Install System, is a professional Open Source system to create Windows installers. It is designed to be as small and flexible as possible, and therefore is very suitable for internet distribution. NSIS is script-based and allows you to create the logic to handle even the most complex installation tasks. Many plug-ins and scripts are already available: you can create web installers, communicate with Windows and other software components, install or update shared components, and more.
[ Download NSIS: Nullsoft Scriptable Install System ]


NamelessROM

The main goal of NamelessRom is to provide quality development for Android devices, phones, and tablets alike. NamelessRom developers are available nearly 24/7 and respond to bug reports and feature requests almost instantly.
[ Download NamelessROM ]


SQuirreL SQL Client

SQuirreL SQL Client is a graphical SQL client written in Java that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands, and more.
[ Download SQuirreL SQL Client ]


SMPlayer

SMPlayer is a free media player for Windows and Linux, with built-in codecs that can also play and download Youtube videos. It also remembers the settings of all files you play, so you can leave a video and later resume at the same point you left it, and with the same settings: audio track, subtitles, volume, etc. SMPlayer also features the ability to play Youtube videos or download subtitles.
[ Download SMPlayer ]


Maxima — GPL CAS based on DOE-MACSYMA

Maxima is a computer algebra system written in Common Lisp, and is comparable to commercial systems like Mathematica and Maple. It emphasizes symbolic mathematical computation: algebra, trigonometry, calculus, and much more. Maxima has user-friendly front-ends, an on-line manual, plotting commands, and numerical libraries. Users can write programs in its native programming language, and many have contributed useful packages in a variety of areas over the decades.
[ Download Maxima — GPL CAS based on DOE-MACSYMA ]


The OpenGL Extension Wrangler Library

The OpenGL Extension Wrangler Library is a simple tool that helps C/C++ developers initialize extensions and write portable applications. GLEW currently supports a variety of operating systems, including Windows, Linux, Darwin, Irix, and Solaris.
[ Download The OpenGL Extension Wrangler Library ]


Arch Bang

ArchBang is a simple GNU/Linux distribution which provides you with a lightweight Arch Linux system combined with the OpenBox window manager. It is suitable for both desktop and portable systems. ArchBang is fast, stable, and always up to date.
[ Download Arch Bang ]


Q4OS

Q4OS is a fast and powerful operating system based on the latest technologies while offering a traditional desktop user interface. We focus on security, reliability, long-term stability, and conservative integration of verified new features. System is distinguished by speed and very low hardware requirements, runs great on brand new machines as well as legacy computers. It is also very applicable for virtualization and cloud computing.
[ Download Q4OS ]

Categories: Open Source

Raising Sweet C++ Cane for Well-Dressed Animals

Google Open Source Blog - Thu, 12/10/2015 - 00:30
To celebrate the holiday season at Fun Propulsion Labs, we're trading our sushi mats and baking pans for candy canes and snowballs. Please join us for a special holiday-themed version of Pie Noon and Zooshi! Zooshi and Pie Noon are open source, cross-platform games built from a suite of libraries that eager C++ developers can use to build their own projects.

You can download and run Zooshi's Santa mode on Google Play and find the latest open source release on our GitHub page. The holiday version of Pie Noon is available on Google Play as Snowdown in Santa Tracker and on our GitHub page. Happy Holidays!

By Stewart Miles, Fun Propulsion Labs*

*Fun Propulsion Labs is a team within Google that's dedicated to advancing gaming on Android and other platforms.
Categories: Open Source

Dojo Recap – Week Ending December 4, 2015

The Dojo Toolkit - Announcements - Tue, 12/08/2015 - 21:07
Recently in Dojo 1.x

Recently we fixed the following issues in Dojo 1.x:

Dojo Dijit DojoX util themes Up next in Dojo 1.x

We are starting to put together a release plan for 1.11, and updated point releases for earlier versions of Dojo. We have about 30 more issues to resolve, and then we’ll be ready for the 1.11 release! The main things we are considering for 1.11 are as follows:

Recently in Dojo 2

We’re making further progress on Dojo 2 as well. Recently our focus has been on Compose, core, and the package template:

Compose parser

Ongoing discussion on consistency between parser objects and Compose objects and parser.watch() uses a callback versus synthetic events core

dojo2-package-template Upcoming Dojo 2 efforts

Here we’ve identified a few of our aspirations for near future. This week in Dojo 2, we have more code reviews to complete and pull requests to land. If you’re interested in helping out in these areas, or other parts of Dojo 2, just let us know, either in the comments or on IRC.

  • Review and improve the Compose and parser prototypes
  • Define and refine the approach to widgets and application architecture for Dojo 2
  • Continue to review and land code for Core, Crypto, DOM, dstore, i18n, Loader, and Routing

We have some old PRs out there that need updates and some other issues we’re working on, including:

Weekly IRC meeting

As usual, our weekly IRC meeting is on irc.freenode.net #dojo-meeting at 9am Pacific time on Tuesday.

View the Dojo weekly meeting logs

This week’s agenda
  • 1.11 release plan (we’re aiming for December or more likely January for the release)
  • Discuss open 2.x challenges
Thanks!

The Dojo 2 loader, core, and dom are roughly in an alpha state. Progress is being made on routing, crypto, i18, dstore, Compose and parser. Please let us know if you plan to work on any features, or would like to get involved, so we can collaborate.

Categories: Open Source, RIA

Vary

Date Created: December 8, 2015 - 11:37Date Updated: December 9, 2015 - 09:21Submitted by: Tatiana Person Montero

Environment based on Eclipse IDE for improving computer programming learning. This environment allows user to program algorithms in a pseudocode way and automatically transform them into a executable code in several languages, such as C or C++. It also allows the measurement of quality of the algorithms from the SonarQube platform.

Categories: Open Source

Arduino Eclipse Plugin (Product)

Date Created: December 7, 2015 - 15:29Date Updated: December 8, 2015 - 09:23Submitted by: jan baeyens

Note: This is the product, the solution is also available as a plugin.

This is a free and opensource product that is a professional complete alternative to the Arduino IDE.
It allows you to create compile and upload sketches with nearly the same simplicity as the Arduino IDE but with all full functional features one would expect from a professional IDE.
This is a add on to the CDT plugin and as such has all C/C++ development features plus a toolbar with the arduino buttons from the Arduino IDE and a Arduino menu for importing libraries and more.
The plugin
With the latest release 2.4 arduino (december 2015) IDE 1.6.5 (you can use any R number) is advised. Note that Arduino ID 1.6.6 (and later) has made changes that break compatibility so don't use them with this plugin.

Linux install page http://baeyens.it/eclipse/stable-linux.html
Mac install page http://baeyens.it/eclipse/stable-osx.html
Windows install page http://baeyens.it/eclipse/stable-win.html

Categories: Open Source

Google Code-in: may the source be with you

Google Open Source Blog - Mon, 12/07/2015 - 18:40
For the sixth year running, starting today, teens from around the world will have the chance to learn and develop new CS skills by competing in Google Code-in (GCI). By working on real software projects—with help from mentors along the way—students just starting out with Computer Science can begin to investigate and discover the countless opportunities at their fingertips through code.

During the seven weeks of Google Code-in, pre-university students (ages 13-17) can browse hundreds of tasks created by 14 open source organizations. Students then get to choose the tasks they find most intriguing. A wide variety of skills and interests are required to make any software project work, so the tasks in Google Code-in are designed to reflect that diversity. Students can choose to work on projects across documentation, coding, training, research, quality assurance, user interface and outreach tasks.

The 14 organizations students can work with during the contest encompass many fields: health care for developing countries, learning activities for elementary students, desktop and portable computing, the encouragement of young women in computer science, game development, to operating systems used in satellites and robots.
Each task has at least one mentor assigned to it - not only to review the student’s work, but to help answer questions along the way. Each organization also offers beginner tasks that give students who are newer to open source development an easy and clear place to get started. Another goal of the contest is to encourage students to find a coding community that they enjoy working with and hopefully become an active contributor for years to come.
Contest open screenshot.pngOver the last 5 years, over 2,200 students from 87 countries have successfully completed tasks by participating in Google Code-in. To celebrate CS Ed Week this year, please help us introduce even more young minds to open source software development through Google Code-in. To learn more about Google Code-in— including rules and FAQs—please visit the site and the Getting Started Guide.

By Stephanie Taylor, Open Source Programs
Categories: Open Source

Projects of the Week, December 7, 2015

SourceForge.net: Front page news - Mon, 12/07/2015 - 07:08

Here are the featured projects for the week, which appear on the front page of SourceForge.net:


PlatformIO Storage

PlatformIO is a cross-platform code builder and the missing library manager, ready for embedded development, IDE and Continuous integration, and Arduino and MBED compatible. You have no need to install any IDE or compile any tool chains. PlatformIO has pre-built different development platforms including: compiler, debugger, uploader for embedded boards, and many other useful tools. PlatformIO has pre-configured settings for most popular Embedded Boards. PlatformIO Library Manager allows you to organize external libraries, and you can search for new libraries via Command-Line or Web interfaces.
[ Download PlatformIO Storage ]


Equalizer APO

Equalizer APO is a parametric/graphic equalizer for Windows. It is implemented as an Audio Processing Object (APO) for the system effect infrastructure introduced with Windows Vista. It features a virtually unlimited number of filters, works on any number of channels, has low CPU usage, has a modular graphical user interface, and is very low latency which makes it well suited for interactive applications.
[ Download Equalizer APO ]


BibDesk

BibDesk is a graphical bibTeX bibliography manager for Mac OS X.
[ Download BibDesk ]


dispcalGUI

dispcalGUI is a graphical user interface for the display calibration and profiling tools of Argyll CMS, an Open Source color management system. Calibrate and characterize your display devices using one of the many supported hardware sensors, with support for multi-display setups and a variety of available settings like customizable whitepoint, luminance, tone response curve, the option to create matrix and look-up-table ICC profiles, with optional gamut mapping, and some proprietary 3D LUT formats.
[ Download dispcalGUI ]


simutrans

Simutrans is a cross-platform simulation game where players try to successfully manage transportation systems between places by land, air, and water, for passengers, mail, and goods. Planes, ships, trains, trams, trucks, buses, or monorails are at your disposal, but factories operate based on contracts, and passengers can only travel to their set destinations.
[ Download simutrans ]


KaOSx

An independent, small, and rolling distribution, fully focused on KDE/Qt. KaOSx uses pacman as package-manager.
[ Download KaOSx ]


VoIP monitor

VoIPmonitor is an Open Source network packet sniffer with a commercial front end for SIP, SKINNY, RTP, and RTCP VoIP protocols running on Linux. VoIPmonitor is designed to analyze the quality of VoIP calls based on network parameters, delay variation, and packet loss according to the ITU-T G.107 E-model, which predicts quality on MOS scale. Calls with all relevant statistics are saved to the MySQL or ODBC database. Optionally, each call can be saved to a pcap file with only SIP/SKINNY protocol or SIP/RTP/RTCP/T.38/udptl protocols. VoIPmonitor can also decode audio.
[ Download VoIP monitor ]


digiCamControl

digiCamControl is a free and Open Source software that allows you to control camera shooting parameters, and also saves time by transferring images directly from your camera to your computer as you take each shot.
[ Download digiCamControl ]


berryboot

Berryboot is a simple operating system installer and boot selection screen for ARM devices such as the Raspberry Pi and Cubieboard. It allows you to put multiple Linux distribution on a single SD card.
[ Download berryboot ]

Categories: Open Source

PoWA 3.0.0 released

PostgreSQL News - Mon, 12/07/2015 - 01:00

Paris, December 07 2015

DALIBO is proud to present the third release of PoWA, the PostgreSQL Workload Analyzer.

Realtime traffic analysis and dynamic graphs

PoWA is a workload analyzer that gives a clear view of the activity of your PostgreSQL servers with a query runtime graph and a block hit/read graph along with a chart of time-consuming queries over the specified time period.

If you zoom anywhere in one of the graphs, the chart will adjust and show you which queries were running at that time. If you click on a specific query, you will get additional graphs such as read/write time, number of rows affected, local and shared hit, etc.

Better predicate analyzer

The pg_qualstats extension stores new counters. It's now possible to know the most executed predicates in relation to all the related queries. It also tracks non-normalized queries so that it’s possible to execute an EXPLAIN of any query tracked by pg_stat_statements.

Database global optimization

PoWA is now able to use statistics about every predicate used by any query executed on a database to suggest the smallest index set that optimizes every one of those predicates.

In particular, the heuristics place heavy emphasis in consolidating many indexes into one by giving preference to definitions spanning multiple columns. This can provide new information about the actual load and correlation between predicates that are traditionally hard to discover for the DBA.

Index suggestion check

Thanks to the HypoPG extension, the benefits of the suggested index creations can automatically be checked by running the queries against hypothetical indexes. You can see instantly if the suggested index is relevant and how much it'll improve the query.

Credits

DALIBO would like to thank the users and developers who contributed to this release.

PoWA is an open project available under the PostgreSQL License. Any contribution to build a better tool is welcome. You just have to send your ideas, patches or features requests using the GitHub tools or to powa-users@googlegroups.com

Links

For PoWA 3.0.0:

For the stats extensions:

About PoWA

PoWA is PostgreSQL Workload Analyzer that gathers performance stats and provides real-time charts and graph to help monitor and tune your PostgreSQL servers.

Code & Demo at dalibo.github.io/powa

About DALIBO

DALIBO is the leading PostgreSQL company in France, providing support, trainings and consulting to its customers since 2005. The company contributes to the PostgreSQL community in various ways, including : code, articles, translations, free conferences and workshops.

Check out DALIBO's open source projects at dalibo.github.io

Categories: Database, Open Source

Nasdanika Information Center

Date Created: December 6, 2015 - 14:38Date Updated: February 2, 2016 - 22:30Submitted by: Pavel Vlasov

Nasdanika Information Center can be used to host web-based ECore model documentation. Model elements can be documented with annotations or documentation can be linked to model elements. The information center automatically generates UML class diagrams for packages and classes and provides a pre-processor which generates UML diagrams from textual descriptions.

Information Center is a standalone Eclipse/Equinox product. For details visit the solution home page on GitHub.

Categories: Open Source

Google Summer of Code wrap-up: LabLua

Google Open Source Blog - Fri, 12/04/2015 - 19:27
LabLua is a lab at PUC-Rio dedicated to research on programming languages, with emphasis on the Lua programming language. Lua is a powerful, fast, lightweight, embeddable scripting language that is used in many industrial applications and on several embedded systems and games.
This was our second year in Google Summer of Code (GSoC) and we feel our six completed projects made for a very successful outcome. Five of our projects were selected from our Ideas List, and one was proposed by the student herself! It was great to not only see students contributing code to the project, but to witness their enthusiasm for project design as well. Below are some brief highlights of this year's projects:
Port Lua Test Suite to NetBSD Kernel (Guilherme Salazar)The Lua interpreter was initially ported to the NetBSD kernel during GSoC 2010, allowing users to write kernel extensions using Lua scripts. During GSoC 2015, Guilherme worked on porting the Lua test suite to the NetBSD kernel. He adapted test scripts to eliminate dependencies on floating-point numbers and the operating system itself.
Guilherme also ported and reimplemented part of the Lua standard libraries (e.g., math and io) for satisfying test dependencies. Moreover, he found important bugs on the Lua kernel port.
Elasticsearch Lua client (elasticsearch-lua) (Dhaval Kapil)Elasticsearch is a distributed and scalable search engine written in Java that, besides its native transport protocol (Java to Java), offers a very complete REST API accessed through JSON. Dhaval built elasticsearch-lua, an initial client for the Lua language following a model similar to other existing clients, such as the clients written in Python and PHP.
Dhaval had the freedom to decide how to model the object oriented API and how to build tests during development. With elasticsearch-lua, programmers can now access most Elasticsearch functionalities, such as index, read, update, delete and search documents.
Port an SDL-based C++ open source game to CĂ©u (Alexander Tkachov)CĂ©u is a programming language that targets the development of reactive applications such as video games. It features first-class support for events and parallel compositions for lines of execution. For this project, we wanted to port an open source game of considerable size from C++ to CĂ©u.
Alexander chose the game Pingus (a Lemmings-like game for Linux) with a codebase of around 40k lines of code. An important requirement of our project was to do a "live port" of the game, in which the game remained fully functional while portions of it were ported to CĂ©u and the rest remained in C++. In this project, Alexander faced two main challenges: applying the CĂ©u idioms to the new code and keeping the old C++ code working across the language boundaries. Even though the code base was too big for a 3-month period, Alexander was able to port around half of the game, including its core (i.e., the game levels).
Add support for WSDL generation to LuaSOAP (Victor Dias)LuaSOAP is a library to ease the use of SOAP, the Simple Object Access Protocol. It provides a very simple API that converts Lua tables to and from XML documents. It offers two modules to help providing (server) and consuming (client) SOAP services.
Victor developed a module to help the generation of WSDL (Web Services Description Language) documents for the services implemented by the server. This new module traverses the service description (a Lua table, built by the programmer by hand, because Lua doesn't have this kind of information) and produces the WSDL description for it. This new module will be integrated into the next version of LuaSoap.
Design of TIER encoding and its implementation in Lua (Lukas Borin)TIER is an experimental language-independent binary encoding format, designed by this project's mentor, similar in purpose to formats like XML, JSON and Google's Protocol Buffers. TIER is designed to optionally support self-describing encodings that include meta-information about the serial structure of the encoded data; this meta-information can be used to support dynamic verifications or automatic decoding.
Lukas improved TIER's design and also wrote the first implementation of a Lua library that provides support for TIER encodings. He also wrote TIER's basic documentation and some tutorials on its usage. The TIER library supports custom mappings of the various TIER serial structures to specific Lua values. On top of this custom mapping support, Lukas also developed some predefined mappings for usual Lua values and a framework to facilitate the creation of mappings for usual Lua structures, such as sequences, maps, sets, etc.
Improvements to the Sailor Web Framework (Etiene Dalcol)Sailor is an MVC web framework for Lua. Its distinguishing feature is that it easily lets the programmer write Lua code for running both in the server and in the browser. It was created by Etiene Dalcol, and she submitted a project proposal to us with a series of planned improvements.
During GSoC 2015, she worked on three fronts for improving the framework: the first was a better test suite, the second was better documentation for the project, and the third was a series of improvements for the feature of running Lua code on the browser, with the possibility of having Lua code in the browser request new modules on demand from the server, and breaking the original dependency on also having node.js installed on the server.
All of the GSoC contributions are already committed to the Sailor project repository at Github, and the test suite is already part of Sailor 0.4, the latest public release of the project.
By Ana LĂşcia de Moura, Adjunct Professor at PUC-Rio and LabLua Administrator

Categories: Open Source

aformatik Training & Consulting GmbH & Co. KG

Submitted by: Joerg MornhinwegDate Created: December 3, 2015 - 11:01Date Updated: December 4, 2015 - 11:21

We have earned the confidence of many well-known companies in Germany, Austria and Switzerland. Our expertise enables us to help our clients from the start of projects, beginning with educating and training our clients’ employees, throughout the whole project liefcycle providing coaching and consulting. As a consequence we are trusted by our clients’ in managing and realizing even very complex software systems.

Aformatik is an established Consulting Company with a strategic focus on Java technology. The Portfolio includes techncal consulting, coaching (know-how transfer), objekt-oriented application development and education for beginners and professionals in Java ME, SE and EE technologie.

Company URL: http://www.aformatik.dehttp://www.aformatik.de/training/schulungen-kursangebot.htmlSindelfingen, Germany
Categories: Open Source