SQL-Ledger

Last updated
SQL-Ledger
Developer(s) DWS Systems Inc.
Stable release
3.2.10 [1]   OOjs UI icon edit-ltr-progressive.svg / 22 June 2021;17 months ago (22 June 2021)
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.com

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.

Contents

Capabilities

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.

Supported languages

  • English (US,GB)
  • Arabic (EG)
  • Indonesian
  • Brazilian Portuguese
  • Bulgarian
  • Catalan
  • Czech
  • Danish
  • Dutch (NL,BE)
  • Estonian
  • Finnish
  • French (FR,QC)
  • German (DE,CH)
  • Greek
  • Hungarian
  • Icelandic
  • Indonesia
  • Italian
  • Japanese
  • Latvian
  • Lithuanian
  • Norwegian Bokmål
  • Polish
  • Portuguese
  • Russian
  • Simplified Chinese
  • Slovak
  • Spanish (ES,EC,MX,PA,PY,SV,VE)
  • Swedish
  • Traditional Chinese
  • Turkish
  • Ukrainian
  • tamil
  • urdu

Business model

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.

Licensing issues

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.

See also

Related Research Articles

<span class="mw-page-title-main">MySQL</span> SQL database engine software

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.

<span class="mw-page-title-main">LAMP (software bundle)</span> Acronym for a common web hosting solution

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.

<span class="mw-page-title-main">Komodo Edit</span> Text editor for dynamic programming languages

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".

<span class="mw-page-title-main">LedgerSMB</span> Accounting software planning system

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 Open-source e-mail server

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.

<span class="mw-page-title-main">Drizzle (database server)</span>

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.

<span class="mw-page-title-main">GNU General Public License</span> Series of free software licenses

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.

<span class="mw-page-title-main">ApexKB</span>

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.

<span class="mw-page-title-main">Tryton</span>

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.

References

  1. http://www.sql-ledger.com/misc/whatsnew.html; retrieved: 4 November 2021.
  2. 1 2 "SQL-Ledger ERP" . Retrieved 2007-05-07.
  3. COPYING
  4. 1 2 "Legal Stuff" . Retrieved 2012-04-08.
  5. "sql-ledger may belong in non-free".
  6. "SQL-Ledger Relicensed, Community Gagged". Slashdot.
  7. "When GPL software goes bad". Realm of the Purple Dropbear. Archived from the original on 2007-06-18.