ï»¿Project Part 1 Task 2: Provide Open Source Server Solutions
Database Server solution: PostgreSQL is an object-relational Database software solution that offers vast features as compared to the bigger commercial manufacturers such as Oracle and IBM. PostgreSQL has wide functionality, it allows for the use of two different types of interface, a GUI (simple clicking) and a SQL for those who like to get more in depth with the program. PostgreSQL works on most operating systems such as Windows, Linux, Mac, and Unix systems. It contains many array of tools and services.
Full ACID (Atomicity, Consistency, Isolation, and Durability) Compliancy. Supports Commercial and ...view middle of the document...
Max Columns per Row
250-1600 depending on type
Data Type Limits:
Max DATE Value
Max CHAR Size
Max NUMBER Size
Min DATE Value
When it comes to deciding on which open source web server software to utilize, there are a lot of different options, such as, Apache, LightTPD, NGiNX, Boa, Cherokee, etc. The one that stands out the most is Apache. Apache is the most popular web server to date. It is the leading web server that is used most over all others including open source and non-open source options, such as, Microsoft's IIS, Google's proprietary custom servers. Apache is by far the leading Web Server open source software to this day, it is because of its performance, functionality, stability, security, and the best thing of all its cost. Apache is 100% FREE. Apache has cross-platform capabilities to where it can be used on almost any operating system such as Windows, Linux, and Mac. Features of Apache is that eh server offers, Basic access authentication & digest access authentication, SSL/TLS HTTPS, virtual hosting, CGI, FCGI, SCGI, Java, SSI, ISAPI, runs in user space versus kernel space, Administration console, and IPv4 & IPv6 addressing.
Open source for File Servers, there are many great options out there, hereâ€™s just a few of the open source software: FileZilla, Cerberus, and Samba. Cerberus is great but only works with Windows systems whereas FileZilla works on both Windows and Linux. I recommend FileZilla because FileZilla Client is a fast and reliable cross-platform FTP, FTPS and SFTP client with lots of useful features and an intuitive graphical user interface.
Here are some key points about FileZilla which may explain why I recommend FileZilla:
Easy to use
Supports FTP, FTP over SSL/TLS (FTPS) and SSH File Transfer Protocol (SFTP)
Cross-platform. Runs on Windows, Linux, *BSD, Mac OS X and more
Available in many languages
Supports resume and transfer of large files >4GB
Tabbed user interface
Powerful Site Manager and transfer queue
Drag & drop support
Configurable transfer speed limits
Network configuration wizard
Remote file editing
HTTP/1.1, SOCKS5 and FTP-Proxy support
Logging to file
Synchronized directory browsing
Remote file search
iRedMail is a full-featured mail server solution, it provides basic features like unlimited virtual mail accounts, POP3/IMAP/SMTP, AJAX webmail. Deploy fully-featured mail server in LESS THAN 1 minute, low maintenance after deployment. Unlimited number of virtual mail domains, users, mail lists, aliases, admins.
Stores mail accounts in one of...