14 posts tagged “dba”

Easy Eclipse for LAMP which is fully multi-platform compatible including GNU/Linux & Apple Mac OS X now has add-ons, extensions, plug-ins for :

• DataBase
  
• Bugzilla, Trac, and JIRA
• SubVersion
• Trac & Subversion integration
  
• Log Watching
• HTML
• JavaScript
• XML & XSLT
• QA & Testing
  

and you can find even more Easy Eclipse plug-ins @

• http://www.easyeclipse.org/site/plugins/index.html
  

to make it one of the best free libre open source IDEs for LAMP web developers !

easy eclipse ide

jTDS is an open source 100% pure Java (type 4) JDBC 3.0 driver for MS SQL Server (6.5, 7, 2000 and 2005) and Sybase (10, 11, 12, 15). jTDS is based on FreeTDS and is currently the fastest production-ready JDBC driver for MS SQL Server and Sybase.

jTDS is 100% JDBC 3.0 compatible, supporting forward-only and scrollable/updateable ResultSets, concurrent (completely independent) Statements and implementing all the DatabaseMetaData and ResultSetMetaData methods.

jTDS is used in a number of commercial applications. It has been tested with and is actually recommended as the driver to use for MS SQL Server by pretty much all open source AND commercial database management tools:

• iSQL-Viewer (http://isql.sourceforge.net)
• SQL Workbench/J (http://www.sql-workbench.net)
• SQuirreL SQL Client (http://squirrel-sql.sourceforge.net)
• Db-Visualizer (http://www.minq.se/products/dbvis/index.html)
• SQL Developer (http://sqldeveloper.solyp.com)
• Artiso Visual Case (http://www.visualcase.com)

There are quite a few database management tools that come bundled together with jTDS:

• DataDino (http://www.datadino.com/)
• DBInspect (http://www.dbinspect.com/)
• Aqua Data Studio (http://www.aquafold.com/)
• DB Viewer (http://victorpendleton.net/products/dbviewer.html)

Oracle Application Express
http://apex.oracle.com/i/index.html

Workshop
http://www.oracle.com/technology/products/database/application_express/migrations/mig_index.html

Unofficial Wiki
http://wiki.shellprompt.net/bin/view/Apex/WebHome

If you are looking for an alternative database system have a look at

http://www.oracle.com/pls/xe102/homepage

Oracle Database 10g Express Edition (Oracle Database XE) is a free-of-charge version of the world's most capable relational database. Oracle Database XE is easy to install, easy to manage, and easy to develop with.

With Oracle Database XE, you use an intuitive, browser-based interface, to:

• Administer the database
• Create tables, views, and other database objects
• Import, export, and view table data
• Run queries and SQL scripts
• Generate reports

http://www.oracle.com/pls/xe102/homepage

ORACLE & ...

PHP
http://www.oracle.com/technology/getting-started/php.html

Ruby
http://www.oracle.com/technology/pub/articles/haefel-oracle-ruby.html

Eclipse
http://oss.oracle.com/oracle-eclipse-projects.html

SQL Developer
http://www.oracle.com/technology/software/products/sql/index.html

1)  
watch out for the additional Unicode single quote characters \u2018 ( ‘ ) & \u2019 ( ’ )

2)
use '\\' when inserting '\' and
use '\\\\' for looking for '\' in LIKE statements !

3a)
watch out for LIKE <> REGEXP !

3b)
where
 first_name LIKE '%\\\\%' or  
 last_name LIKE '%\\\\%' or
 email LIKE '%\\\\%'

3c)
where
 first_name REGEXP '.*\\\\.*' or  
 last_name REGEXP '.*\\\\.*' or
 email REGEXP '.*\\\\.*'

4)
documentation

http://dev.mysql.com/doc/refman/5.0/en/string-comparison-functions.html#operator_like

extract
 
because MySQL uses C escape syntax in strings (for example, \u2018\n\u2019 to represent a newline character), you must double any \u2018\\u2019 that you use in LIKE strings. For example, to search for \u2018\n\u2019, specify it as \u2018\\n\u2019. To search for \u2018\\u2019, specify it as \u2018\\\\\u2019; this is because the backslashes are stripped once by the parser and again when the pattern match is made, leaving a single backslash to be matched against.

ANY FINALLY FINALLY !

(Exception: At the end of the pattern string, backslash can be specified as \u2018\\\u2019. At the end of the string, backslash stands for itself because there is nothing following to escape.)

First enable slow query logging, then generate a slow query and finally look at the slow query log !

Enable
http://dev.mysql.com/doc/refman/5.0/en/slow-query-log.html

Generate

select sleep(2)


then run mysqldumpslow

$ mysqldumpslow --help
Usage: mysqldumpslow [ OPTS... ] [ LOGS... ]

Parse and summarize the MySQL slow query log. Options are

  --verbose    verbose
  --debug      debug
  --help       write this text to standard output

  -v           verbose
  -d           debug
  -s ORDER     what to sort by (t, at, l, al, r, ar etc), 'at' is default
  -r           reverse the sort order (largest last instead of first)
  -t NUM       just show the top n queries
  -a           don't abstract all numbers to N and strings to 'S'
  -n NUM       abstract numbers with at least n digits within names
  -g PATTERN   grep: only consider stmts that include this string
  -h HOSTNAME  hostname of db server for *-slow.log filename (can be wildcard),
               default is '*', i.e. match all
  -i NAME      name of server instance (if using mysql.server startup script)
  -l           don't subtract lock time from total time

mysqldumpslow output

# Time: 070906 12:47:20
# User@Host: root[root] @ localhost []
# Query_time: 3  Lock_time: 0  Rows_sent: 1  Rows_examined: 0
select sleep(3);


Firebird
MySQL
PostgreSQL

http://refcards.com/subject/databases

http://www.planetmysql.org/kaj/?p=85

The Quality Contribution Program goal is to improve the quality of MySQL products, with the active co-operation of the MySQL user community.

The program facilitates this by
   1. visibly acknowledging the participants by attributing individual quality enhancements to them;
   2. rewarding the participants with benefits in proportion to their contribution (Awards are subscriptions to MySQL Enterprise);
   3. streamlining the process of contributing to MySQL Quality for the benefit of both current and future contributors

Quality Contributions fall into three categories: (i) bug reports, (ii) test cases, and (iii) code patches. We evaluate each contribution with a publicly verifiable set of rules, and the contributor accumulates the QA points for all contributions submitted during the last 12 months.

Start today @ http://dev.mysql.com/qualitycontribution.html

Here are a few Open Source Database Clients i haven't had time to look at yet

• http://www.heidisql.com/
• https://dbclient.dev.java.net/
  
• http://tora.sourceforge.net/