LibreOffice Base

LibreOffice Base
Developer(s)The Document Foundation
Stable release
Repository
Operating systemLinux, FreeBSD, Mac OS X and Microsoft Windows
TypeRDBMS
LicenseMPLv2.0 (secondary license GPL, LGPLv3+ or Apache License 2.0)[2]
Websitewww.libreoffice.org/discover/base/

LibreOffice Base is a free and open-source database development and administration tool for relational database management systems that is part of the LibreOffice office suite. LibreOffice Base was built off of a fork of OpenOffice.org and was first released as version 3.4.0.1 on October 4, 2011.[3]

Similarly to the other packages in the LibreOffice suite, Base is supported across multiple platforms including Microsoft Windows, macOS, and Linux. Base is recognized for its cross-platform compatibility relative to Microsoft Access, which is developed exclusively for Windows.[4]

Features

LibreOffice Base is designed to allow users to easily create, access, modify, and view databases and their data. This is done by providing users with a graphical user interface that allows users to work with four main tools: Tables, queries, forms, and reports.[5][6] Base includes software wizards to assist users with various aspects of the program.[7][8] LibreOffice Base requires Java in order to create databases with forms, wizards, and more.[9]

Table Data View in Libreoffice Base

Base is able to work with both embedded and external database files. Embedded databases are stored as a single file using C++ based Firebird and Java-based HSQLDB as its storage engine. When connecting to external databases, Base acts as a graphical user interface front-end to facilitate interactions with various database systems including Access Database Engine (ACE/JET), ODBC/JDBC data sources, MySQL, MariaDB, and PostgreSQL.[6]

Base has been described as an unusual project in the niche of database management system software which tends toward proprietary software designed for enterprise users.[5] Proprietary database management software costs have been described as a reason for the use of Base in small businesses.[10]

Migration From HSQLDB to Firebird

Work was started in 2014 to transition the embedded storage engine from HSQLDB to the Firebird SQL back-end. Firebird has been included in LibreOffice as an experimental option since LibreOffice 4.2.[11][12]

In August 2018, The Document Foundation announced the release of LibreOffice version 6.1. If the experimental mode is used, the embedded Firebird engine support is fully available, and the old HSQLDB engine is deprecated—although still available—and replaced by Firebird as the default option.[13][14]

In February 2019, The Document Foundation released LibreOffice version 6.2. The embedded Firebird engine support was moved from experimental mode to operational and the Firebird Migration Assistant can create a backup copy of content as an XML document for the migration process.[15] In February 2020, embedded Firebird was moved back to experimental mode, taking effect in version 6.4.1.[16]

References

  1. ^ a b https://www.libreoffice.org/download/download/
  2. ^ "Licenses". The Document Foundation. Retrieved 12 August 2018.
  3. ^ "Index of /libreoffice/old". The Document Foundation. Retrieved 13 August 2018.
  4. ^ Klosowski, Thorin (15 August 2013). "Battle of the Office Suites: Microsoft Office and LibreOffice Compared". LifeHacker. Retrieved 13 August 2018.
  5. ^ a b Gaskin, James (5 August 2016). "LibreOffice 5 Review". Laptopmag. Retrieved 13 August 2018.
  6. ^ a b Elena, Opris (17 January 2014). "LibreOffice Base Review". Softpedia. Retrieved 13 August 2018.
  7. ^ "Microsoft Access alternatives: are there any free applications that achieve the same result?". 1&1. 6 November 2017. Retrieved 13 August 2018.
  8. ^ Wallen, Jack (20 February 2015). "Creating Forms for Easy LibreOffice Database Entry on Linux". Linux. Retrieved 13 August 2018.
  9. ^ "on firefox and have loaded java 32 [closed] - Ask LibreOffice". ask.libreoffice.org. 17 November 2017. Retrieved 2021-03-16.
  10. ^ Wallen, Jack (27 January 2012). "DIY: Create easy to use databases with LibreOffice Base". TechRepublic. Retrieved 13 August 2018.
  11. ^ "LibreOffice 4.2 released with new SQL preview feature: Firebird SQL backend". Firebird News. 30 January 2014. Retrieved 2 May 2015.
  12. ^ "HSQLDB to be replaced by Firebird". LibreOfficeForum.org. Archived from the original on 19 March 2015. Retrieved 2 May 2015.
  13. ^ "The Document Foundation announces LibreOffice 6.1, a major release which shows the power of a large and diverse community of contributors". The Document Foundation. LibreOffice. 8 August 2018. Retrieved 13 August 2018.
  14. ^ "LibreOffice 6.1: Release Notes". The Document Foundation's Wiki. Retrieved 26 August 2018.
  15. ^ "ReleaseNotes/6.2". The Document Foundation's Wiki. Retrieved 26 February 2019.
  16. ^ "Set Firebird creation option experimental". The Document Foundation. Retrieved 26 October 2020.

Read other articles:

سيشل في الألعاب الأولمبية

يفتقر محتوى هذه المقالة إلى الاستشهاد بمصادر. فضلاً، ساهم في تطوير هذه المقالة من خلال إضافة مصادر موثوق بها. أي معلومات غير موثقة يمكن التشكيك بها وإزالتها. (ديسمبر 2018) علم سيشل (SEY) شاركت السيشل أول مرة في الألعاب الأولمبية عام 1980، وشاركت في معظم الألعاب الاولمبية الصيفية م...

 

Ascenso MX

Second tier of the football pyramid of professional football league in Mexico This article is about the Mexican Second tier football division. For the Costa Rican Second tier football division, see Segunda División de Costa Rica. Football leagueAscenso MXFounded1994; 30 years ago (1994)Folded2020; 4 years ago (2020)CountryMexicoConfederationCONCACAFNumber of teams12Level on pyramid2Promotion toLiga MXRelegation toLiga PremierSerie ADomestic cup(s)Copa MX S...

 

Первородный грех

Об экономическом термине см. Первородный грех (экономика). ХристианствоБиблия Ветхий Завет Новый Завет Евангелие Десять заповедей Нагорная проповедь Апокрифы Бог, Троица Бог Отец Иисус Христос Святой Дух История христианства Апостолы Хронология христианства Ран�...

Shahid Haghani Expressway

Expressway in Tehran, Iran This article does not cite any sources. Please help improve this article by adding citations to reliable sources. Unsourced material may be challenged and removed.Find sources: Shahid Haghani Expressway – news · newspapers · books · scholar · JSTOR (June 2019) (Learn how and when to remove this template message) Shahid Haghani Expresswayبزرگراه شهید حقّانیRoute informationLength4.2 km (2.6 mi)M...

 

Roberto Rosales

Nama ini menggunakan cara penamaan Spanyol: nama keluarga pertama atau paternalnya adalah Rosales dan nama keluarga kedua atau maternalnya adalah Altuve. Roberto Rosales Rosales bermain untuk Málaga pada 2015Informasi pribadiNama lengkap Roberto José Rosales AltuveTanggal lahir 20 November 1988 (umur 35)Tempat lahir Caracas, VenezuelaTinggi 174 cm (5 ft 9 in)Posisi bermain Bek kananInformasi klubKlub saat ini LeganésNomor 16Karier junior Deportivo Gulima CaracasKar...

 

Penshurst Place

Historic medieval house in Kent, England Private entrance to Penshurst Place Penshurst Place is a historic building near Penshurst, Kent, 32 miles (51 km) south east of London, England. It is the ancestral home of the Sidney family, and was the birthplace of the great Elizabethan poets and courtiers, siblings Mary Sidney and Philip Sidney. The original medieval house is one of the most complete surviving examples of 14th-century domestic architecture in England. Part of the house and its...

Fierozzo

Cet article est une ébauche concernant une localité italienne et le Trentin-Haut-Adige. Vous pouvez partager vos connaissances en l’améliorant (comment ?) selon les recommandations des projets correspondants. Fierozzo Le hameau de San Felice avec le mont Ruioch en arrière-plan. Administration Pays Italie Région Trentin-Haut-Adige  Province Trentin   Code postal 38050 Code ISTAT 022085 Code cadastral D573 Préfixe tel. 0461 Démographie Population 470 hab. (1er janv...

 

Torneo Rio-San Paolo 1998

Torneo Rio-San Paolo 1998Torneio Rio-São Paulo 1998 Competizione Torneo Rio-San Paolo Sport Calcio Edizione 21ª Date dal 21 gennaio 1998al 3 marzo 1998 Luogo  Brasile Partecipanti 8 Risultati Vincitore  Botafogo(4º titolo) Secondo  San Paolo Statistiche Miglior marcatore Dodô (San Paolo), 5 gol Incontri disputati 30 Gol segnati 83 (2,77 per incontro) Cronologia della competizione 1997 1999 Manuale Il Torneo Rio-San Paolo 1998 (ufficialmente in portoghese ...

 

Derby (Regno Unito)

Questa voce o sezione sull'argomento autorità unitarie dell'Inghilterra non cita le fonti necessarie o quelle presenti sono insufficienti. Puoi migliorare questa voce aggiungendo citazioni da fonti attendibili secondo le linee guida sull'uso delle fonti. Derbyautorità unitaria e cittàCity of Derby Derby – Veduta LocalizzazioneStato Regno Unito    Inghilterra RegioneMidlands Orientali Contea Derbyshire AmministrazioneEsecutivoLaburista / Conservatore Ter...

Wild One (Johnny O'Keefe song)

1958 song by Johnny O'Keefe Wild OneSong by Johnny O'Keefefrom the album Shakin' at the Stadium Released5 July 1958Recorded1958GenreRock and rollLength2:30LabelLeedonFestivalSongwriter(s)Johnny GreenanJohnny O'KeefeDave OwensTony Withers[1] Wild One or Real Wild Child is an Australian rock and roll song written by Johnny Greenan, Johnny O'Keefe, and Dave Owens. While most sources state that O'Keefe was directly involved in composing the song, this has been questioned by others.[2&...

 

Warp drive

Fictional superluminal spacecraft propulsion system For other uses, see Warp drive (disambiguation). Artistic rendition of a ship with warp drive activated Spatial anomalies in fiction Black holes in fiction • Portable hole • Teleportation in fiction • Wormholes in fiction • Stargate • Warp drive • Hyperspace • Time travel in fiction  Science fiction portalvte A warp drive or a drive enabling space warp is a fictional superluminal (faster than the speed of light) spacecraft...

 

Peter Schiefke

Canadian environmentalist and politician Peter SchiefkeMPChair of the House of Commons Standing Committee on Transport, Infrastructure and CommunitiesIncumbentAssumed office September 2021MinisterOmar AlghabraPreceded byVance BadaweyParliamentary Secretary to the Minister of Environment and Climate ChangeIncumbentAssumed office December, 2019MinisterJonathan WilkinsonPreceded bySean FraserParliamentary Secretary to the Prime Minister (Youth)IncumbentAssumed office December 2, 201...

هنود

هنودمعلومات عامةنسبة التسمية الهند التعداد الكليالتعداد قرابة 1.21 مليار[1][2]تعداد الهند عام 2011ق. 1.32 مليار[3]تقديرات عام 2017ق. 30.8 مليون[4]مناطق الوجود المميزةبلد الأصل الهند البلد الهند  الهند نيبال 4,000,000[5] الولايات المتحدة 3,982,398[6] الإمار...

 

William Haile (New Hampshire politician)

American politician William Haile26th Governor of New HampshireIn officeJune 4, 1857 – June 2, 1859Preceded byRalph MetcalfSucceeded byIchabod GoodwinMember of the New Hampshire House of RepresentativesIn office1846–185018531856Member of the New Hampshire SenateIn office1854–1856 Personal detailsBornMay 1807 (1807-05)Putney, Vermont, U.S.DiedJuly 22, 1876 (1876-07-23) (aged 69)Keene, New Hampshire, U.S.Political partyRepublicanSpouseSabrina Shaw WalkerProfess...

 

Real Betis in European football

Spanish club in European football This article's lead section may be too short to adequately summarize the key points. Please consider expanding the lead to provide an accessible overview of all important aspects of the article. (September 2017) Real Betis in European footballClubReal BetisSeasons played14First entry1977–78 European Cup Winners' CupLatest entry2024–25 UEFA Conference League This is an article showing the matches of Real Betis in European competitions. Overall record Accur...

سياسة عدم التسامح المطلق

هذه المقالة بحاجة لصندوق معلومات. فضلًا ساعد في تحسين هذه المقالة بإضافة صندوق معلومات مخصص إليها. هذه مقالة غير مراجعة. ينبغي أن يزال هذا القالب بعد أن يراجعها محرر؛ إذا لزم الأمر فيجب أن توسم المقالة بقوالب الصيانة المناسبة. يمكن أيضاً تقديم طلب لمراجعة المقالة في الصفحة ...

 

Mary McDonnell

American actress For the American soccer defender, see Mary Therese McDonnell. Mary McDonnellMcDonnell at the 2019 GalaxyCon RaleighBornMary Eileen McDonnell (1952-04-28) April 28, 1952 (age 72)Wilkes-Barre, Pennsylvania, U.S.EducationState University of New York at FredoniaOccupationActressYears active1977–presentSpouse Randle Mell ​ ​(m. 1984; sep. 2021)​Children2 Mary Eileen McDonnell (born April 28, 1952) is an American film, sta...

 

Ракетна зброя

Запуск ракети Lockheed Trident з підводного човна Раке́тна зброя — сукупність різних ракетних комплексів, призначених для ураження наземних, повітряних, морських і позаатмосферних цілей бойовою частиною ракети. Ракетний комплекс складається з ракети, що має ядерну або звич...

Alfred Daney

Pour les articles homonymes, voir Daney. Cet article est une ébauche concernant un homme politique français. Vous pouvez partager vos connaissances en l’améliorant (comment ?) selon les recommandations des projets correspondants. Alfred Daney Fonctions Maire de Bordeaux 1904 – 1908(4 ans) Prédécesseur Paul-Louis Lande Successeur Jean Bouche 1892 – 1896(4 ans) Prédécesseur Adrien Bayssellance Successeur Camille Cousteau 1884 – 1888(4 ans) Prédécesseur Albe...

 

United States House Committee on Appropriations

Standing committee of the United States House of Representatives House Appropriations CommitteeStanding committeeActiveUnited States House of Representatives118th CongressCommittee logoHistoryFormedDecember 11, 1865LeadershipChairTom Cole (R) Since April 10, 2024Ranking memberRosa DeLauro (D) Since January 3, 2023Vice chairVacant (R) Since April 10, 2024StructureSeats61Political partiesMajority (34)   Republican (34) Minority (27)   Democratic (27) JurisdictionPolicy areasAppropriat...