Developer(s) | DWS Systems Inc. |
---|---|
Stable release | |
Repository | |
Operating system | Any Unix-like system including macOS, Windows [2] |
Platform | Cross-platform [2] |
Type | double entry accounting system |
License | GPLv2 [3] [4] |
Website | www |
SQL-Ledger is an ERP and double entry accounting system. Accounting data is stored in an SQL database server and a standard web browser can be used as its user interface. The system uses the Perl language with a database interface module for processing and PostgreSQL for data storage which is the preferred platform. The download version also includes schemas for IBM's DB2 database server as well as Oracle.
SQL-Ledger offers all of the standard features of SMB accounting software. Specific customization is available as part of an enterprise support contract.
Not only is the user interface multi-lingual, but it also offers the ability to print out statements, invoices, and the like in the language of the customer, even if the user does not know the language in which the content is being printed.
|
|
|
DWS generates their revenue from selling a manual and customizations. For free, DWS provides the source code of the current and all the previous versions, installation instructions, an FAQ collection and a user forum.
Version 3.0 of this program was released under the GNU GPL 2.0 license. [4]
Version 3.2.6 released in December 2017.
At its inception, SQL-Ledger used the GNU GPL 2.0 license. In 2005, Debian legal questioned whether or not the program belonged in Free or Non-Free, due to wording in the Terms and Conditions notice in the tarball. [5] In late 2006, LedgerSMB was created as a secure fork of SQL-Ledger. In early 2007, SQL-Ledger 2.8 was released under the 'SQL-Ledger Open Source License, [6] a license which retroactively revokes all previous licenses under which the covered code had been released. [7] That version also contained an "anti-forking" clause. However, within a month, SQL-Ledger 2.8.1 was released, under the GNU GPL 2.0.
MySQL is an open-source relational database management system (RDBMS). Its name is a combination of "My", the name of co-founder Michael Widenius's daughter My, and "SQL", the acronym for Structured Query Language. A relational database organizes data into one or more data tables in which data may be related to each other; these relations help structure the data. SQL is a language programmers use to create, modify and extract data from the relational database, as well as control user access to the database. In addition to relational databases and SQL, an RDBMS like MySQL works with an operating system to implement a relational database in a computer's storage system, manages users, allows for network access and facilitates testing database integrity and creation of backups.
PHP-Nuke is a web-based automated news publishing and content management system based on PHP and MySQL originally written by Francisco Burzi. The system is controlled using a web-based user interface. PHP-Nuke was originally a fork of the Thatware news portal system by David Norman.
MaxDB is an ANSI SQL-92 compliant relational database management system (RDBMS) from SAP AG, which was also delivered by MySQL AB from 2003 to 2007. MaxDB is targeted for large SAP environments e.g. mySAP Business Suite, and other applications that require enterprise-level database functionality.
Multi-licensing is the practice of distributing software under two or more different sets of terms and conditions. This may mean multiple different software licenses or sets of licenses. Prefixes may be used to indicate the number of licenses used, e.g. dual-licensed for software licensed under two different licenses.
LAMP is an acronym denoting one of the most common software stacks for many of the web's most popular applications. However, LAMP now refers to a generic software stack model and its components are largely interchangeable.
The following comparison of accounting software documents the various features and differences between different professional accounting software, personal and small enterprise software, medium-sized and large-sized enterprise software, and other accounting packages. The comparison only focus considering financial and external accounting functions. No comparison is made for internal/management accounting, cost accounting, budgeting, or integrated MAS accounting.
Komodo Edit is a free and open source text editor for dynamic programming languages. It was introduced in January 2007 to complement ActiveState's commercial Komodo IDE. As of version 4.3, Komodo Edit is built atop the Open Komodo project. Komodo IDE is no longer supported and maintained by developers for Python.
ADempiere is an Enterprise Resource Planning or ERP software package released under a free software license. The verb adempiere in Italian means "to fulfill a duty" or "to accomplish".
LedgerSMB is a free software double entry accounting and Enterprise Resource Planning (ERP) system. Accounting data is stored in a SQL database server and a standard web browser can be used as its user interface. The system uses the Perl programming language and a Perl database interface module for processing, and PostgreSQL for data storage. LedgerSMB is a client-server application, with server access through a web browser.
hMailServer is a free email server for Windows created by Martin Knafve. It runs as a Windows service and includes administration tools for management and backup. It has support for IMAP, POP3, and SMTP email protocols. It can use external database engines such as MySQL, MS SQL or PostgreSQL, or an internal MS SQL Compact Edition engine to store configuration and index data. The actual email messages are stored on disk in a raw MIME format. It has active support and development forums.
EGroupware is free open-source groupware software intended for businesses from small to enterprises. Its primary functions allow users to manage contacts, appointments, projects and to-do lists. The project releases its software under the terms of GNU General Public License (GPL).
PostBooks is a proprietary accounting and enterprise resource planning business system geared toward small to medium-sized businesses. It used to be released under an open source CPAL license on GitHub, but was made non-free in June 2019. Postbooks was based on the commercially licensed xTuple ERP system created by xTuple, a private software company based in Norfolk, Virginia (VA), United States.
Drizzle is a discontinued free software/open-source relational database management system (DBMS) that was forked from the now-defunct 6.0 development branch of the MySQL DBMS.
The GNU General Public License is a series of widely used free software licenses that guarantee end users the four freedoms to run, study, share, and modify the software. The license was the first copyleft for general use and was originally written by the founder of the Free Software Foundation (FSF), Richard Stallman, for the GNU Project. The license grants the recipients of a computer program the rights of the Free Software Definition. These GPL series are all copyleft licenses, which means that any derivative work must be distributed under the same or equivalent license terms. It is more restrictive than the Lesser General Public License and even further distinct from the more widely used permissive software licenses BSD, MIT, and Apache.
ApexKB, is a discontinued free and open-source script for collaborative search and knowledge management powered by a shared enterprise bookmarking engine that is a fork of KnowledgebasePublisher. It was publicly announced on 29 September 2008. A stable version of Jumper was publicly released under the GNU General Public License and made available on SourceForge on 26 March 2009.
Tryton is a three-tier high-level general purpose computer application platform on top of which is built an Enterprise resource planning (ERP) business solution through a set of Tryton modules. The three-tier architecture consists of the Tryton client, the Tryton server and the Database management system.
The following outline is provided as an overview of and topical guide to the Perl programming language:
The following outline is provided as an overview of and topical guide to MySQL:
metasfresh is an open source/free ERP software designed and developed for SMEs. metasfresh is an actively maintained fork of ADempiere and can be used and distributed freely. It does not require a contributor license agreement from partners or contributors. There is no closed source code, and the planning and development happen openly in the community. metasfresh was included in the Top 9 Open Source ERP to consider by opensource.com.