2004-09-02
You'd like a nice way to order the output of (Oracle) SQL in an arbitrary way? For instance, if you query . . .
1K - last updated 2005-03-19 11:13 UTC by 1461
2007-02-02 Branching in SVN with existing work
This week I had the situation where I was asked to come to another office (in Groningen) and do some . . . $ patch -p 0 < ~/gron.patch patching file tdb/mysql-telis.sql patching file client/python/plotffo.py . . . ... lines removed ... Sending tdb/mysql-telis.sql Transmitting file data ..... Committed . . .
2K - last updated 2007-02-02 13:59 UTC by bvankuik
2008-04-16 Qt database widgets
I've been playing with a couple of Qt classes to get an easy-to-use SQL user interface. The combo QTableView . . . and QSqlTableModel seemed very nice. Using the Designer, . . . types in the table widget on the screen || ||QSqlTableModel ||This class provides an easy-to-use . . . ||A class that can be stuck over QSqlTableModel to transform, sort or filter data when . . . it comes in or goes out of the QSqlTableModel || You have to think about what functions . . .
2K - last updated 2008-04-21 12:43 UTC by 1461
2008-05-25 Finding open ports
When tightening up security on a Linux server, one of the first things the system administrator does, . . . telislt.sron.:commplex-main 6573/ssh tcp 0 0 *:mysql 2307/mysqld tcp 0 0 *:sunrpc 1945/rpcbind tcp 0 . . .
3K - last updated 2008-05-25 20:25 UTC by 1461
2012-01-23 Logrotate error for MySQL on Debian 6 Squeeze
When installing a new machine with Debian 6 (Squeeze), I also imported a database from a CentOS 5 box. . . . running shared postrotate script for '/var/log/mysql.log /var/log/mysql/mysql.log /var/log/mysql/mysql-slow.log . . . create the user with the following commands: $ mysql -u root -p mysql> GRANT SHUTDOWN ON *.* TO 'debian-sys-maint'@'localhost'; . . . mysql> GRANT RELOAD ON *.* TO 'debian-sys-maint'@'localhost'; . . . mysql> GRANT SELECT ON 'mysql'.'user' TO 'debian-sys-maint'@'localhost'; . . .
2K - last updated 2012-01-23 07:38 UTC by 1461
2012-11-09 Full-text searching
In a previous project, I solved the full text search problem as follows. Management overview: it's very . . . very hard to assign a weight to the results. MySQL supports full-text search but only in a degraded . . . name, address, reviews, locations etc). The MySQL full-text search facility then becomes available, . . . Then, this table can be searched by the MySQL facility "full text search", and give you back . . .
2K - last updated 2012-11-09 06:03 UTC by 1461
2015-08-27 Open underlying SQLite database when using Core Data
During development of an app using Core Data, you often want to have a quick peep in the underlying SQLite . . . your AppDelegate: // Log path (to manually open SQLite database) when in simulator. In the File -> . . . Open dialog of // SQLPro for SQLite, type Shift-CMD-G and paste this . . . folder: \(path)") } You can use the commandline sqlite client, but I like [https://itunes.apple.com/us/app/sqlpro-for-sqlite-read-only/id635299994?mt=12 . . . SQLPro for SQLite]. Start your app, copy the string . . .
1K - last updated 2015-08-27 07:04 UTC by 1461
2016-05-24 Swift example of CoreData max query
Here's a copy/paste example of doing the equivalent of a SQL MAX() function. I know, I know "CoreData . . .
2K - last updated 2016-05-24 11:16 UTC by 1461
A Small Oracle 9i
== HOWTO: A Small 9i Database == This thing is HUUUUUGE... Yeah, it's a big beast. But if you need an . . . of the database server. Oracle already had PL/SQL for that, but now Java is available as well. Intermedia . . . can search through them with (almost) plain ole SQL. Click the help button if you want to know about . . . shows a short explanation. ||Shared Pool||12 Mb||SQl and PL/SQL needs to be parsed and turned into bytecode . . . is the shared pool, but for Java instead of SQL and PL/SQL. When you deselected the JVM, this should . . .
13K - last updated 2005-03-18 22:41 UTC by 1461
Bash
= Online resources = [http://ldp.nl.uu.net/LDP/abs/html/ Advanced Bash-Scripting Guide] = Changing numbering . . . as another user in a script run by root: su mysql -c mysql_install_db If you want to run multiple . . . commands, a HERE document is very useful: su - mysql <<HERE execute some commands as user HERE Be careful . . .
10K - last updated 2012-09-14 07:29 UTC by 1461
Bookmarks to check out sometime
* [http://openejb.codehaus.org/ OpenEJB], with an additional [http://www.onjava.com/pub/a/onjava/2003/02/12/ejb_tomcat.html . . . * [http://pginstaller.projects.postgresql.org/FAQ_windows.html Running PostgreSQL 8.0 on . . .
1K - last updated 2006-08-03 14:26 UTC by 1461
Debian
= Package tools = == dpkg-query == This command is meant to query the package database. Some examples: . . . See if some packages, with the string mysql in the name, are installed or not: $ dpkg-query . . . -l '*mysql*' == dpkg == The dpkg command is at its core meant . . . provides a certain file: $ apt-file search mysql.h Or use the web frontend at http://www.debian.org/distrib/packages#search_contents . . .
6K - last updated 2014-01-10 12:17 UTC by 1461
Evolutionary Database Design Dutch
== Evolutionair Database Design == Door Martin Fowler en Pramod Sadalage Vertaald naar het Nederlands . . . geautomatiseerd door het schrijven van SQL DDL (voor de schema verandering) en DML (voor de . . . in plaats daarvan worden zij met een klein SQL script gedraaid op de master om de veranderingen . . . database wordt gebruikt door de applicatie. Als SQL her-en-der verspreid is door de code base, is dit . . . de gebieden in het systeem waar developers SQL kennis nodig hebben om de database te manipuleren, . . .
28K - last updated 2006-03-02 07:19 UTC by 1461
JavaSnippets
To do quick-'n'-dirty timing: boolean debug = true; long startTime = System.currentTimeMillis(); if (debug) . . . { // Do nothing } runtime.append(d); } catch (SQLException se) { runtime.append("-1"); } } } And . . .
3K - last updated 2005-03-14 10:40 UTC by 1461
JDeveloper on Linux
Here I'm listing some news, tips, problems and issues I found while running JDeveloper on Linux. For . . . problem can be partly solved by using the PL/SQL gateway or something else to define views on the . . . preferences, you can type the command to start SQL*Plus. If you use Gnome and want to start SQL*Plus . . . terminal, type something like gnome-terminal -x sqlplus. Note the -x option; don't use -e because it . . . java.lang.NoSuchFieldError: envCharSetId java.sql.SQLException: Character Set Not Supported !!: DBConversion . . .
15K - last updated 2006-01-30 14:56 UTC by 1461
Linux links
* http://www.packetfu.org/hpl.html * http://edseek.com/~jasonb/articles/traffic_shaping/ * [http://fas.sfu.ca/dataface . . . generic package for creating screens on top of MySQL tables . . .
1K - last updated 2007-01-23 12:06 UTC by 1461
Linux on the Desktop
== Linux on the desktop for an Oracle consultant == Larry painted a powerful present and future for Linux, . . . and run like a charm on Linux. Developer and SQL*Plus are specially compiled applications. For TOAD . . . and PL/SQL Developer, there is the open source package TOra, . . .
6K - last updated 2005-04-19 13:33 UTC by 1461
Long-running queries
To put a long-running query in the background, and keep refreshing your JSP until it's done, see below. . . . { // Do nothing } runtime.append(d); } catch (SQLException se) { runtime.append("-1"); } } } And . . .
2K - last updated 2005-11-10 09:11 UTC by 1461
MySQL
= Installation = Install as usual for your distribution. For Debian, this means: $ sudo apt-get install . . . == Setting passwords == After installation of MySQL, set root password as follows: $ mysqladmin -u . . . root password NEWPASSWORD If you prefer the mysql client: $ mysql -u root mysql> SET PASSWORD FOR . . . = PASSWORD('secret'); == Resetting the MySQL root password == The following procedure works . . . UNIX password. Create a file named /tmp/reset.sql with the following lines, and adjust the password: . . .
8K - last updated 2023-01-30 09:45 UTC by bartvk
mysql
[[MySQL]] . . .
1K - last updated 2013-08-09 10:11 UTC by 1461
Parsing and transforming RDF files in PLSQL
When you say 'XML', you'd probably also say 'Java' -- until now, because a stock Oracle database installation . . . gives you a PL/SQL wrapper with which you can access the XML API's. . . . From now on, after 'Java' you'll say 'PL/SQL'. To get an idea of the possibilities, I developed . . . a PL/SQL portlet which parses XML files and walks through . . . is not to scoop the data from the RDF using PL/SQL code, but to transform them directly to HTML by . . .
15K - last updated 2005-03-19 06:57 UTC by 1461
Parsing and transforming RSS files in PLSQL
== TODO == . . .
1K - last updated 2005-03-18 21:14 UTC by 1461
Performance
The subject is: performance measurement of a Linux server. = Measuring bandwidth = First, create a file . . . --sort=rss | sort -n -r | head = Scaling down MySQL = On a default Redhat or CentOS installation, MySQL . . . as follows: # ps -e -o rss,cmd | grep -i mysql 38396 /usr/libexec/mysqld Put the following entries . . . in the /etc/my.cnf file, under the [mysqld] section: innodb_buffer_pool_size = 128k key_buffer_size . . . = 1M The result: # ps -e -o rss,cmd | grep -i mysql 15720 /usr/libexec/mysqld Nice, memory is more . . .
6K - last updated 2013-12-20 08:02 UTC by 1461
PHP
= Standard Packages = Use the PEAR classes, http://pear.php.net/ = Secure programming = Check out the . . . * 20)/20; = Default date = This is more of a MySQL issue, but apparently until version 5.1 of MySQL, . . .
2K - last updated 2009-02-13 20:15 UTC by 1461
RT
= Installation on Debian = Install apache, fastcgi, mysql ... from woody. libcgi-fast-perl libfcgi-perl . . . perl-suid libmysqlclitn10-dev deb http://www.backports.org/debian . . . stable mysql-dfsg http://www.bestpractical.com/rt/draftmanual.pdf . . . perl sbin/rt-test-dependencies --with-mysql --with-fastcgi run perl -MCPAN -e shell and configure . . . perl sbin/rt-test-dependencies --with-mysql --with-fastcgi --install it will install almost . . .
3K - last updated 2006-03-01 09:27 UTC by 1461
SQL
= Oracle's decode in MySQL = I have an Oracle background where a decode instruction was never far away. . . . Nowadays I use MySQL for lots of stuff and when I needed a decode, I . . .
1K - last updated 2007-10-30 13:59 UTC by 1461
SVN
I've written about the differences between SVN and CVS and the usage of the plugins in Eclipse, see also . . . $ patch -p 0 < ~/gron.patch patching file tdb/mysql-telis.sql patching file client/python/plotffo.py . . . A issues/keywords_issue.sql = Creating a new project = To create a new project, . . .
17K - last updated 2014-04-11 10:18 UTC by 1461
UML and JDeveloper
''Jethro Wallenburg en Bart van Kuik'' 3 februari 2003 == Introductie == Al een aantal jaren is het ontwikkelen . . . modelleertool voor de database, die vervolgens SQL genereert. Exporteren van UML door middel van XMI . . .
8K - last updated 2005-03-18 21:13 UTC by 1461
vankuik.nl
= Latest weblog entries = <journal 5> = Weblog Archive = [[Weblog_entries_2024]] [[Weblog_entries_2023]] . . . * [[Parsing_and_transforming_RSS_files_in_PLSQL]] * [http://www.vankuik.nl/bart/docs/report.pdf . . . * [[Perl]] * [[PHP]] * [[Python]] * [[MySQL]] but mostly the administrative side * [[SQL]] . . .
4K - last updated 2024-04-16 10:29 UTC by bartvk
29 pages found.