Posts

Showing posts from October, 2010

OpenSourse - Free Databases for Linux Operating System

Image
Oracle's MySQL Oracle's MySQL is one of the most popular GPL'ed databases for the GNU/Linux and BSD platforms. MySQL database is popular because of fast performance, high reliability, ease of use, and dramatic cost savings. SQLite SQLite Embeddable SQL Database Engine is a C library that implements a self contained, serverless, zero configuration, transactional SQL database engine. This allows application programmers to embed an SQL server directly into their application. SQLite is the most widely deployed SQL database engine in the world. The source code for SQLite is in the public domain. The latest version of SQLite is 3.7.3 and it is recommended for all new development. Mckoi SQL Mckoi SQL Database is an Open Source SQL Database System written in Java. Supports transactions, referential integrity, triggers, indexes, Java specific enhancements. Supports multi-threaded, multi-client operation; embedable. Released under the GPL license. This is probably the mos

Best Tools for Oracle Database Administrators

Image
TOAD for Oracle Tool for Oracle Application Developers, a very popular tool with a large user base. Includes SQL Editor, Schema Browser, Procedure Editor, SQL Modeler. Knowledge Base for Oracle Administration A must have online reference/companion for any Oracle DBA. Saves time searching books for syntax, troubleshooting and research. Great error message guide for developers, plus a comprehensive study guide for Oracle7, 8, & 8i OCP exams with test questions. SmartDBA Cockpit SmartDBA Cockpit (previously known as WebDBA) helps you manage your Oracle databases from the convenience of your Web Browser. It allows you to interactively access and administer your databases remotely, and has almost all the features for the day to day working of DBAs. Keeptool KeepTool's tools are a suite of user-friendly, well-architected, resource-frugal components designed to fit your enterprise's Oracle-centric roles, be they modellers, architects, developers, DBAs or even da

Best Tools for Oracle Developers

Image
TOAD for Oracle TOAD Tool for Oracle Application Developers is a very popular tool. This tool Includes SQL Editor, Schema Browser, Procedure Editor, SQL Modeler. Quest Software product TOAD increases user productivity and improves application code quality. TOAD for Oracle available current version is v10.6. SQL Insight SQL Insight is a tool is used to speed, improve, and simplify application and database development.   SQL Insight editors support various file types, SQL, PL/SQL, Java, HTML, XML, C++, and Perl. Latest version is SQL Insight 3. PL/SQL Developer PL/SQL Developer is an Integrated Development Environment that is specifically targeted at the development of stored program units for Oracle Databases. Over time we have seen more and more business logic and application logic move into the Oracle Server, so that PL/SQL programming has become a significant part of the total development process. PL/SQL Developer focuses on ease of use, code quality and productivity, key

linux scripting rocks with baby

Useful Linux System Log Management Commands

Image
who command who 命令 查询utmp 文件并 报告当前登录的每个用户。 who ordered the report query utmp file and each user currently logged on. Who 的缺省 输出包括用户名、终端类型、登录日期及远程主机。 Who's the default output, including user name, terminal type, login date and the remote host. 使用 该命令,系统管理员可以查看当前系统存在哪些不法用户,从而对其进行审计和处理。 Use this command, the system administrator can view the current system, what are the unscrupulous users to its audit and processing. 例如:运行 who 命令 显示如下所示: For example: Run the who command displays as follows: If specified in the wtmp file name, who commands all previous records check. Command who / var / log / wtmp wtmp file was created since the report has been altered or every login. For example: run the command as follows: users command users print out a single line with the current logged on user, the user name corresponds to each display a login session. If a user has more than one login session, and that his name will show the same number of users. Run the command as follows: last c