Bureaucrats, editor, reviewer, Administrators
13,550
edits
Changes
Jump to navigation
Jump to search
m
Database First of all, launch a 'input' created in 53.64 ms.<html> <!-- Header --> 'standalone''' version of BaseX: double click on the '''BaseX''' icon (Windows only) or run the <head id="0"code> <title>XMLbasex</titlecode> </head> <!-- Body --> <body id="1" bgcolor="script. Click on the following links to find more information on [[Startup#FFFFFF" text="Standalone_Mode|starting the standalone mode]], [[Start_Scripts#000000" link="Standalone|the standalone mode's start script]] or [[Command-Line_Options#0000CC"> <h1>Databases & XML</h1> <div align="right"> <b>Assignments</b> <ul> <li>Exercise 1</li> <li>Exercise 2</li> </ul> </div> </body> <?pi bogus?></html>Standalone|the standalone mode's command-line options]].
Query: /=Create a Database=
Compiling* To create a database you need an XML document, e.g. [http://files.basex.org/xml/factbook.xml factbook.xml].* Save this document to your working directory.* Type in the following command to create and open the database:<code>> [[Commands#CREATE DB|CREATE DB]] factbook factbook.xml</code>
Result: root()'''factbook''' is the name of the database <br/>: '''factbook.xml''' is the initial input of the database<br/>
Parsing: 0.19 msCompiling: 9.27 msEvaluating: 0.33 msPrinting: 3.08 msTotal Time: 12.88 msResults: 1 ItemUpdated: 0 ItemsPrinted: 375 BytesMemory: 5834 KB; Where is the database stored?
Query executed By default, databases are stored in 13the <code>basex/data</code> directory, which is located in your home folder.25 msDepending on your [[Configuration]], the location of your home folder varies.For example, on a Mac it's <code>/Users/John</precode>, if your name is John.
All available command-line options can be found [[Startup_Advanced#BaseX_Standalone|here]].=Execute a Query=
moved Standalone Mode to Command-Line Client
This page is part of the [[Getting Started]] Section.BaseX offers a standalone console mode from in which all [[Commands|database commands]] can be executedfrom the command line or console.The article on the [[Database Server Tutorial]] contains a good introduction on how to run provides numerous examples for running commands in the console standalone mode. ==Startup==First of all, please launch a '''(Note that the standalonemode does ''' version of BaseX: double click on the '''BaseX'not'' icon, or run interact with the <code>basex<client/code> scriptserver architecture. [[Startup#BaseX Standalone|Follow this link]] for more information (or check out the additional [[Startup Advanced#BaseX Standalone|command-line options]]).
=Startup=Working with the BaseX Console== <p>After the BaseX Console has been started, the <code>HELP</code> command can be used toto list all [[Commands|database commands]]. Several commands can be separated by semicolons.</p> <p> To evaluate commands without entering the console mode, you can use the<code>-c</code> option on the command line:</p> <pre>basex -Vc "CREATE DB input input.xml; XQUERY /"
The [[Commands#XQUERY|XQUERY]] command lets you run a query.* For example, the following query returns all country nodes in the currently opened factbook database.<code>> [[Commands#XQUERY|XQUERY]] //country</code> * You can also run queries in files:<code>> [[Commands#RUN|RUN]] /Users/John/query.xq</code> =Database Commands=See * The following command lists all databases than can be opened by the currently logged in user:<code>> [[Commands#LIST|LIST]]</code> * To open an existing database, execute the following:<code>> [[Commands#OPEN|OPEN]] factbook</code> * To get information on the currently opened database, type:<code>> [[Commands#INFO|INFO]]</code> * You can also address a database within your query with the [[Database Module#db:open|db:open]] function:<code>> [[Commands#XQUERY|XQUERY]] db:open("factbook")//country</code> * To [[Commands|close]] the current database, please type: <code>> [[Commands#CLOSE|CLOSE]]</code> * Use the [[Commands#DROP DB|DROP DB]] command to delete a database:<code>> [[Commands#DROP DB|DROP DB]] factbook</code> =Multiple Resources= One database can contain not only a single, but millions of documents. All documents can have a different structure. With the following commands, you can create an empty database and add two documents. It is also possible to address resources via URLs: <code>> [[Commands#CREATE DB|CREATE DB]] store</code><br/><code>> [[GUI TutorialCommands#ADD|ADD]]factbook.xml</code><br/><code>> [[Commands#ADD|ADD]] http://files.basex.org/xml/xmark.xml</code> * Deleting a document from a database is easy, but make sure that the database, which contains the addressed document, is currently opened:<code>> [[Server TutorialCommands#DELETE|DELETE]]factbook.xml</code> =Backup and Restore= * To backup your database, type:<code>> [[Getting StartedCommands#CREATE BACKUP|CREATE BACKUP]]factbook</code> * To restore your database, type:<code>> [[CategoryCommands#RESTORE|RESTORE]] factbook</code> The backup file is stored in the database directory.It contains the name of the database and a timestamp:Beginner<code>[db-name]-[timestamp].zip</code>.If a database is to be restored, and if several backups exist, the backup with the newest timestamp is taken.
