Top

CRUD is an acronym for Create, Read, Update and Delete. It is a set of operations we get servers to execute (POST, GET, PUT and DELETE respectively). This is what each operation does:

• Create (POST) - make something
• Read (GET)_- get something
• Update (PUT) - change something
• Delete (DELETE)- remove something

Top

IMI :
Des = [root@dmqb261]: /wbmde1/product/9.2.0/network/admin>
Pre = [root@rcmqb272]: /wbmpp1/product/9.2.0/network/admin>
Prod = [root@cmqb132]: /wbmpr1/product/9.2.0/network/admin>

Top

• veure el nom "logic" de la Base de Dades : obrir (oracle/ora92/network/admin/) tnsnames.ora => BLBRKD00

• veure que hi ha accés a la Base de Dades :
  TNSPING BLBRKD00 (usuari ora9)

  També val

  LSNRCTL status

• veure que hi ha Listener (TNSLSNR.exe at TCPview) :
  NETSTAT -AN | grep 1521
  i veure quins Serveis manega :
  LSNRCTL SERVICES BLBRKD00

• engegar SQL Plus : U+K+Paràmetre :
  Host String := BLBRKD00 as sysdba

  If you are connecting to a remote Oracle database, enter the Oracle Net connect_identifier in the Host String field.

  Otherwise, ORA-12560 : TNS: Protocol Adapter error.

• veure versió de Oracle : TNSPING o
  SQL> select * from v$version;

• veure característiques de la BD :
  SQL> select * from v$instance;

• mostrar camps que té la taula de usuaris :
  SQL> desc dba_users;

• mostrar usuaris :
  SQL> select username from dba_users;

• mostrar camps que té la taula de taules :
  SQL> desc dba_tables;

• mostrar tablespace's existentes en el sistema :
  SQL> select tablespace_name from dba_tablespaces;

• veure els TABLESPACES (amb caracteristiques) :
  SQL> select * from v$tablespace;

• mostrar tablespace's de todos los usuarios :
  SQL> select username,default_tablespace from dba_users;

• mostrar tablespace's de un usuario determinado :
  SQL> select username,default_tablespace from dba_users where username='SAG22';

• mostrar tablespace's :
  SQL> select * from dba_users where username='ESBRKP00';

• mostrar table's de un usuari :
  SQL> select count(*) from dba_tables where owner='ESBRKP00';

• veure la versió del S.O. des SQL :
  SQL> SELECT dbms_utility.port_string FROM dual;

• esborrar un usuari :
  SQL> DROP <user_name>

• engegar Oracle :
  [root@cmqb131]:/usr/local/bin> cat start_oracle.sh su - oracle -c lsnrctl start echo "connect / as sysdba;" > /tmp/startdb.sql echo "startup;" >> /tmp/startdb.sql echo "exit;" >> /tmp/startdb.sql su - oracle -c "export ORACLE_SID=wbmpr1; sqlplus -s /nolog @/tmp/startdb.sql" [root@cmqb131]:/usr/local/bin>

• veure el SID del Oracle :
  tx0609-2:/home/wbrkadm # ps -ef | grep pmon ora9 307428 1 0 Jan 10 - 0:48 ora_pmon_mqpre ora9 426118 1 0 Jan 10 - 0:48 ora_pmon_mqcert

  El SID va després de "ora_pmon_" ...

• aturar Oracle :
  [root@cmqb131]:/usr/local/bin> cat stop_oracle.sh su - oracle -c lsnrctl stop echo "connect / as sysdba;" > /tmp/startdb.sql echo .alter system switch logfile; > /tmp/startdb.sql echo "shutdown immediate;" >> /tmp/startdb.sql echo "exit;" >> /tmp/startdb.sql su - oracle -c "export ORACLE_SID=wbmpr1; sqlplus -s /nolog @/tmp/startdb.sql" [root@cmqb131]:/usr/local/bin>

  després, fer :

  [wbrkadm@cmqb131]:/usr/local/bin> ps -ef | grep ora oracle 217166 1 0 11:25:21 - 0:00 ora_reco_wbmpr1 oracle 332004 1 0 11:25:21 - 0:00 ora_smon_wbmpr1 oracle 491592 1 0 11:25:21 - 0:00 ora_ckpt_wbmpr1 oracle 516286 1 0 11:25:21 - 0:00 ora_lgwr_wbmpr1 oracle 585978 1 0 11:25:21 - 0:00 ora_qmn0_wbmpr1 oracle 598064 1 0 11:25:21 - 0:00 ora_cjq0_wbmpr1 oracle 602124 1 0 11:25:21 - 0:00 ora_s000_wbmpr1 oracle 610466 1 0 11:24:26 - 0:00 /wbmpr1/product/9.2.0/bin/dbsnmp oracle 622664 1 0 11:25:21 - 0:00 ora_dbw0_wbmpr1 oracle 770186 1 0 11:25:20 - 0:00 ora_pmon_wbmpr1 root 790718 774338 0 11:58:21 pts/4 0:00 grep ora oracle 794872 1 0 11:25:32 - 0:00 oraclewbmpr1 (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq))) oracle 975094 978990 0 11:47:19 pts/3 0:00 -ksh oracle 995526 1 0 11:25:21 - 0:00 ora_d000_wbmpr1 [wbrkadm@cmqb131]:/usr/local/bin> kill -9 332004

An A-Z Index of Oracle SQL Commands (version 9.2)

Top

Can Export a Table in the following formats :

• XML
• CSV
• SQL Insert
• SQL Loader
• Text

DB2 can Import the following formats :

• SQL Scripts (*.clp, *.sql, *.db2)
• Data files (*.dat)
• Text files (*.txt)
• Doc files (*.doc)
• Batch files (*.bat)
• INI files (*.ini)
• "C" files (*.c, *.cpp)
• Header files (*.h, *.hpp)
• Java files (*.java, *.jav)
• HTML files (*.htm, *.html)
• XML files (*.xml)

Top

Netejar la cache del Oracle.

Top

Llibres de Oracle que he trobat en xarxa :

Oracle9i Database Online Documentation.

Oracle9i Application Developer's Guide - Fundamentals

Top

url

You can execute SQL statements in a script file (batch file) like this:

DWB sample, tutorial

PHP MySQL intro

Connection(), Create_db(), Drop(), Select(), Create_Tbl()

Start :

Lets do it :

Solució:

Per fer-ho permanent:

I hem de configurar :

Don't forget to

Dins de mysql:

Top

Solucio : install and start mysqld, mysql daemon : /etc/rc.d/init.d/mysqld start

Mirem requisits :

Els instalem :

I el engeguem :

Ja podem entrar:

On Unix, the mysql client writes a record of executed statements to a history file. By default, the history file is named .mysql_history and is created in your home directory. To specify a different file, set the value of the MYSQL_HISTFILE environment variable.

"man mysql" :

Top

GUI tools tutorial (Administrator, Query Browser), list, Squirrel,

Tutorial basic, comands for beginners, nice cmd list,

Top

MongoDB is an open-source, document-oriented database designed for ease of development and scaling. MongoDB utilizes a simple JavaScript interface for querying. Looking up a document is as simple as passing a JavaScript object that partially describes the search target.
MongoDB is a document-oriented database, not a relational one. The primary reason for moving away from the relational model is to make scaling out easier.

Some of the basic concepts of MongoDB:

• a document is the basic unit of data for MongoDB, roughly equivalent to a row in a relational database management system (but much more expressive).
• similarly, a collection can be thought of as the schema-free equivalent of a table.
• a single instance of MongoDB can host multiple independent databases, each of which can have its own collections and permissions.
• MongoDB comes with a simple but powerful JavaScript shell, which is useful for the administration of MongoDB instances and data manipulation.
• every document has a special key, "_id", that is unique across the document's collection.

At the heart of MongoDB is the concept of a document: an ordered set of keys with associated values.
In JavaScript, for example, documents are represented as objects: {"greeting" : "Hello, world!"}. This simple document contains a single key, "greeting", with a value of "Hello, world!".

Mongo scripting, scripts.

Install manual, done on RH 64b
Configuration file is /etc/mongod.conf, in conjunction with the control script at /etc/rc.d/init.d/mongod
Data files are stored in /var/lib/mongo and log files in /var/log/mongo
It runs using the mongod user account

Lets run the mongo shell:

Lets start the daemon:

Ens cal un directori (amb 3 GB) o "--smallfiles"

Engeguem amb fitxer de configuració:

I la configuració:

L'engegada es aixi:

The only way is using "kill -15" :

Tutorial

Get this fix 405791

Get code keeping in mind

Move all unziped files to c:\mongodb and create mongodb\data\ and mongodb\data\db\ and mongodb\log\.

Create configuration file:

Start mongodb by

Verify it works using the client:

Install it as a windows service if you please:

To run the MongoDB service:

To stop it

To uninstall it:

By default, MongoDB listens for socket connections on port 27017.

To start the server, run the mongod executable, with some parameters:

mongod also sets up a very basic HTTP server that listens on a port 1,000 higher than the main port, in this case 28017.
This means that you can get some administrative information about your database by opening a web browser and going to http://localhost:28017

To make full use of the admin interface (e.g., to access the command list), you'll need to turn on REST support with --rest when starting Mongo

Server status : http://localhost:28017/_status

Collection contents: http://127.0.0.1:28017/cdt/wCDT_users/?filter_uAlias=guest

MongoDB comes with a JavaScript shell that allows interaction with a MongoDB instance from the command line.
The shell is very useful for performing administrative functions, inspecting a running instance, or just playing around.

To start the shell, run the mongo executable

The shell is a full-featured JavaScript interpreter, capable of running arbitrary JavaScript programs.

Sample:

A good way of figuring out what a function is doing is to type it without the parentheses. This will print the JavaScript source code for the function.

There is also an autogenerated API of all the JavaScript functions provided by the shell at http://api.mongodb.org/js, mongo JavaScript API documentation {****}

1. start mongo
   c:\Sebas\JavaScript\test> type $_start_mongo_for_TEST.cmd set BBDD=nom_db set COLE=users start "MongoDB for TEST demo" c:\mongodb\bin\mongod.exe --rest --config c:\Sebas\JavaScript\test\mongod.cfg
2. cfg file
   c:\Sebas\JavaScript\test> type mongod.cfg smallfiles=true logpath=c:\mongodb\log\mongo.log dbpath=c:\sebas\JavaScript\test\data
3. run shell
   c:\Sebas\JavaScript\test> type $_crear_bbdd.cmd set BBDD=nom_db set COLE=users mongo localhost:27017/nom_db --quiet my_commands.js
4. data from file
   c:\Sebas\JavaScript\test> type my_commands.js db.users.insert({name:"john", email:"john@doe.com", age:12}); db.users.insert({name:"pere", email:"peter@doe.com", age:14});
5. show result
   c:\Sebas\JavaScript\test> mongoexport -d nom_db -c users connected to: 127.0.0.1 { "_id" : { "$oid" : "547cd0c1609aa7f755d78987" }, "name" : "john", "email" : "john@doe.com", "age" : 12 } { "_id" : { "$oid" : "547cd0c2609aa7f755d78988" }, "name" : "pere", "email" : "peter@doe.com", "age" : 14 }

Maybe you want to use some ipsum tool - Python utils to create random JSON data and import into mongoDB

First code:

Another code:

Tool

If BBDD = "testdb" and COLE = "user" then

Documents in MongoDB can be thought of as "JSON-like" in that they are conceptually similar to objects in JavaScript. JSON is a simple representation of data: the specification can be described in about one paragraph http://www.json.org proves it and lists only six data types. This is a good thing in many ways: it's easy to understand, parse, and remember. On the other hand, JSON's expressive capabilities are limited, because the only types are null, boolean, numeric, string, array, and object.

At the time of this writing, MongoDB supports more than 75 different commands, and more commands are being added all the time. There are two ways to get an up-to-date list of all of the commands supported by a MongoDB server:

• run db.listCommands() from the shell, or run the equivalent listCommands command from any other driver.
• browse to the http://localhost:28017/_commands URL on the MongoDB admin interface (for more on the admin interface see Chapter 8).

Which one shall we use ?

• mongodb
  univesity !
• monk
  Smaller in scope (than mongoose) and thus easier to understand. Monk is a tiny layer that provides simple yet substantial usability improvements for MongoDB usage within Node.JS
• mongojs
  Emulates the official mongodb API as much as possible
• mongoose

Connect():

To use mongo from JS we need to start mongo with "--rest" http://stackoverflow.com/questions/16276557/using-mongodb-from-client-with-javascript

Java + MongoDB hello world example

Original documentation

Tutorials [****], hello

See our mongodb contents : http://127.0.0.1:28017/cdt/wCDT_users/?filter_uAlias=guest

You can query this URL with an AJAX XmlHttpRequest like any webservice. It will access a database on localhost and return JSON equivalent to a query like this:

url

• exploring Your Database:
  • mongo VUE
  • mongo Hub (mac)
  • use Robomongo to see what's in the database. Just download it and connect to your database to see your new users after they signup!
• mongo status every sec
  > mongostat
• $ ./mongodump --help
• $ ./mongorestore --help
• $ ./mongoperf.exe - disk performance

url

Using the Java driver is very simple. First, be sure to include the driver jar mongo.jar in your classpath.

Go Java Language Center and select Download the Java Driver

In MB Toolkit, right-click on the project name and select "Build Path" to include it into Java Build Path

• Mongo-db university - M101JS: "MongoDB for Node.js Developers" start Oct 21
• the dead-simple step-by-step guide for front-end developers to getting up and running with node.js, express, jade, and nongodb : full sample {***};
  creating a simple Restful web app with node.js, express, and mongodb : even better {\\T430\JavaScript\resttest}
• another sample, part 2 - code
• The Definitive Guide {pdf}, Kristina Chodorow {sagpdf}
• 2x videos : MongoDB tutorial - what is MongoDB? Building Web Applications with MongoDB: An Introduction
• Simple Service Bus - Message Queue with MongoDB
• Encode video with MongoDB work queues {developerWorks} - Techniques to easily store and process complex jobs
• repair after shutdown

Top

Command line shell, node module

Engeguem el codi :

I les dades son :

how to :

1. download ZIP file to C:\eines\soft\sqlite - sqlite-tools-win32-x86-3210000.zip
2. extract the content - you shall have sqlite3.exe - C:\eines\soft\sqlite\sqlite-tools-win32-x86-3210000\sqlite3.exe
3. get GUI tool for managing SQLite databases : SQLite Studio - sqlitestudio-3.1.1.zip
4. extract into C:\eines\soft\sqlite\sqlitestudio-3.1.1\SQLiteStudio\SQLiteStudio.exe

Top

What is the best DDBB for nodejs

• SQLite
  This is just a database in a file. It is very limited at functions, but is great for very small things with small capacity (i.e. Raspberry Pi). It can really only handle one connection at a time. There is no server. The permissions on the file are its security.

• JSON file
  How much do you really need to store? How fast do you need it? How many applications will use it? If it isn't too too much data, this is a better option than SQLite.
  I'm sure there are some NPM libraries that handle it for you. I usualy just use fs-extra, async, and my own functions. It is extremely easy.

  Some packages :

  • node-json-db - a simple "database" that use JSON file for Node.JS
  • json-file-db - simple file wrapper to GET, PUT and DELETE javascript objects to files to use with Node.JS [****]

Top

• Per xafardejar els continguts de les bases de dades, ens cal una eina
  • com el Toad - tinc v 7.6 i v 8.6 (\\Fonts\).
  • SQLdeveloper (Oracle only) - \\Fonts\
  • Squirrel - ( open-source Java SQL Client program for any JDBC compliant database ). Yes - DB2 and Oracle.
  • dbjmin - open source MULTI-DB client
• Oracle ODBC test

Top

• Introduction to no SQL by Martin Fowler

• Taffy - the Javascript database