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;3 years 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 that 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

A LAMP is one of the most common software stacks for the web's most popular applications. Its generic software stack model has largely interchangeable components.

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.

ADempiere is an enterprise resource planning (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 libre software double entry accounting and enterprise resource planning (ERP) system, focused on functionality required by small (self-employment) and medium size businesses. However, companies with millions of journal lines should also feel supported. Accounting data is stored in a free to use database server (PostgreSQL) and a standard web browser can be used as its user interface. The software is suited for hosting locally as well as on various public cloud providers. Commercial support can be obtained from several providers.

hMailServer Open-source e-mail server

hMailServer was a free email server for Windows created by Martin Knafve. It ran as a Windows service and includes administration tools for management and backup. It had support for IMAP, POP3, and SMTP email protocols. It could 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 were stored on disk in a raw MIME format. As of January 15th, 2022, active support and development were officially halted, although version 5.6 will continue to receive updates for critical bugs.

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

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

<span class="mw-page-title-main">GNU Affero General Public License</span> Free software license based on the AGPLv1 and GPLv3

The GNU Affero General Public License is a free, copyleft license published by the Free Software Foundation in November 2007, and based on the GNU GPL version 3 and the Affero General Public License (non-GNU).

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> Open-source database management system

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">ApexKB</span>

ApexKB, is a discontinued free and open-source script for collaborative search and knowledge management. It is powered by a shared enterprise bookmarking engine that is a fork of KnowledgebasePublisher, and 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> Application platform for resource planning

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:

<span class="mw-page-title-main">Microsoft Dynamics 365</span> Microsoft software

Microsoft Dynamics 365 is an integrated suite of enterprise resource planning (ERP) and customer relationship management (CRM) applications offered by Microsoft. Combines various functions such as sales, customer service, field service, operations, finance, marketing, and project service automation into a single platform.

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. While numerous open-source ERP projects exist, Metasfresh was included in the Top 9 Open Source ERPs to Consider by opensource.com.

References

  1. http://www.sql-ledger.com/misc/whatsnew.html . Retrieved 4 November 2021.{{cite web}}: Missing or empty |title= (help)
  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.