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

17 February 2016: NetBeans Day Netherlands

NetBeans Highlights - Fri, 04/29/2016 - 11:29
Free: Adam Bien, microservices, workshops, JavaScript, Java, and more! Join the latest NetBeans Day in the Netherlands.
Categories: Java, Open Source

The Responsibilities of an Open Source User

SourceForge.net: Front page news - Fri, 04/29/2016 - 05:40

User.

There are a number of things that come to mind when we encounter this term. It could be a person who, quite simply, uses something. But it could also be a derogatory term, used to describe a person who has abused the use of something.

In the world of open source, the term “user” has been pulled toward both ends of this spectrum, between the former definition and the latter. In the end however, what it really is and what it needs to be is neither. In the world of open source, a user is more of a contributor with duties and responsibilities.

More than Just a User
Users are not mere recipients of open source software. By working with an open source project users automatically become part of that project’s development. Because open source projects don’t have the same areas of documentation, quality control and marketing that proprietary projects do, it needs added manpower for these areas. That’s where users come in.

The role of users is crucial to open source. It is one of the pillars that make open source what it is- a place where users are not simply users, but a community that’s building up and developing a project as it is being used.

What Users Ought to Do
This responsibility may seem intimidating at first . But if you’ve been in the open source space long enough, you’re probably already doing what is expected of any open source user, and that’s to contribute to the project. While this often means contributing code, this isn’t the only way one can contribute:

  • Testing the software and providing feedback on it is essential to refining the project’s quality, functionality and ability to meet users’ needs.
  • Reporting bugs is another significant way of improving the software without writing any code.
  • Creating documentation is another meaningful contribution. Even small ones like tutorials or articles posted on social media can be very helpful, and can also serve as marketing.
  • Speaking of marketing, this is another great contribution. If you’re fond of using the software and think it’s fantastic, let others know. Talk about it, write about it; you could even teach others about it through workshops and meetups.

There are plenty of ways that users can fulfill their role and be the responsible contributors that they ought to be in the area of open source. No matter how small, it is essential that users remember and act on their responsibilities as this is key to ensuring the continuation and effectiveness of the open source system.

SourceForge on User Contributions
Here at SourceForge, we highly encourage not just developers but also users to contribute to their favorite projects. Even the smallest contribution can be a big help in the long run. Still unsure of how you can begin giving back to open source? Stay tuned to SourceForge as we tackle this topic on our coming posts.

Categories: Open Source

Aspose.Email Java (Maven) for Eclipse

Date Created: Thu, 2016-04-28 09:33Date Updated: Thu, 2016-04-28 14:59Submitted by: Aspose Marketplace This is new Plugin for Eclipse IDE by Aspose. This Plugin is intended for developers using Maven platform for Java developments and want to use Aspose.Email for Java in their projects.

NOTE: Aspose.Email for Java is Java API developed by Aspose is a set of Emails processing APIs to create, read and manipulate Outlook MSG, PST, EML and MHT email files from within a Java application without the need of using Microsoft Outlook. For the API detailed features list check the link.
The release contains the following features: Aspose.Email Maven Project (wizard)
  • By using this wizard plugin creates Maven project for using Aspose.Email for Java from New -> Project -> Maven-> Aspose.Email Maven Project
  • The wizard will also give option for downloading latest available Code Examples for using the API.

Aspose.Email Code Example (wizard) NOTE: Selected Code Examples (category) source codes will be copied under "com.aspose.email.examples" package. Resources needed for running examples will be copied to the corresponding directory (package) within "src/main/resources".

Other Features
  • Supports latest Eclipse Mars.1 (4.5.1) version
  • Compatible with Mac, Linux Flavors and Windows
  • Native IDE user experience
  • Open Source
Categories: Open Source

Exploring the Google Cloud Stream Processing Framework

DevX: Open Source Articles - Tue, 04/26/2016 - 20:19
Learn more about how to get started with creating pipelines in Python with Google's Dataflow framework.
Categories: Open Source

Profiler for Java Development

Date Created: Tue, 2016-04-26 08:10Date Updated: Thu, 2016-06-23 10:47Submitted by: Jevgeni Kabanov

XRebel is a development-time performance monitor for Java web apps. Find slow methods and HTTP calls, excessive queries, and hidden exceptions within your web application. Get rapid feedback in development where issues are easiest to debug - before committing your code.

Learn more and watch a quick demo of it in action here:
http://www.xrebel.com

Categories: Open Source

Projects of the Week, April 25, 2016

SourceForge.net: Front page news - Mon, 04/25/2016 - 05:16

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

AutoClicker

A full-fledged autoclicker with two modes of autoclicking, at your dynamic cursor location or at a prespecified location. The maximum amounts of clicked can also be set (or left as infinite). Hotkeys work in the background for convenience. If you want to automate group of mouse actions, Please try this https://sourceforge.net/projects/orphamielautoclicker/files/AutoClickers.exe/download Whats new in v1.0.0.2: 1. You can now change your hotkeys! 2. Changed the about page 3. Added a few minor options v1.0.0.1 : 1. Your settings are now saved from your last session so you only need to enter them once. (Includes last fixed location) 2. Added double clicking and triple clicking 3. Added Right clicking and middle clicking
[ Download AutoClicker ]


winPenPack: Portable Software Collection

winPenPack is a project that aims at collecting the most frequently used and most popular open source applications made portable, so that they can be executed without installation from any USB Flash Drive or Hard Disk. The winPenPack suites offer a wide range of portable applications like office tools, internet tools, multimedia tools, development tools, security applications and other frequently used utilities. Everything you need, completely free, open source and portable!
[ Download winPenPack: Portable Software Collection ]


Money Manager Ex

Money Manager Ex (mmex) is an easy to use, money management application. It is a personal finance manager. It can be used to track your net worth, income vs expenses etc. It runs on Windows, Linux and Mac OSX.
[ Download Money Manager Ex ]


GrandPerspective

GrandPerspective is a utility application for Mac OS X that graphically displays the disk usage of a file system.
[ Download GrandPerspective ]


digiCamControl

digiCamControl is a free and open source software. This allows you to save time by transferring images directly from your camera to your computer as you take each shot and allow to control camera shooting parameters.
[ Download digiCamControl ]


VeraCrypt

VeraCrypt is a free disk encryption software brought to you by IDRIX (https://www.idrix.fr) and based on TrueCrypt 7.1a. It adds enhanced security to the algorithms used for system and partitions encryption making it immune to new developments in brute-force attacks. It also solves many vulnerabilities and security issues found in TrueCrypt. This enhanced security adds some delay ONLY to the opening of encrypted partitions without any performance impact to the application use phase. This is acceptable to the legitimate owner but it makes it much harder for an attacker to gain access to the encrypted data. All released files are PGP signed with key ID=0x54DDD393, available on key servers and downloadable at https://www.idrix.fr/VeraCrypt/VeraCrypt_PGP_public_key.asc VeraCrypt can mount TrueCrypt volumes. It also can convert them to VeraCrypt format. Documentation: https://veracrypt.codeplex.com/documentation FAQ : https://veracrypt.codeplex.com/wikipage?title=FAQ
[ Download VeraCrypt ]


Arch Bang

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


Tibia Auto

Tibia Auto is the best BOT software for the popular game Tibia. It has all the features a bot should have including: cavebot, runemaker, creature info, spell casting, auto healing and much much more.
[ Download Tibia Auto ]


DxWnd

Windows hooker – intercepts system calls to make fullscreen programs running in a window, to support a better compatibility, to enhance video modes and to stretch timing. It is typically very useful to run old windows games.
[ Download DxWnd ]

Categories: Open Source

Students announced for Google Summer of Code 2016

Google Open Source Blog - Fri, 04/22/2016 - 20:08
2016 Google Summer of Code

It's that time of year again: 1,206 students have been accepted for our 2016 Google Summer of Code! Congratulations all around. We want to thank everyone who applied — it was another competitive year with 178 mentoring organizations receiving 7,543 proposals from 5,107 students.

Now we enter the community bonding period when students get acquainted with their mentors and familiarize themselves with their new community before they begin coding in May. In this period, students will do things like hang out in IRC channels and read documentation, become familiar with the code base and set their deadlines and milestones with their mentors.

If you want to review important dates or learn more about the 178 organizations that the accepted students will be working with over the summer, please visit the program website.

Here's to another exciting and productive summer of contributing to open source.

By Josh Simmons, Open Source Programs Office
Categories: Open Source

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

SourceForge.net: Front page news - Fri, 04/22/2016 - 05:15

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


winPenPack: Portable Software Collection

winPenPack is a project that aims at collecting the most frequently used and most popular open source applications made portable, so that they can be executed without installation from any USB Flash Drive or Hard Disk. The winPenPack suites offer a wide range of portable applications like office tools, internet tools, multimedia tools, development tools, security applications and other frequently used utilities. Everything you need, completely free, open source and portable!
[ Download winPenPack: Portable Software Collection ]


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 much more
[ Download MediaPortal ]


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 etc.
[ Download SQuirreL SQL Client ]


movistartv

Kodi Movistar+ TV es un ADDON para XBMC/ Kodi que permite disponer de un decodificador virtual de Movistar+ TV para distintos sistemas operativos. Las principales funcionalidades son: – ActualizaciĂłn automática de canales. – GuĂ­a de programaciĂłn (EPG). – Grabaciones en la Nube y en local. – VisualizaciĂłn de grabaciones en la nube. – SincronizaciĂłn de grabaciones a local para evitar su caducidad. – GestiĂłn avanzada de series. – Timeshift. – DistribuciĂłn de la señal por DLNA. – Ăšltimos 7 dĂ­as Sistemas operativos soportados: – Windows. – Mac OSX. – Android. – Linux 64 y 32 bits. – Raspberrys (B, B+ y 2), Bannana PI …
[ Download movistartv ]


Bodhi Linux

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


AutoClicker

A full-fledged autoclicker with two modes of autoclicking, at your dynamic cursor location or at a prespecified location. The maximum amounts of clicked can also be set (or left as infinite). Hotkeys work in the background for convenience. If you want to automate group of mouse actions, Please try this https://sourceforge.net/projects/orphamielautoclicker/files/AutoClickers.exe/download Whats new in v1.0.0.2: 1. You can now change your hotkeys! 2. Changed the about page 3. Added a few minor options v1.0.0.1 : 1. Your settings are now saved from your last session so you only need to enter them once. (Includes last fixed location) 2. Added double clicking and triple clicking 3. Added Right clicking and middle clicking
[ Download AutoClicker ]


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 ]


NamelessROM

NamelessRom is opportunity; an opportunity to have a voice to the development team of the after-market firmware that you run on your device. 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. This availability will allow you, the end-user, to have direct input into exactly what features and functions are included on the firmware that YOU run. NamelessRom == endless possibilities. Unless you have an iPhone, then you’re out of luck. Get more information and find support on our forums at https://nameless-rom.org
[ Download NamelessROM ]


Hydrogen

Hydrogen is an advanced drum machine for GNU/Linux, Windows and Mac OS X. It’s main goal is to bring professional yet simple and intuitive pattern-based drum programming.
[ Download Hydrogen ]

Categories: Open Source

Eclipse Newsletter - Discover Model-Based Engineering

Eclipse News - Thu, 04/21/2016 - 16:03
Eclipse Papyrus is an open source model-based engineering tool. Get a crash course on everything Papyrus.
Categories: Open Source

MapStruct Eclipse Plugin

Date Created: Wed, 2016-04-20 15:01Date Updated: Thu, 2016-04-21 09:13Submitted by: Andreas Gudian

An Eclipse plug-in for working with MapStruct

The plugin gives some assistence in projects that use MapStruct to generate bean mapping code.

Code-Completions

  • Completion of target and source properties in @Mapping annotation for bean mappings and for enum mappings
  • Completion of componentModel values in @Mapper annotation

Quick-Fixes

  • Quick-Fixes for error/warning message "Unmapped target property: ...":
    • Ignore unmapped target property adds @Mapping( target = "prop", ignore = true ) to the method
  • Quick-Fixes for error message "Can't map property X prop to Y prop. Consider to declare/implement a mapping method ...":
    • Add method: Y toY(X prop) adds an appropriate method declaration to the mapper.
    • Ignore unmapped target property adds @Mapping( target = "prop", ignore = true ) to the method.
Categories: Open Source

PDE Source Lookup

Date Created: Wed, 2016-04-20 14:56Date Updated: Thu, 2016-04-21 09:12Submitted by: Fred Bricon

Proof of Concept to automatically fetch missing source bundles from enabled p2 repositories, when opening a bundle jar (similar to what m2e does for Maven projects).

Sources are cached to ~/.eclipse/org.jboss.tools.pde.sourcelookup.core/sources

Requires an Eclipse Mars.2 or Neon installation (might work on older versions)
Requires Java 8 to run.

Categories: Open Source

Postgres-XL 9.5 R1 Released!

PostgreSQL News - Tue, 04/19/2016 - 01:00

The Postgres-XL community is pleased to announce the 1st release of Postgres-XL 9.5. This release has been fully synced up till PostgreSQL 9.5.2.

Postgres-XL is a massively parallel database built on top of, and very closely compatible with PostgreSQL 9.5 and its set of advanced features. Postgres-XL is fully open source and many parts of it will feed back directly or indirectly into later releases of PostgreSQL, as we begin to move towards a fully parallel sharded version of core PostgreSQL.

Postgres-XL is different because it supports both Business Intelligence and OLTP workloads in the same horizontally scalable server. This allows Postgres-XL to support a diverse range of workloads

  • OLTP workloads that need write-scalability as well as read-scalability
  • Business Intelligence requiring OLAP with massive parallelism
  • Operational Data Store/ Central Data Backbone
  • Distributed Key-Value store using JSONB, similar to NoSQL
  • Internet of Things applications
  • Mixed-workload environments

Star schema style SQL queries exhibit large performance gains from massively parallel processing (MPP). Many queries show fully linear performance gains, for example a 16-node XL cluster is 16 times faster than PostgreSQL on one node. Postgres-XL is able to successfully complete the complex TPC-H business intelligence benchmark, showing its capability to address much more than basic operations.

Besides proving its mettle on Business Intelligence workloads, Postgres-XL has performed remarkably well on OLTP workloads when running pgBench (based on TPC-B) benchmark. In a 4-Node (Scale: 4000) configuration, compared to PostgreSQL, XL gives up to 230% higher TPS (-70% latency comparison) for SELECT workloads and up to 130% (-56% latency comparison) for UPDATE workloads. Yet, it can scale much, much higher than even the largest single node server.

Postgres-XL’s High Availability functionality has also been enhanced in this release. Popular features such as BRIN indexes, JSONB and GIN index compression are fully supported, as are many popular extensions.

Postgres-XL is available for download here: www.postgres-xl.org/download/ You can go through XL’s comprehensive documentation here: files.postgres-xl.org/documentation/

We expect R2 to bring further features to Postgres-XL 9.5 in the next few months.

2ndQuadrant has led the development of Postgres-XL 9.5, building upon the work of many others over a long period of continuous development, with easily more than 10 man years of development. After six months of professional formal alpha-level testing & tuning, and an additional 2 months in Beta phase with user feedback, the project has now reached the next stage of maturity and we are now ready to release it for production use.

The research leading to these results has received funding from the European Union’s Seventh Framework Programme (FP7/2007-2015) under grant agreement n° 318633. Postgres-XL has also received support and assistance from European Space Agency's Gaia project, as well as other users in industry.

For more details, please visit: 2ndQuadrant.com/resources/postgres-xl/

Categories: Database, Open Source

Postgres-XL 9.5 R1 Released!

PostgreSQL News - Tue, 04/19/2016 - 01:00

The Postgres-XL community is pleased to announce the 1st release of Postgres-XL 9.5. This release has been fully synced up till PostgreSQL 9.5.2.

Postgres-XL is a massively parallel database built on top of, and very closely compatible with PostgreSQL 9.5 and its set of advanced features. Postgres-XL is fully open source and many parts of it will feed back directly or indirectly into later releases of PostgreSQL, as we begin to move towards a fully parallel sharded version of core PostgreSQL.

Postgres-XL is different because it supports both Business Intelligence and OLTP workloads in the same horizontally scalable server. This allows Postgres-XL to support a diverse range of workloads

  • OLTP workloads that need write-scalability as well as read-scalability
  • Business Intelligence requiring OLAP with massive parallelism
  • Operational Data Store/ Central Data Backbone
  • Distributed Key-Value store using JSONB, similar to NoSQL
  • Internet of Things applications
  • Mixed-workload environments

Star schema style SQL queries exhibit large performance gains from massively parallel processing (MPP). Many queries show fully linear performance gains, for example a 16-node XL cluster is 16 times faster than PostgreSQL on one node. Postgres-XL is able to successfully complete the complex TPC-H business intelligence benchmark, showing its capability to address much more than basic operations.

Besides proving its mettle on Business Intelligence workloads, Postgres-XL has performed remarkably well on OLTP workloads when running pgBench (based on TPC-B) benchmark. In a 4-Node (Scale: 4000) configuration, compared to PostgreSQL, XL gives up to 230% higher TPS (-70% latency comparison) for SELECT workloads and up to 130% (-56% latency comparison) for UPDATE workloads. Yet, it can scale much, much higher than even the largest single node server.

Postgres-XL’s High Availability functionality has also been enhanced in this release. Popular features such as BRIN indexes, JSONB and GIN index compression are fully supported, as are many popular extensions.

Postgres-XL is available for download here: www.postgres-xl.org/download/ You can go through XL’s comprehensive documentation here: files.postgres-xl.org/documentation/

We expect R2 to bring further features to Postgres-XL 9.5 in the next few months.

2ndQuadrant has led the development of Postgres-XL 9.5, building upon the work of many others over a long period of continuous development, with easily more than 10 man years of development. After six months of professional formal alpha-level testing & tuning, and an additional 2 months in Beta phase with user feedback, the project has now reached the next stage of maturity and we are now ready to release it for production use.

The research leading to these results has received funding from the European Union’s Seventh Framework Programme (FP7/2007-2015) under grant agreement n° 318633. Postgres-XL has also received support and assistance from European Space Agency's Gaia project, as well as other users in industry.

For more details, please visit: 2ndQuadrant.com/resources/postgres-xl/

Categories: Database, Open Source

Aspose.Tasks Java (Maven) for Eclipse

Date Created: Mon, 2016-04-18 12:08Date Updated: Tue, 2016-04-19 09:26Submitted by: Aspose Marketplace This is new Plugin for Eclipse IDE by Aspose. This Plugin is intended for developers using Maven platform for Java developments and want to use Aspose.Tasks for Java in their projects.

NOTE: Aspose.Tasks for Java is Java API developed by Aspose is a project management component that enables Java application developers to provide Microsoft Project ® documents manipulation capability in their applications – all without using Microsoft Project ®. For the API detailed features list check the link.
The release contains the following features: Aspose.Tasks Maven Project (wizard)
  • By using this wizard plugin creates Maven project for using Aspose.Tasks for Java from New -> Project -> Maven-> Aspose.Tasks Maven Project
  • The wizard will also give option for downloading latest available Code Examples for using the API.

Aspose.Tasks Code Example (wizard) NOTE: Selected Code Examples (category) source codes will be copied under "com.aspose.tasks.examples" package. Resources needed for running examples will be copied to the corresponding directory (package) within "src/main/resources".

Other Features
  • Supports latest Eclipse Mars.1 (4.5.1) version
  • Compatible with Mac, Linux Flavors and Windows
  • Native IDE user experience
  • Open Source
Categories: Open Source

Projects of the Week, April 18, 2016

SourceForge.net: Front page news - Mon, 04/18/2016 - 05:30

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

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 much more
[ Download MediaPortal ]


Seer

This is a quick look tool for Windows. (Linux will be supported in the future.) Acts just like the one in OS X , but Seer is more powerful and faster. Minimum supported : Windows Vista. ——————————————————————– When will Seer connect to internet quietly? 1, check for application updates when Seer started; 2, triggered a markdown file and this file contains a image with internet url; 3, check for new plugins. You don’t want Seer connect to internet at all? 1, turn off “Auto check for updates” in “Settings – General”; 2, delete files named “ssleay32.dll” and “libeay32.dll” in installation folder. ——————————————————————–
[ Download Seer ]


Warzone 2100

You command the forces of “The Project” in a battle to rebuild the world after mankind has almost been destroyed by nuclear missiles. The game offers campaign, multi-player and single-player skirmish modes, and an extensive tech tree. NOTE: Our source repo is now at https://github.com/Warzone2100/warzone2100
[ Download Warzone 2100 ]


OS X Portable Applications

OS X FOSS portable applications are packaged so you can carry around on any portable device, USB thumb drive, iPod, portable hard drive, memory card, other portable device (or also on your internal hard disk), taking your preferences with you.
[ Download OS X Portable Applications ]


OpenMandriva Lx

OpenMandriva Lx is an exciting free Desktop Operating System that aims to cater to and interest first time and advanced users alike. It has the breadth and depth of an advanced system but is designed to be simple and straightforward in use. OpenMandriva Lx comes from a 100% community-driven association that believes in the values of free software & collaboration and whose founding values are development, equality, co-operation, openness, freedom, group achievement, independence, and solidarity. Our sources can be found here: https://github.com/OpenMandrivaAssociation Our spohisticated build system can be found here: http://abf.openmandriva.org/ Talk to us: * IRC – #openmandriva-cooker on freenode.net * Forums – https://forums.openmandriva.org * Mailing list – https://wiki.openmandriva.org/en/Mailinglist Report a bug or new feature: * Bugzilla – https://issues.openmandriva.org
[ Download OpenMandriva Lx ]


Uniform Server

The Uniform Server is a lightweight server solution for running a web server under the WindowsOS. Less than 24MB! Modular design, includes the latest versions of Apache2, Perl5, PHP (switch between PHP53, PHP54, PHP55 or PHP56), MySQL5 or MariaDB5, phpMyAdmin or Adminer4. Run from either hard drive or USB memory stick… NO INSTALLATION REQUIRED! NO REGISTRY DUST! Just UNPACK and FIRE UP!
[ Download Uniform Server ]


Wings 3D

Wings 3D is an advanced subdivision modeler that is both powerful and easy to use (inspired by Nendo and Mirai from Izware).
[ Download Wings 3D ]


Freeplane

Application for Mind Mapping, Knowledge Management, Project Management. Develop, organize and communicate your ideas and knowledge in the most effective way.
[ Download Freeplane ]


Password Safe

Password Safe is a password database utility. Users can keep their passwords securely encrypted on their computers. A single Safe Combination unlocks them all.
[ Download Password Safe ]

Categories: Open Source

PostgresOpen 2016 - Call For Papers!

PostgreSQL News - Mon, 04/18/2016 - 01:00

Greetings!

The Call For Papers for PostgresOpen 2016, being held in Dallas, Texas from September 13th to 16th, is now open!

If you are working with PostgreSQL, please visit:

https://2016.postgresopen.org/callforpapers/

and submit a talk!

Presentations can be on any topic related to PostgreSQL, including, but not limited to, case studies, experiences, tools and utilities, migration stories, existing features, new feature development, benchmarks, performance tuning, and more!

The 2016 PostgresOpen Committee looks forward to bringing the best PostgreSQL presentations and tutorials from speakers around the world to Dallas, Texas! We're only able to do that with support from our great sponsors! If you are interested in sponsoring, please visit our sponsoring campaign:

https://2016.postgresopen.org/becomesponsor/

Anyone and everyone in the PostgreSQL community is encouraged to submit a talk. Talks will be accepted up until May 30th, Anywhere on Earth (AoE), also known as: 2015-05-30 23:59:59-12:00.

Speakers will be notified by June 6th, 2015 AoE, with the schedule to be published once selected speakers have confirmed.

Early Bird registration for PostgresOpen 2016 will open on May 9th!

Join us in celebrating our 6th conference year! We look forward to seeing everyone in Dallas!

Any questions? Please contact: program2016@postgresopen.org.

Stephen Frost

PostgresOpen 2016 Committee Chair

http://2016.postgresopen.org

Categories: Database, Open Source

PostgresOpen 2016 - Call For Papers!

PostgreSQL News - Mon, 04/18/2016 - 01:00

Greetings!

The Call For Papers for PostgresOpen 2016, being held in Dallas, Texas from September 13th to 16th, is now open!

If you are working with PostgreSQL, please visit:

https://2016.postgresopen.org/callforpapers/

and submit a talk!

Presentations can be on any topic related to PostgreSQL, including, but not limited to, case studies, experiences, tools and utilities, migration stories, existing features, new feature development, benchmarks, performance tuning, and more!

The 2016 PostgresOpen Committee looks forward to bringing the best PostgreSQL presentations and tutorials from speakers around the world to Dallas, Texas! We're only able to do that with support from our great sponsors! If you are interested in sponsoring, please visit our sponsoring campaign:

https://2016.postgresopen.org/becomesponsor/

Anyone and everyone in the PostgreSQL community is encouraged to submit a talk. Talks will be accepted up until May 30th, Anywhere on Earth (AoE), also known as: 2015-05-30 23:59:59-12:00.

Speakers will be notified by June 6th, 2015 AoE, with the schedule to be published once selected speakers have confirmed.

Early Bird registration for PostgresOpen 2016 will open on May 9th!

Join us in celebrating our 6th conference year! We look forward to seeing everyone in Dallas!

Any questions? Please contact: program2016@postgresopen.org.

Stephen Frost

PostgresOpen 2016 Committee Chair

http://2016.postgresopen.org

Categories: Database, Open Source

pgBackRest 1.0 Released

PostgreSQL News - Sun, 04/17/2016 - 01:00

April 17, 2016: Crunchy Data is proud to announce pgBackRest 1.0, Reliable PostgreSQL Backup & Restore.

Release 1.0

The first stable of release of pgBackRest introduces a new, more capable repository format, simpler configuration, and comprehensive support for backup and restore of symlinked directories and files.

There are a number of important changes in pgBackRest 1.0 so be sure to read the release notes very carefully before upgrading.

Links Features Multithreaded Backup & Restore

Compression is usually the bottleneck during backup operations but, even with now ubiquitous multi-core servers, most database backup solutions are still single-threaded. pgBackRest solves the compression bottleneck with multithreading.

Utilizing multiple cores for compression makes it possible to achieve 1TB/hr raw throughput even on a 1Gb/s link. More cores and a larger pipe lead to even higher throughput.

Local or Remote Operation

A custom protocol allows pgBackRest to backup, restore, and archive locally or remotely via SSH with minimal configuration. An interface to query PostgreSQL is also provided via the protocol layer so that remote access to PostgreSQL is never required, which enhances security.

Full, Incremental, & Differential Backups

Full, differential, and incremental backups are supported. pgBackRest is not susceptible to the time resolution issues of rsync, making differential and incremental backups completely safe.

Backup Rotation & Archive Expiration

Retention polices can be set for full and differential backups to create coverage for any timeframe. WAL archive can be maintained for all backups or strictly for the most recent backups. In the latter case WAL required to make older backups consistent will be maintained in the archive.

Backup Integrity

Checksums are calculated for every file in the backup and rechecked during a restore. After a backup finishes copying files, it waits until every WAL segment required to make the backup consistent reaches the repository.

Backups in the repository are stored in the same format as a standard PostgreSQL cluster (including tablespaces). If compression is disabled and hard links are enabled it is possible to snapshot a backup in the repository and bring up a PostgreSQL cluster directly on the snapshot. This is advantageous for terabyte-scale databases that are time consuming to restore in the traditional way.

All operations utilize file and directory level fsync to ensure durability.

Backup Resume

An aborted backup can be resumed from the point where it was stopped. Files that were already copied are compared with the checksums in the manifest to ensure integrity. Since this operation can take place entirely on the backup server, it reduces load on the database server and saves time since checksum calculation is faster than compressing and retransmitting data.

Streaming Compression & Checksums

Compression and checksum calculations are performed in stream while files are being copied to the repository, whether the repository is located locally or remotely.

If the repository is on a backup server, compression is performed on the database server and files are transmitted in a compressed format and simply stored on the backup server. When compression is disabled a lower level of compression is utilized to make efficient use of available bandwidth while keeping CPU cost to a minimum.

Delta Restore

The manifest contains checksums for every file in the backup so that during a restore it is possible to use these checksums to speed processing enormously. On a delta restore any files not present in the backup are first removed and then checksums are taken for the remaining files. Files that match the backup are left in place and the rest of the files are restored as usual. Since this process is multithreaded, it can lead to a dramatic reduction in restore times.

Advanced Archiving

Dedicated commands are included for both pushing WAL to the archive and retrieving WAL from the archive.

The push command automatically detects WAL segments that are pushed multiple times and de-duplicates when the segment is identical, otherwise an error is raised. The push and get commands both ensure that the database and repository match by comparing PostgreSQL versions and system identifiers. This precludes the possibility of misconfiguring the WAL archive location.

Asynchronous archiving allows compression and transfer to be offloaded to another process which maintains a continuous connection to the remote server, improving throughput significantly. This can be a critical feature for databases with extremely high write volume.

Tablespace & Link Support

Tablespaces are fully supported and on restore tablespaces can be remapped to any location. It is also possible to remap all tablespaces to one location with a single command which is useful for development restores.

File and directory links are supported for any file or directory in the PostgreSQL cluster. When restoring it is possible to restore all links to their original locations, remap some or all links, or restore some or all links as normal files or directories within the cluster directory.

Compatibility with PostgreSQL >= 8.3

pgBackRest includes support for versions down to 8.3, since older versions of PostgreSQL are still regularly utilized.

About

pgBackRest aims to be a simple, reliable backup and restore system that can seamlessly scale up to the largest databases and workloads. Instead of relying on traditional backup tools like tar and rsync, pgBackRest implements all backup features internally and uses a custom protocol for communicating with remote systems. Removing reliance on tar and rsync allows for better solutions to database-specific backup challenges. The custom remote protocol allows for more flexibility and limits the types of connections that are required to perform a backup which increases security.

Crunchy Data supports the ongoing and active development of pgBackRest as an entirely open source project, released under the BSD-compatible MIT license.

Categories: Database, Open Source

pgBackRest 1.0 Released

PostgreSQL News - Sun, 04/17/2016 - 01:00

April 17, 2016: Crunchy Data is proud to announce pgBackRest 1.0, Reliable PostgreSQL Backup & Restore.

Release 1.0

The first stable of release of pgBackRest introduces a new, more capable repository format, simpler configuration, and comprehensive support for backup and restore of symlinked directories and files.

There are a number of important changes in pgBackRest 1.0 so be sure to read the release notes very carefully before upgrading.

Links Features Multithreaded Backup & Restore

Compression is usually the bottleneck during backup operations but, even with now ubiquitous multi-core servers, most database backup solutions are still single-threaded. pgBackRest solves the compression bottleneck with multithreading.

Utilizing multiple cores for compression makes it possible to achieve 1TB/hr raw throughput even on a 1Gb/s link. More cores and a larger pipe lead to even higher throughput.

Local or Remote Operation

A custom protocol allows pgBackRest to backup, restore, and archive locally or remotely via SSH with minimal configuration. An interface to query PostgreSQL is also provided via the protocol layer so that remote access to PostgreSQL is never required, which enhances security.

Full, Incremental, & Differential Backups

Full, differential, and incremental backups are supported. pgBackRest is not susceptible to the time resolution issues of rsync, making differential and incremental backups completely safe.

Backup Rotation & Archive Expiration

Retention polices can be set for full and differential backups to create coverage for any timeframe. WAL archive can be maintained for all backups or strictly for the most recent backups. In the latter case WAL required to make older backups consistent will be maintained in the archive.

Backup Integrity

Checksums are calculated for every file in the backup and rechecked during a restore. After a backup finishes copying files, it waits until every WAL segment required to make the backup consistent reaches the repository.

Backups in the repository are stored in the same format as a standard PostgreSQL cluster (including tablespaces). If compression is disabled and hard links are enabled it is possible to snapshot a backup in the repository and bring up a PostgreSQL cluster directly on the snapshot. This is advantageous for terabyte-scale databases that are time consuming to restore in the traditional way.

All operations utilize file and directory level fsync to ensure durability.

Backup Resume

An aborted backup can be resumed from the point where it was stopped. Files that were already copied are compared with the checksums in the manifest to ensure integrity. Since this operation can take place entirely on the backup server, it reduces load on the database server and saves time since checksum calculation is faster than compressing and retransmitting data.

Streaming Compression & Checksums

Compression and checksum calculations are performed in stream while files are being copied to the repository, whether the repository is located locally or remotely.

If the repository is on a backup server, compression is performed on the database server and files are transmitted in a compressed format and simply stored on the backup server. When compression is disabled a lower level of compression is utilized to make efficient use of available bandwidth while keeping CPU cost to a minimum.

Delta Restore

The manifest contains checksums for every file in the backup so that during a restore it is possible to use these checksums to speed processing enormously. On a delta restore any files not present in the backup are first removed and then checksums are taken for the remaining files. Files that match the backup are left in place and the rest of the files are restored as usual. Since this process is multithreaded, it can lead to a dramatic reduction in restore times.

Advanced Archiving

Dedicated commands are included for both pushing WAL to the archive and retrieving WAL from the archive.

The push command automatically detects WAL segments that are pushed multiple times and de-duplicates when the segment is identical, otherwise an error is raised. The push and get commands both ensure that the database and repository match by comparing PostgreSQL versions and system identifiers. This precludes the possibility of misconfiguring the WAL archive location.

Asynchronous archiving allows compression and transfer to be offloaded to another process which maintains a continuous connection to the remote server, improving throughput significantly. This can be a critical feature for databases with extremely high write volume.

Tablespace & Link Support

Tablespaces are fully supported and on restore tablespaces can be remapped to any location. It is also possible to remap all tablespaces to one location with a single command which is useful for development restores.

File and directory links are supported for any file or directory in the PostgreSQL cluster. When restoring it is possible to restore all links to their original locations, remap some or all links, or restore some or all links as normal files or directories within the cluster directory.

Compatibility with PostgreSQL >= 8.3

pgBackRest includes support for versions down to 8.3, since older versions of PostgreSQL are still regularly utilized.

About

pgBackRest aims to be a simple, reliable backup and restore system that can seamlessly scale up to the largest databases and workloads. Instead of relying on traditional backup tools like tar and rsync, pgBackRest implements all backup features internally and uses a custom protocol for communicating with remote systems. Removing reliance on tar and rsync allows for better solutions to database-specific backup challenges. The custom remote protocol allows for more flexibility and limits the types of connections that are required to perform a backup which increases security.

Crunchy Data supports the ongoing and active development of pgBackRest as an entirely open source project, released under the BSD-compatible MIT license.

Categories: Database, Open Source

4 Ways Open Source Can Help Boost Your Career

SourceForge.net: Front page news - Fri, 04/15/2016 - 05:20

If you’re looking to have a successful career in IT, your best start may be in open source.

According to executive recruiter David Patterson, while many better-paying opportunities are currently in proprietary software, the future is clearly in open source. Today there are numerous databases, analytics tools, programming languages and more in the open source arena. Big names such as SAP, Microsoft and IBM are using open source to extend their reach, with numerous others using open source systems in their day-to-day operations.

Open source has reached almost every area of technology, clearly making it tomorrow’s career-maker today. And there’s more than one way that open source can help build your career:

1. Provide career-relevant learning experiences
By participating in open source projects, you undoubtedly gain experiences and skills that are highly relevant to the IT industry. This of course includes coding capabilities and familiarity with various programming tools. But apart from these technical skills, involvement in open source also helps develop other sought-after skills. Skills like good planning, problem-solving, teamwork, project management and leadership can all be gained from open source experience and will look impressive on any resume.

2. Establish and develop industry connections
One of the great things about open source is that it gives you direct access to developers and maintainers who are more than happy to teach you what they know once you show interest. These connections are vital to helping you increase your knowledge and experience, and also getting you connected to those who can give you the career you seek.

3. Help you find and get found by employers
As stated in the previous point, involvement in the open source community can get you connected to potential employers. By being immersed in open source, you can also zone in on the types of projects you’re really interested in, and gain access to various growth and career opportunities.

4. Provide career opportunities
Years ago thriving careers in open source would have been unthinkable, but as current trends now show, this is inevitable. Even non-developers can establish a career in open source as community managers, documentation experts, marketing specialists and more. Experience in open source can also open doors for promotions to senior level positions.

Open source is continuously growing, and so are its career benefits and opportunities. With open source development firmly grounded in your skill set, there’s no telling how far you could go with your career.

Build Your Open Source Portfolio with SourceForge
SourceForge provides free open source hosting and distribution that open source developers can take advantage of. We’ve assisted numerous developers with projects that have honed and expanded their skill set. With our help, you too can earn your stripes and build an impressive open source portfolio. For more innovative open source software solutions, always stay tuned to SourceForge.

Categories: Open Source