Libreoffice Sqlite

It's official. Or at least seems so in the LibreOffice development path:
default to SQLite not HSQLDB in Base

LibreOffice is a free and open source office suite used by millions of people around the world. Seems like you could have gradual move where sqlite becomes an.


I was going to refrain from comment but perhaps I'll begin with a few Pros & Cons:
  • It was made with SQLite 3.32.3 and a MinGW cross compiler, and contains the driver DLLs and programs for installation and uninstallation of the ODBC driver. Note that this is a 64 bit only driver. If you're using 32 bit software on Win64 you should install the Win32 driver, too.
  • Open a Base file of the database type that you want. Either create a new Base file using the Database Wizard, or open any existing Base file that is not read-only. Open the Calc file that contains the data to be imported to Base.

Pros
    + Will result in a native SQLite 3.x driver for Base on all platforms
    + Eliminates Java dependencies from the back-end database engine
    + Might stabilize the 'Embedded database' product due to code rework or proper unzip to disk during use
    + Might result in auto-configurations (pre-sets & checkbox options) for various engines (including HSQLDB 1.8.0 & 2.x for migration purposes)
    + If implemented as a separate, external, database file: offers direct database access from other applications
    + If implemented as a separate, external, database file: only 1 file in addition to the Base (.odb) front-end file

Cons
    - Significant step backwards from HSQLDB 2.x and even HSQLDB 1.8.0 in terms of SQL support and features
    - No easy or realistic migration path from default single-user to client-server like we enjoy with HSQLDB
    - May lack seamless support for legacy 'Embedded databases'
    - If implemented as a separate, external, database file (as it should be for stability and external .db access): now 2 files to distribute (.odb + .db)
    - Missed opportunity to integrate H2 'mixed mode' for maximum flexibility including multi-user environments; also 2 files to distribute just like SQLite; also an Android candidate like SQLite (LibO is apparently targeting Android as a future goal)

LibreOffice Help pages are displayed in your system default web browser.

The Help references the default settings of the program on a system that is set to defaults. Descriptions of colors, mouse actions, or other configurable items can be different for your program and system.

The Help system for all versions of the software is based on the same source files. Some of the functions described in Help may not be included in this particular distribution. Some features specific to a distribution may not be mentioned in this Help.


Imli serial. Help pages of LibreOffice Extensions still use the old Help system. The old Help system help pages are available from here.


The LibreOffice Help pages features

The Module List

Located on the top of the page, click to open the drop-down list and select the LibreOffice module to display the module Help main entry page.

The Language List (Help online only).

Available only in the online version, select the language to display the current help page.

The Help Index displays a list of keywords for all LibreOffice modules. Click on any keyword in the list to open the linked Help page.

Searching the Help Index

Type the keyword in the Search text box. The search is performed immediately, while you type the keyword.

Odbc Treiber Sqlite

The search results is displayed as a filtered list of matches. The module name is displayed as a heading on the list. The GLOBAL heading indicates a match for keywords relevant to more than one LibreOffice module. For example, cell borders applies to spreadsheets cells as well as text and presentation table cells or frames.

Use the arrow icons on the bottom of the Index to scroll forward or backward the Index entries or filtered result list.

Displays an index of the main topics of all modules.

  • Click a closed folder () to open it and display the subfolders and Help pages.

  • Click an open folder () to close it and hide the subfolders and Help pages.

  • Click a link to display the corresponding Help page.

Using the browser for LibreOffice Help

Navigating in Help pages

Libreoffice Sqlite Linux

Use the Back and Forward buttons of the browser to navigate between pages. In most browsers, a long click on the Back button displays a dropdown list of previously visited pages and a long click on the Forward button display a list of visited pages after the current one.

Use the bookmark feature of the browser for quick access to relevant Help pages. To bookmark a page in most browsers:

  1. Open the Bookmark menu of the browser,

  2. select Add bookmark, or

    Press +D on most browsers.

  3. Enter the name, folder and meaningful tags for the bookmark.

  4. Close the bookmark dialog of the web browser.

Help Pages Navigation History

Each Help page visited is recorded in the web browser history. To open the navigation history:

  1. Choose the History menu of the web browser,

  2. Select Show History.

  3. Click on any entry of the history main window to open the corresponding help page.

Copying Help contents to clipboard

You can copy contents from the Help page to the clipboard on your operating system with standard copy commands. For example:

  1. On a Help page, select the text that you want to copy.

  2. Press +C.

Some contents in help pages can be copied to the system clipboard with only one mouse click. In these cases a tooltip appears when hovering the mouse on the copy-enabled contents. For example, the following line is copy-enabled:

=SUM(A1:A10)

Searching in current page

To search in the current Help page:

  1. Open the View menu of your default web browser and choose Find on this Page entry.

    You can also press +F.

  2. In the Search for box, enter the text that you want to find.

  3. Select the search options that you want to use.

  4. Press Enter.

To find the next occurrence of the search term on the page, click on the Up arrow or Down arrow to find the previous or next occurrence.

Contents general information

Libreoffice Sqlite

Icons in the Documentation

There are three icons used to call your attention to additional helpful information.

The Important! icon points out important information regarding data and system security.


The Note icon points out extra information: for example, alternative ways to reach a certain goal.


Libreoffice Sqlite

The Tip icon points out tips for working with the program in a more efficient manner.


Libreoffice Base Sqlite

Related Topics