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

Codecity

Date Created: March 6, 2015 - 14:17Date Updated: March 27, 2015 - 11:57Submitted by: Marcel BruchTake a seat and explorer your Java code from a totally different angle

There are many ways how to visualize software and all serve the very same purpose: making it easy for both, software developers and managers alike, to analyze large software projects and to understand which parts of the software are troubling and need their immediate attention. Code cities are one of the most popular and most intuitive visualization techniques. Born in Academia a while back [1] Codecity now brings an easy to use analysis tool into your favorite IDE:

How to generate your personal code city

After installing the plugins into your Eclipse, select the Java projects you'd like to visualize and select "Show in » Codecity" from the context menu. The metrics are now computed in the background and when completed, a browser window will pop up showing your code city.

Supported metrics in the personal edition Basic Eclipse Metrics
  • Number of declared methods
  • Number of declared fields
  • Number of problem markers
  • Number of commits (requires projects to be connected with an Eclipse team provider)
Jacoco Integration

Codecity Personal Edition provides a connector to the Jacoco Test Coverage XML reports. To enable Jacoco Metrics put one coverage report names jacoco.xml into your workspace.

  • Number of lines in source code
  • Number of branches in source code
  • Percentage of lines not covered by tests
  • Percentage of branches not covered by tests
Missing a Feature?

Codecity is currently work-in-progress and we are curious to hear what you think about it and what you are missing. To raise a feature request or see which requests have already been raised, visit feedback forum.

Prerequisites

You need a state-of-the-art web browser with WebGL enabled.

[1] CodeCity Project, developed at the UniversitĂ  della Svizzera italiana until 2010

Categories: Open Source

CritiqueBrainz and rocking the Google Summer of Code

Google Open Source Blog - Fri, 03/06/2015 - 18:00
Student applications for Google Summer of Code 2015 will be opening on March 16th. University students interested in applying for this year’s program can get ready now by checking out the organizations taking part in this year’s program. Below, Robert Kaye shares the story of an outstanding student from last summer who made a big impact with the MetaBrainz Foundation, maintainers of the MusicBrainz service.

At MusicBrainz, we’re proud to collect and freely share information about all kinds of music. We strive to keep that information objective and factual, but being music fans, we can’t help but want to share our opinions sometimes, too. To do that, we developed a concept called CritiqueBrainz where we’d welcome people to write Creative Commons licensed, non-neutral point of view music reviews. Unfortunately, we didn’t have the resources to actually build it, nor was there any off-the-shelf software that would suit our needs.
When we took part in Google Summer of Code 2013, we put the CritiqueBrainz concept on our ideas page. It was too much to ask of one student to build a complete website with all the custom features we wanted in one summer. We accepted one student who wrote all of the features we requested as part of his successful GSoC project. However, over the summer it became clear that we needed to put a lot more work into the project before we could deploy the new site.
In 2014, we put CritiqueBrainz on our ideas page again and this time we asked for someone to finish the site in the first half of the summer, then to deploy, maintain and debug the site during the latter half of the summer. When the student application period opened, things got interesting. Several years ago, we added a requirement that applying students needed to submit a pull request to the project in order for us to consider their application. One student in particular submitted a pull request as part of his application. And then he submitted another. And another.
That one particular student submitted some truly excellent work as part of his application. So we accepted Roman Tsukanov, better known to us as “Gentlecat”, to finish the CritiqueBrainz project. At almost the instant we announced our accepted student proposals, his stream of pull requests started up again and never let up. As we were approaching the official start date of GSoC, the number of tasks left to finish the coding portion of the project was dwindling. Gentlecat even wrote a tool that parsed, cleaned up and imported 9,000 reviews that the BBC had given us. Things were looking excellent!
Given all that progress, we decided that the beginning of GSoC would be a perfect opportunity to release the first beta version of the CritiqueBrainz to the world. We gave Gentlecat access to one of our servers and let him deploy the code onto the server himself. With some guidance on best practices from us, he quickly got things up and running. Many people from the MusicBrainz community began writing reviews on the site, which naturally meant they found bugs and made tons of suggestions for improving the site.
Gentlecat plowed through the new tickets opened during the beta period and created pull request after pull request. My summer mornings consisted of reviewing his pull requests from the previous day. Gentlecat knocked out a long list of bugs while refactoring the code to have a better layout and improve readability. He added HTTPS support, found and fixed problems from the GSoC 2013 project, and even added integration with Spotify to support a hack I was creating at San Francisco Music Hack Day.
In the end, Gentlecat finished at least twice what he had promised to do during the span of GSoC. And the best part? He continues to pound out code and fixes, and he’s now a contributor to three of our projects.
He plans to apply for Google Summer of Code again this year, but he also feels that more people ought to be involved with CritiqueBrainz so he’s been contributing additional project ideas for other students to consider. If you’re a university student and CritiqueBrainz sounds interesting to you, please check out our GSoC 2015 ideas page.
Gentlecat rocked GSoC so hard that his nickname has become a term in our community: if you Gentlecat something, it means that you finished faster than anyone expected while going above and beyond what you promised to do. In other words: you rocked it. Hard!

by Robert Kaye, MusicBrainz GSoC mentor
Categories: Open Source

Eclipse Community Awards 2015 Finalists

Eclipse News - Wed, 03/04/2015 - 18:56
Congratulations to the finalists! The winners will be annouced at EclipseCon 2015.
Categories: Open Source

Free: NetBeans Day Germany

NetBeans Highlights - Wed, 03/04/2015 - 15:03
16 March 2015 -- Join the NetBeans community, including Adam Bien and Dalibor Topic, at a day of free sessions dealing with Java and JavaScript, hosted by Oracle Netherlands in Utrecht.
Categories: Java, Open Source

New Release of Eclipse Paho and Eclipse Mosquitto Continue Momentum of the Growing Open Source IoT Community and MQTT

Eclipse News - Wed, 03/04/2015 - 14:18
The Eclipse Foundation is pleased to announce the release of Eclipse Paho 1.1 and Eclipse Mosquitto 1.4.
Categories: Open Source

Meet the PostgresDAC v3.0.0

PostgreSQL News - Wed, 03/04/2015 - 01:00
We've released our new major version of PostgresDAC component suite. It’s been a long way started almost two years ago. The goals were complicated, and not all of them were accomplished. However, in general we may proudly say without a doubt that this release is a significant milestone. Dump and restore functionality

TPSQLDump and TPSQLRestore components is a pair that is one of a kind on the whole market. There are no more such facilities not only in the Delphi or C Builder world, but for any other IDE's or toolchains. That is why our first goal was to keep this classes up to date. A huge amount of work was done and a year ago the brand new v3 TPSQLDump and TPSQLRestore components were published as part of v2.11.0 release.

TPSQLDump and TPSQLRestore are fully compatible with native pg_dump and pg_restore utilities. Each and every native feature is supported out of the box:

  • output formats (binary, text, directory, gzipped),
  • parallel dumping and restoring,
  • comprehensive selection, filtering and reordering of archived items,
  • SQL-92 specific output options, etc.
Asynchronous Fetch-On-Demand mode

The default TPSQLQuery's mode is suitable for submitting commands and getting result sets in normal, synchronous applications. However, there are few drawbacks, that may be of importance to developers:

  • TPSQLQuery.Open waits for the command to be completed. The application might have other work to do (such as maintaining a user interface), in which case it won’t be a good decision to block while waiting for a response.
  • Since the execution of the client application is suspended while it waits for the result, it is hard for the application to decide that it would like to try to cancel the ongoing command.
  • TPSQLQuery in default mode always collects a command's entire result, buffering it in a single place. While this behavior simplifies some internal logic, it can be impractical for results containing many rows.

To avoid such limitations developers now can use the brand new Fetch-On-Demand mode, which is turned on by dsoFetchOnDemand option in the TPSQLQuery.Options set. There are limitations of course:

  • To get advantages of the Fetch-On-Demand mode one should use read-only TPSQLQuery objects. This restriction will be removed with time probably.
  • Each read-only TPSQLQuery component must have its separate TPSQLDatabase component since Fetch-On-Demand command flow will block a connection until getting the last row of the result set.
Support for built-in range and geometric field types

Previously these specific types were mapped to TStringField class. Now PostgresDAC provides new TField descendants for this:

  • TPSQLRangeField
  • TPSQLPointField
  • TPSQLCircleField
  • TPSQLBoxField
  • TPSQLLSegField

All of them will be created automatically if needed, or may be added manually in design time.

TPSQLRangeField encapsulates all built-in PostgreSQL range types: int4range, int8range, numrange, tsrange, tstzrange and daterange. Information about range value is stored in the TPSQLRange record by storing values for each bound using TPSQLRangeBound record. Depending on the underlying table field type developer may access bound values using appropriate methods AsInteger, AsFloat, etc.

Enhanced Manual

We've finished the new help system. It's rewritten it from scratch. Support for such formats provided:

  • chm,
  • pdf.
  • epub (in progress).
Full changelog:
  • [!] Fetch-On-Demand mode introduced for readonly TPSQLQuery objects
  • [!] Support for geometric types added
  • [!] TPSQLRangeField added
  • [!] Support for pre-8.0 PostgreSQL servers is discontinued
  • [!] v9.4.0 client libraries added
  • [!] v9.4.0 dump & restore libraries (pg_dump.dll, pg_restore.dll) added
  • [*] Components TPSQLUser and TBDE2PSQLDAC marked as deprecated and will be removed shortly
  • [*] EPSQLDatabaseError is raised if TPSQLDatabase is used in non-exclusive mode for TPSQLQuery with dsoFetchOnDemand
  • [*] TPSQLDatabase.CancelBackend checks for connection now to prevent AV
  • [-] "AV may occur if SQL parameter name consists from incorrect characters chain" bug fixed
  • [-] "EPSQLDatabaseError detail error properties are empty after error in TPSQLDirectQuery.Open" bug fixed
Download

You're welcome to download the PostgresDAC v3.0.0 right now at: http://microolap.com/products/connectivity/postgresdac/download/ or login to your private area on our site at http://microolap.com/my/downloads/

Feedback

Please don't hesitate to ask any questions or report bugs with our Support Ticketing system available at http://www.microolap.com/support/

Categories: Database, Open Source

Automate Your Infrastructure with Ansible

DevX: Open Source Articles - Tue, 03/03/2015 - 17:18
Learn more about why Ansible is a valuable tool that provides a coherent model for safely provisioning, configuring and orchestrating multiple remote machines.
Categories: Open Source

Fujitsu Develops Column-Oriented Data-Processing Engine that accelerates analytic processing more than fifty-fold on a single server with PostgreSQL open-source database

PostgreSQL News - Tue, 03/03/2015 - 01:00

Fujitsu Laboratories Ltd. today announced that it has developed a column-oriented data-storage and processing engine that enables fast analysis of large volumes of data in a database system.

In recent years, column-oriented databases have emerged as a system that allows for better speed when reading and analyzing large volumes of data, as a counterpart to existing row-oriented databases, which are suited to handling data updates. But problems have been either that the changes to row-oriented data cannot be automatically reflected in column-oriented data, or that the size of the column-oriented data is constrained by installed memory.

Fujitsu has developed an engine that, running on a PostgreSQL open-source database, without being dependent on memory capacity, instantly updates column-oriented data in response to changes in row-oriented data, and processes column-oriented data quickly. The engine quickly analyzes indexes(1), which are provided by most database systems, and can be used by developers without special consideration to whether the storage method is row-oriented or column-oriented. With a parallel-processing engine especially suited for processing column-oriented data, analyses run on a single CPU core are conducted 4 times faster than before, and one server equipped with 15 CPU cores can run analyses at least 50 times faster.

For more information please visit http://www.fujitsu.com/global/about/resources/news/press-releases/2015/0226-01.html

Categories: Database, Open Source

Tutorial: How to sync a GitHub or Google Code repo to a SourceForge project

SourceForge.net: Front page news - Mon, 03/02/2015 - 22:01

If you have files on GitHub and Google Code and want to sync these existing files on SourceForge to take advantage of SourceForge’s distribution know-how, our popular analytics tools, and our extensive Open Source directory, then read on …

First, we’ll share SourceForge’s distribution advantages with you and then we’ll show you how easy it is to sync your GitHub or Google Code repo to a SourceForge project.

As a trusted partner for Open Source, SourceForge offers you several worthwhile distribution advantages, such as:

Free Unlimited Bandwidth—Reduce overhead and provide a better experience by using the largest, freely managed global mirror network. We serve 150 million downloads per month, to over 33.8 million unique visitors.

Analytics—Follow the trends that enable you to create better software. Learn more about where your project is popular and which operating systems your users prefer.

Premier Visibility—Reach more users and gain market share in the Open Source landscape. SourceForge has 33.8 million unique visitors each month, offering an ample opportunity to improve your project outreach.

A Trusted Name in Open Source—Since 1999, thousands of projects have chosen SourceForge to host their source code and their project communities, so you’ll be in great company!

Sharing files on SourceForge at a glance
  1. Create a SourceForge account.
  2. Create a SourceForge project and import your files.
    New! Import directly from Google Code, GitHub, or Trac.
  3. Set up your Project Admin page.
  4. New! Automate sharing your GitHub files on SourceForge.
Video Demo

Getting Started

To share your Github or Google Code project on SourceForge, you’ll need to follow these four simple steps:

  1. Create a SourceForge account, fill out the registration form, and click Register.
  2. Create a SourceForge project, uncheck the Git tool if you use GitHub, add the tools that you’d like, agree to the terms of service, and click Create. (You can also directly import a project from Google Code, GitHub, or Trac.)
  3. Set up your Project Admin page and fill out the project Project Admin summary, including the short and long project descriptions, screenshots, videos, and full feature descriptions to help people find your project.
  4. Set up your GitHub files to auto update to SourceForge by clicking Admin > Tools > Files > GitHub integration. This copies new releases from GitHub’s repository to your SourceForge project, increases your visibility, and gives you analytic insights.
    Note: You can also add a SourceForge download button to your GitHub release notes and external project pages.

SourceForge is proud to offer you the ability to toggle between GitHub from the SourceForge NavBar and SourceForge’s download page from your GitHub directory, making file sharing a breeze!

Categories: Open Source

EclipseCon 2015 - 1 week away

Eclipse News - Mon, 03/02/2015 - 20:33
The conference is practially here! Don't forget to register.
Categories: Open Source

Mentoring Organizations for Google Summer of Code 2015

Google Open Source Blog - Mon, 03/02/2015 - 20:00
GoogleSummer_2015logo_horizontal.jpgWe are excited to announce the mentoring organizations that have been accepted for this year’s Google Summer of Code program. As always, we had many more great projects than we could accept. After reviewing 416 applications, we have chosen 137 open source projects, 37 of which are new to Google Summer of Code. You can visit our Google Summer of Code 2015 program website for a complete list of the accepted orgs.
Over the next two weeks, students interested in applying for the Google Summer of Code 2015 program can learn more about the 137 accepted open source projects. The student application period begins on Monday, March 16, 2015 at 19:00 UTC.
Interested? Start by reviewing the Ideas Page from each organization to learn about the project and how you might contribute. Some of the most successful proposals have been completely new ideas submitted by students, so if you don’t see a project on an Ideas Page that appeals to you, don’t be afraid to suggest a new idea to the organization! There are points of contact listed for each organization on their Ideas Page - students can contact the organization directly to discuss a new proposal. All organizations list their preferred method of communication on the organization homepage, available on the Google Summer of Code program website. We strongly encourage students to reach out to the organizations before they apply. Please see our Frequently Asked Questions page for more information.
Congratulations to all of our mentoring organizations! We look forward to working with all of you during this next Google Summer of Code!
By Carol Smith, Open Source Team
Categories: Open Source

March 2015, “Staff Pick” Project of the Month – ProjectLibre

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

For our March “Staff Pick” Project of the Month, we selected ProjectLibre, an open source and compatible alternative to Microsoft Project. The ProjectLibre team shared their thoughts about the project’s history, purpose, and direction.

SourceForge (SF): Tell me about the ProjectLibre project please.

ProjectLibre Team: ProjectLibre is an open source alternative to Microsoft Project. Our functionality mirrors Microsoft in a way since you can simply open existing MS Project files in ProjectLibre. It is available on Linux, Mac, or Windows. ProjectLibre is the culmination of long careers in the project management software industry. The two founders are Marc O’Brien and Laurent Chretienneau. We have been innovating in the project management software industry since the Mainframe and DOS software era. Our mission is to provide an open source alternative to Microsoft Project. There are many ‘lite’ project management solutions but ProjectLibre is the only solution that has the full feature set to replicate Microsoft Project’s functionality.

SF: What made you start this?

ProjectLibre Team: We have a passion for the project management marketplace. We are also the founders of WebProject and Projity, which were both acquired by large organizations, but the vision of making a global impact with an open source replacement of Microsoft Project was impacted with each acquisition. We are in this for the long term and are effectively making a difference.

SF: Has the original vision been achieved?

ProjectLibre Team: Yes, that is a good question and we are thankful the vision is being achieved and exceeded. ProjectLibre has over 1,400,000 downloads in over 200 countries. We are continuing to make improvements and will be release a complimentary cloud solution this year.

SF: Who can benefit the most from your project?

ProjectLibre Team: The project management world is being held captive by a Windows only solution from Microsoft that costs over $1,300 per desktop copy, which does not cover the entire requirement stack such as the Project Server and many other components. This is very expensive! ProjectLibre still has roadmap features to complete but for no charge effectively project managers around the world can manage their projects without going broke. They can funnel their cash resources into their core business and not management software.

SF: What is the need for this project management software?

ProjectLibre Team: There are over 60,000 people each month downloading in over 200 countries to manage their projects. They can manage schedules, resources, and costs at a very high level. There are pharmaceutical, construction, environmental, government, and other industries. The government of Laos is using ProjectLibre to manage the building of schools. The Clinton Foundation and other non-profits are using ProjectLibre in Africa for NGO programs in agriculture and other areas. We are making a major impact! Our website includes an impressive list of Fortune 500 companies that use ProjectLibre everyday.

SF: What’s the best way to get the most out of using ProjectLibre?

ProjectLibre Team: Our users vary from small projects to major initiatives. We encourage users to become community members at http://www.projectlibre.org. There are great discussion forums where community members answer questions and post questions. We also have documentation and videos available at the community site to help you get started and get the most out of ProjectLibre.

SF: What has your project team done to help build and nurture your community?

ProjectLibre Team: This is very important for open source initiatives. We have a community site, with over 60,000 community members who contribute. One of our goals for this year is to engage further with the community. We recently launched an improved website and want to continue this work to engage further with ProjectLibre’s amazing global community.

SF: Have you all found that more frequent releases helps build up your community of users?

ProjectLibre Team: We do not have frequent releases. ProjectLibre is undergoing a complete rewrite to make it modular. This will have long-term benefits for the community and allow for extensions/integrations to be contributed. This process has impacted our ability to have frequent releases of the current project but in the future we certainly will!

SF: What was the first big thing that happened for your project?

ProjectLibre Team: The initial release was such a monumental effort from the team. It was recognized by SourceForge, which greatly helped bring wanted attention to our solution. InfoWorld subsequently gave us a “Best of Open Source” award and that also helped. SourceForge’s support is truly appreciated and has been an important part of our success.

SF: What helped make that happen?

ProjectLibre Team: The ProjectLibre team is truly unique. Our domain expertise is unparalleled for having innovated for decades in the project management marketplace. We have taken that domain expertise and have devoted ourselves to offering the global community a FOSS solution.

SF: What is the next big thing for ProjectLibre?

ProjectLibre Team: ProjectLibre is breaking the news here. We will be releasing the modular rewrite of ProjectLibre on the desktop. We will also be releasing a cloud version and are working on hosting options. There will be a companion cloud solution called PPMLibre, which will allow enterprises to manage their entire portfolio of projects. We are well into both initiatives but have not announced a release date.

SF: How long do you think that will take?

ProjectLibre Team: Great question but we are not in a position to announce the release date yet. We are using it internally and demos are impressive but I get in trouble every time I preview it because it looks good already. That’s why the team has asked me stop previewing it until we have an official release date.

SF: Do you have the resources you need to make that happen?

ProjectLibre Team: ProjectLibre is very complex software. The code is complicated and the domain expertise adds to the complexity. We are hoping the modular rewrite will allow for more community contributions but at this point it is limited. It has been a struggle, as we do not have corporate sponsorship or revenue. We will make it happen but it has been difficult. This is a testament to the team’s commitment to ProjectLibre!

SF: If you had it to do over again, what would you do differently for ProjectLibre?

ProjectLibre Team: One thing I would never do is to choose a different co-founder. I do all the public facing work for ProjectLibre but Laurent, who leads the development efforts, is truly irreplaceable. We have worked together for many years. Our community is and I am so fortunate that Laurent is passionate about ProjectLibre!

SF: Is there anything else we should know?

ProjectLibre Team: ProjectLibre has made a difference globally with downloads in every corner of the globe. Our user stories inspire us and we are dedicated to ProjectLibre for the long haul. We hope the cloud version of both ProjectLibre and PPMLibre will allow us to accelerate our core mission.

If you have a user story to share, please send it to info@projectlibre.org. We’d love to hear from you!

[ Download ProjectLibre ]

Categories: Open Source

Project of the Week, March 2, 2015

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

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


shadowsocks-gui

A fast tunnel proxy that helps you bypass firewalls.
[ Download shadowsocks-gui ]


Shareaza

Shareaza is a powerful multi-network, peer-to-peer file-sharing client supporting Gnutella² G2, Gnutella, eDonkey2000 / eMule, DC++, HTTP, FTP, and BitTorrent / DHT protocols for Windows or Wine.
[ Download Shareaza ]


PeaZip

PeaZip is a free Zip files utility, providing an unified, natively portable, cross-platform file and archive manager GUI for many Open Source technologies like 7-Zip, FreeArc, PAQ, UPX. Create: 7Z, ARC, BZip/GZip, PEA, TAR, WIM, XZ, ZPAQ, ZIP files and more Extract 150+ file types: ACE, CAB, DEB, ISO, RAR, ZIPX and more Features of PeaZip includes extract, create and convert multiple archives at once, create self-extracting archives, split/join files, strong encryption with two factor authentication, encrypted password manager, secure deletion, find duplicate files, calculate hashes, export job definition as script.
[ Download PeaZip ]


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 ]


gnuplot development

A famous scientific plotting package, features include 2D and 3D plotting, a huge number of output formats, interactive input or script-driven options, and a large set of scripted examples.
[ Download gnuplot development ]


Hibernate

Hibernate is an Object/Relational Mapper tool. It’s very popular among Java applications and implements the Java Persistence API. Hibernate ORM enables developers to more easily write applications whose data outlives the application process. As an Object/Relational Mapping (ORM) framework, Hibernate is concerned with data persistence as it applies to relational databases (via JDBC).
[ Download Hibernate ]


ConEmu – Windows console with tabs

ConEmu-Maximus5 is a Windows console window enhancement (local terminal emulator), which presents multiple consoles and simple GUI applications as one customizable tabbed GUI window with various features. Initially, the program was created as a companion to Far Manager. Today, ConEmu can be used with any other console application or simple GUI tools (like PuTTY for example). ConEmu is an active project and open to suggestions.
[ Download ConEmu - Windows console with tabs ]


Alt-F

Alt-F provides a free alternative firmware for the DLINK DNS-320/320L/321/323/325. Alt-F has Samba and NFS; supports ext2/3/4, VFAT, NTFS and ISO9660 filesystems; RAID 0, 1, 5 (with external USB disk) and JBOD; supports 2/3/4TB disks; rsync, ftp, sftp, ftps, ssh, lpd, DNS and DHCP servers, DDNS, fan and leds control, clean power up and down and more. Alt-F also has a set of comprehensive administering web pages, you don’t need to use the command line to configure it. Besides the built-in software, Alt-F also supports additional packages on disk, including ffp packages, that you can install, update, and uninstall using the administering Web pages.
[ Download Alt-F ]


MediaPortal

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

Categories: Open Source

March 2015, “Community Choice” Project of the Month – GnuCash

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

For our March “Community Choice” Project of the Month, the community elected GnuCash, an easy-to-use personal and small-business finance manager with a checkbook like appearance. The GnuCash team shared their thoughts about the project’s history, purpose, and direction.

SourceForge (SF): Tell me about the GnuCash project please.

GnuCash Team: GnuCash is a personal and small-business, single-user, double-entry bookkeeping software application based on standard accounting principles, with a wide variety of financial and accounting reports to help you get a clear picture of your finances. GnuCash is a mature project with almost twenty years of development and is also a part of the GNU project to build a free software operating system.

SF: What made you start this?

GnuCash Team: GnuCash started as a port of the older X-Accountant software package, with a modern Gtk+ GUI toolkit that runs on GNU/Linux (and others). At the time, a free software accounting program was considered essential to the GNU project.

SF: Has the original vision been achieved?

GnuCash Team: Yes, the original vision was to support single users’ accounting needs and this has been achieved.

SF: Who can benefit the most from your project?

GnuCash Team: Anyone who needs to keep track of their finances, whether it’s a single user, a small business, a charity fundraiser, or anyone that prefers to use a free software solution instead of a commercial or closed-source solution.

SF: What is the need for this personal and small-business -accounting software?

GnuCash Team: If you’ve ever paid taxes, you’ve keenly felt the need for good financial record keeping. If you’ve run a small business, you’ve had to keep detailed records of your business transactions such as invoices, vendors, customers, budgets, etc. GnuCash can help with both personal and small business accounting needs.

SF: What’s the best way to get the most out of using GnuCash?

GnuCash Team: The best way to get the most out of GnuCash is to use it according to the double-entry bookkeeping principles it has been designed for by using the five basic types of accounts, and debits and credits between them, as the building blocks of your financial record-keeping. GnuCash uses your accounting transaction records to build detailed reports of your accounts.

To that end, we have an excellent concept-based guide that walks you through all the accounting activities you can do using GnuCash.

SF: What has your project team done to help build and nurture your community?

GnuCash Team: Our project has a very active user mailing list (gnucash-user@gnucash.org) where both new and experienced users ask questions, swap tips, and help each other. We also have an active developer mailing list (gnucash-devel@gnucash.org) where GnuCash developers collaborate on making improvements to GnuCash. Last year the developers migrated the project repository to the Git version control system to try to lower barriers to entry for potential contributors.

SF: Have you all found that more frequent releases helps build up your community of users?

GnuCash Team: In our case we have found that stability is important to our community. We ship new features in minor releases about once every three years and bug fixes in micro releases every few months.

SF: What was the first big thing that happened for your project?

GnuCash Team: The first big thing probably was the port to Gtk+. There was a lot of excitement at the time. GnuCash was also one of the earliest projects on SourceForge, within the first 150 registered or something like that. The number would have been even lower but we dawdled for a month or two before completing the process.

The port to GTK/Gnome was also when the project name changed based on a popularity poll. Some excellent names were suggested, along with some clunkers like GnoMoney. Somehow GnuCash came out on top. This was circa 1997, meaning SourceForge and GnuCash go back a long way together!

SF: What helped make that happen?

GnuCash Team: The GnuCash team realized that one of the big requirements of a free software desktop, like the emerging GNU/Linux desktop, was a free software accounting package and they helped to bring that vision into reality.

SF: What was the net result for that event?

GnuCash Team: The net result is that anyone looking for a way to manage their finances on free desktop software can now succeed in doing so.

SF: What is the next big thing for GnuCash?

GnuCash Team: The next big step for us is to move to a multi-user architecture so that several people may be able to enter transactions into the same book of accounts simultaneously. This should help small businesses and folks looking to scale up their operations with a free software solution.

SF: How long do you think that will take?

GnuCash Team: The time frame for this is the next several years.

SF: Do you have the resources you need to make that happen?

GnuCash Team: We have an excellent team of developers who know the code base inside and out but we would love to extend a welcome to  new contributors on the project.

SF: If you had it to do over again, what would you do differently for GnuCash?

GnuCash Team: We would not have used the Gtk+ toolkit’s GObject library for writing ‘object-oriented’ code in C.

SF: Why?

GnuCash Team: It ties the internals of GnuCash to the GObject library, which hinders portability.

SF: Any reason you can’t do that now?

GnuCash Team: We are trying to do it now as part of our multi-user architecture effort, but it is a large undertaking and will take time to get right.

SF: Is there anything else we should know?

GnuCash Team: Yes, if you use an Android mobile device, you can record your transactions on the go and import them into GnuCash later. Check out our website to learn more about GnuCash and GnuCash for Android, which is separate from the GnuCash project.

And a big Thank You to SourceForge for continuing to be an indispensable resource for free software projects around the world.

[ Download GnuCash ]

Categories: Open Source

PoWA 2: Finding the Missing Index !

PostgreSQL News - Mon, 03/02/2015 - 01:00

Paris, March 2 2015

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

Complete rewrite of the User Interface

The first major change is the new graphic design : we've rebuilt the web interface from scratch and placed it on a separate module called powa-web. It is now easier to move the PoWA interface out of the database server.

The new interface is based on the previous version and it adds many improvements, including:

  • More graphs
  • New types of graph : Bar / Pie Charts
  • New configuration view
  • New index suggestion widget
  • New physical resource consumption graphs
  • Better Global Query Chart
  • Breadcrumbs
  • Python 2.6, 2.7 and 3.4 compatibility
  • Better browser compatibility

 

Screenshot:

http://powa.readthedocs.org/en/latest/stats_extensions/pg_stat_statements.html#where-is-it-used-in-powa-web

Advanced Filesystem Stats

Second, the core-engine of PoWA is now a separate module too: it's called powa-archivist and we've extended it to archive any kind of internal stats. The main source of stats remains the pg_stat_statements extension but we've integrated 2 other extensions: pg_qualstats and pg_stat_kcache.

With pg_stat_kcache, PoWA is now able to gather statistics about the physical disk access and the CPU consumption of each PostgreSQL backend. This allows the DBA to get a glimpse of the OS-level cache hit ratio.

Screenshot:

http://powa.readthedocs.org/en/latest/stats_extensions/pg_stat_kcache.html#where-is-it-used-in-powa-web

Missing Index Finder + Advanced WHERE Clause Analyzer

Third major improvement, with pg_qualstats PoWA is now collecting metrics about the operations in the WHERE clause of each query. With this data, you can know what are the most common values in your SQL statements and evaluate their "selectivity". And for columns with a very high selectivity and no index, PoWA will suggest index creation to speed up you queries.

Screenshot:

http://powa.readthedocs.org/en/latest/stats_extensions/pg_qualstats.html#where-is-it-used-in-powa-web

Disruptive changes

It was a hard choice but if we want to implement ground-breaking features like the Missing Index Finder, we need to use the latest capacities of PostgreSQL and thus we decided to drop the compatibility with PostgreSQL 9.3.

Of course, we will continue to maintain PoWA v1.2 and you can continue to use it on your PostgreSQL 9.3 servers. In a nutshell, If you already use PoWA here's what you need to know:

  • If you're running PostgreSQL 9.4, we recommend that you switch to PoWA 2.0
  • If you're running PostgreSQL 9.3, you can either keep PoWA 1.2 or upgrade your PostgreSQL instance and switch to PoWA 2.0

 

Here's a detailed explanation on why we are Moving Fast and Breaking Things

Credits & Licence

DALIBO would like to thank all the developers who contributed to this release: Rodolphe Quiedeville, Hyunjun Kim, Grégoire Pineau, Ahmed Bessifi, exordium-frozen, Christopher Liu, menardorama and especially Ronan Dunklau and Julien Rouhaud for the hard work on the GUI.

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, features requests or patches using the GitHub tools or directly to powa@dalibo.com

Links :

For PoWA 2.0:

 

For the new stats extensions:

 

For the complete list of changes, please checkout the release note on http://powa.readthedocs.org/en/latest/releases/v2.0.html

About POWA :

PoWA is a PostgreSQL Workload Analyzer that gathers performance stats and provides real-time charts and graph to help monitor and tune your PostgreSQL servers. It is similar to Oracle AWR or SQL Server MDW.

Code & Demo at http://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 http://dalibo.github.io

Categories: Database, Open Source

Google Code-in 2014 wrap up with Wikimedia

Google Open Source Blog - Fri, 02/27/2015 - 18:00
The Wikimedia Foundation was one of the twelve mentoring organizations taking part in Google Code-in 2014, our contest introducing 13 to 17 year old students to working in open source communities. Below, Andre Klapper shares the accomplishments of several students who participated with Wikimedia during the contest.

The Wikimedia Foundation was proud to participate for a second time in Google Code-in. In this program, young students are introduced to free and open source software (FOSS) projects and invited to make practical contributions.
Between December 2014 and January 2015, 48 students successfully completed 226 Wikimedia tasks, supported by 30 mentors from our community. Those tasks include not only code development, but also documentation, research, and testing — leading to a wide range of achievements:

Thank you and congratulations to all the students who joined Wikimedia and supported its mission to freely share knowledge! Special kudos to Wikimedia’s two Grand Prize Winners: Danny Wu and Mateusz Maćkowski — and to our finalists Evan McIntire, Geoffrey Mon and Pranav Kumar! The full list of winners across all organizations can be found here.
We also wish to thank all our mentors for their generous commitment: we are especially grateful for the time they spent on weekends, coming up with task ideas, working with students and quickly reviewing their contributions. And last but not least, thank you to Google for organizing and running this contest, creating awareness of and interest in Free and Open Software projects.
We welcome more contributions to help improve our free and open software. Check out how you can contribute and our list of easy software bugs to start with.

By Andre Klapper, Wikimedia Foundation
Categories: Open Source

Eclipse Luna SR2 - Download Now

Eclipse News - Fri, 02/27/2015 - 16:21
Eclipse Luna SR2 (4.4.2) is now available!
Categories: Open Source

First Steps with Vagrant

DevX: Open Source Articles - Thu, 02/26/2015 - 13:21
Learn more about how Vagrant allows you to easily manage and control multiple virtual machines.
Categories: Open Source

COLA Tests m2e Connector

Date Created: February 25, 2015 - 23:06Date Updated: February 26, 2015 - 10:36Submitted by: Bruno Santos

COLA Tests m2e connector

JUnit + BDD = COLA Tests

COLA Tests is a BDD framework on the top of JUnit.

It easy to use, setup and above all, DO NOT require for a special JUnit runner, allowing you to keep using the JUnit runners that you are used to use.

More information is available here:
http://bmsantos.github.io/cola-maven-plugin/
http://bmsantos.github.io/cola-maven-plugin/docs/

Further details can be found in the respective github project pages:
https://github.com/bmsantos/cola-tests
https://github.com/bmsantos/cola-maven-plugin
https://github.com/bmsantos/m2eclipse-cola

Categories: Open Source

Eclipse UML Generators (Incubation)

Date Created: February 24, 2015 - 12:14Date Updated: February 27, 2015 - 05:51Submitted by: Cedric Notot

UML Generators is a new Eclipse project (http://www.eclipse.org/umlgen) which provides components that automatically bridge the gap between UML models and source code. Either by extracting data from UML models (and UML profiles or decoration models) to produce source code or by reverse-engineering source code to produce UML models.

This release provides a generator of Java and C (round-trip included) code.

Categories: Open Source