Why use Free Open Source software

Why use Free Open Source software

Why beg, borrow or steal when you can own??? Use open source software

Firstly I would like to tell you what is open source software mean

Generically, open source refers to a program in which the source code is available to the general public for use and/or modification from its original design free of charge, i.e., open.

Open source code is typically created as a collaborative effort in which programmers improve upon the code and share the changes within the community. Open source sprouted in the technological community as a response to proprietary software owned by corporations.

Why use Free Open Source

1.    Access to the robust, professional and latest technologies
Open Source gives everyone the power of a professional, rapidly growing and changing tool set to manipulate digital media. Open Source is developed by developers across the world and incorporates the newest technologies.

2.    Technology advances based on user demand
Open source solutions ensure that the next digital technology will be determined  and created ‘by the people’ and not by a few select corporations.

3.    Free and accessible to all
Everyone has free access to open source tools. Technology is available to all and not just to the select few who can afford expensive software.

4.    Price: the initial cost of free and open source software (FOSS) is much less, Money saved (not stolen) is money earned.

5.    Third, open source applications can be even more secure than their commercial equivalents. Open source communities fixed security vulnerabilities twice as quickly as commercial software vendors did, according to a recent study by Veracode

6.    Informal support structures: A hallmark of good FOSS projects is an incredible community of informal, freely available support centered around email lists, wikis, irc chat channels, open documentation and bug trackers. These may take a bit more digging, a bit more patience, and a bit more respect than demanding (and paying for) commercial level support.

Use legally, why beg, borrow or steal when you can own?!??

When an Open Source solution does not exist, Freeware (free versions or starter versions of non open source software) is recommended

Connect to 2 databases at the same time in PHP

if your database user has access to both databases and they are on the same server, you can use one connection and just specify the database you want to work with before the table name. Example:

SELECT column
FROM database.table

Depending on what you need to do, you might be able to do an INSERT INTO and save a bunch of processing time.

INSERT INTO database1.table (column)
SELECT database2.table.column
FROM database2.table
select and insert at same time

fetch from one table and insert in single query