BIEN links

BIEN links Quick links Wiki TWiki syntax syntax Wiki To do Issues srcs SQL VegCore VegBIEN BIEN local vegbiendev vegbiendev nimoy PostgreSQL MySQL mod_rewrite VegPath DwC VegBank SALVIAS TNRS BIEN TWiki default site-wide preferences - TWikiPreferences < TWiki < TWiki Local customisations of site-wide preferences - TWikiPreferences < Main < TWiki BlackListPlugin < TWiki < TWiki /README.txt - BIEN Geo - NCEAS Projects page's description: Redmine 11-02-24 Kickoff Meeting - Scientific Opportunities Team - iPlant Collaborative Wiki Activity Participants: botanical information network Working Group 24th—28th October 2011 | NCEAS BI_Project_Charter - iPToL - iPlant Collaborative Wiki BIEN - / - Repository - NCEAS Projects page's description: Redmine BIEN - Wiki - NCEAS Projects page's description: Redmine BIEN Project | iPlant Collaborative Web Portal bien.pdf Bookmarks Botanical Information and Ecology Network Botanical Information and Ecology Network page's description: NCEAS Project 12290: Developing an integrated botanical information network to investigate the ecological impacts of global climate change on plant biodiversity iPlant Collaborative Web Portal | The iPlant Collaborative: Empowering a New Plant Biology Munin :: nceas.ucsb.edu :: vegbiendev.nceas.ucsb.edu NCEAS Project 12290: botanical information network | NCEAS nimoy nimoy phpPgAdmin Overview of NCEAS Computing and GIS Support Sources « Botanical Information and Ecology Network starscream phpPgAdmin Taxonomic Name Resolution Service /load-geoscrub-input.sh - BIEN Geo - NCEAS Projects page's description: Redmine vegetation data DiGIR DiGIR - Table of Contents DiGIR web-browser client helper scripts. GBIF Data Access and Database Interoperability http://splink.cria.org.br/digir/ http://www.digir.net/prot/release/searchRequestDiGIR1.5.xml search.vm - gbif-occurrencestore - Research into a scalable and feature-rich occurrence store and index - Google Project Hosting DiGIR Messaging Biodiversity Collections Index simple-digir/SimpleDigir.php at master · diogok/simple-digir · GitHub page's description: simple-digir - Tool (class and UI) to simplify search on DIGIR server BCI: Search: BCI: Search: digir TAPIR TAPIR metadata VegBank reinstalling VegBank on VegBankVM VegBank VegBank Data Dictionary: Menu vegbank repository VegBank XML vegbank_erd.pdf VegBranch tools : Normalizer Atlas of Living Australia page's description: The Atlas of Living Australia provides tools to enable users of biodiversity information to find, access, combine and visualise data on Australian plants and animals Atmosphere Bien-db Info Page Canadensys IPT Darwin Core Dashboard - iPlant Collaborative Wiki DwC hist FIA DataMart 5.1 :: Home Home - iPToL - iPlant Collaborative Wiki Home - Taxonomy - NCBI Index Herbariorum :: NYBG.org iTOL: Interactive Tree Of Life Jellyfish Blooms of the Global Ocean: Magnitude, Causes and Consequences for Marine Food Webs, Carbon Cycling and Socioeconomics | NCEAS Mission — TraitNet Norms for data use and publication – Canadensys RAINFOR Smithsonian Tropical Research Institute-Center for Tropical Forest Science Sources speciesLink: networkManager Taxon - darwincore - Darwin Core Project site for discussion and development - Google Project Hosting Taxonomic Name Resolution Service - Home Taxonomic Name Resolution Service - Instructions Taxonomic Name Resolution Service - Instructions Taxonomy - Site Guide - NCBI TDWG: Taxonomic Concept Transfer Schema The National Vegetation Survey Databank (NVS) Tropicos - Home Veg-X Turboveg for Windows Web Services - Tropicos What is SALVIAS? What is the NVS Databank? Biodiversity Collections Index Index of ftp://ftp.gbif.org/ Taxonomic Name Resolution Service - API NCEAS Connect - NCEAS Web IRC Factor Leave Accrual | Administrative Systems Program Management Office Identity :: People Finder Index of /~aaronmk main_page [NCEAS Computing Services Knowledge Base] NCEAS Webmail :: Welcome to NCEAS Webmail Off-Campus Access: Login Staff Computer Setup - NCEAS Knowledge Base support user_accounts [NCEAS Computing Services Knowledge Base] Welcome to NCEAS | NCEAS iPlant Global call-in numbers page's description: 85 System Dashboard - The iPlant Collaborative JIRA TNRS - The iPlant Collaborative JIRA iPlant User Management Notation Guide - iPlant Collaborative Wiki resources Unix bash bash - How to determine function name from inside a function - Stack Overflow bash - How to run an alias in a shell script? - Ask Ubuntu Bash Reference Manual page's description: Bash Reference Manual Detaching processes from the current bash session | Sébastien Wains How to reverse array in bash onliner FOR loop? - Stack Overflow How do I rename a bash function? - Stack Overflow Mivok.net - Bash function renaming and overriding Is there any mechanism in Shell script alike "include guard" in C++? - Stack Overflow Bash Associative Arrays | Linux Journal page's description: The bash man page has long had the following bug listed: "It's too big and too slow" (at the very bottom of the man page). If you agree with that, then you probably won't want to read about the "new" associative arrays that were added in version 4.0 of bash. gnome-keyring linux - store svn password in gnome-keyring - Super User ubuntu - use of gnome-keyring-daemon without X - Super User GNOME Keyring - ArchWiki GNOME Keyring Tool Kenneth Holter » Using Svn client and Gnome keyring in SSH sessions page's description: Subversion client software have traditionally stored (i.e. cached) plaintext user passwords, meaning that you password is accessible by anyone who can access files in your ~/.subversion/auth folder. With Subversion 1.6, make GNU `make' page's description: GNU `make' Override target in makefile to add more commands? - Stack Overflow [ubuntu] On login 5 packages can be updated - Ubuntu Forums page's description: [ubuntu] On login 5 packages can be updated Server Platforms BREs Regular Expressions Command to wait for a process (not a child process) - Ubuntu Forums page's description: Command to wait for a process (not a child process) Programming Talk du question: sort by size & show human-readable sizes - Ubuntu Forums page's description: du question: sort by size & show human-readable sizes Programming Talk Fink - Source Release Download page's description: The Fink Team wants to bring the full world of Unix Open Source software to Darwin and Mac OS X. We modify Unix software so that it compiles and runs on Mac OS X and make it available for download as a coherent distribution GNU `ed' Manual page's description: GNU `ed' Manual How to Convert Uppercase to Lowercase With SED | eHow.com page's description: How to Convert Uppercase to Lowercase With SED. Stream editor, or sed, is a powerful Linux program that you can use to programmatically perform regular edits upon batches of text files. One example of a systematic edit that sed is well-suited for is converting all the letters in a batch of text files from uppercase to lowercase. Install htop on Mac OS X - opinion, technology, culture, politics - themainframe.ca Killing zombie process liblockfile 1.08, lockfile_8h.html linux - How to clear the scrollback in the screen command? - Stack Overflow lockfile_create(3): manage lockfiles - Linux man page page's description: The lockfile_create function creates a lockfile in an NFS safe way. Nice Value of a Process page's description: Hi, All, What is the command to display the nice value of a process? Thanks, August Quick Look Helper process eating virtual memory on Mac - Operating Systems page's description: Quick Look Helper process eating virtual memory on Mac, Operating Systems, Computer end-user technical support troubleshooting for Windows, Mac, and Linux. Operating system tips and tweaks as well.. Rsync include/exclude quirks page's description: Issues with rsync's include and exclude options screen - The Terminal Multiplexer text processing - Multiline pattern match using sed, awk or grep - Unix and Linux What is Umask and How To Setup Default umask Under Linux? page's description: Explains how to read and setup umask (he file mode creation mask of the current process) for file under Linux operating systems using bash shell. What is used to create the shadow password hash?? page's description: Hello, When you create a new user thats able to login etc etc, you also create there password for them, this obviously works with the users password Xterm Control Sequences Linux: Delete user password Access Shared Folders in a VirtualBox Ubuntu 11.04 Virtual Machine page's description: Have you installed Ubuntu 11.04 as a virtual machine in VirtualBox but have had problems getting the Shared Folders feature to work? We were able to add a shared folder, but were unable to access it. uutils - Unix utilities - Google Project Hosting uutils - Revision 126: /trunk Revision Control System - Wikipedia, the free encyclopedia Concurrent Versions System - Wikipedia, the free encyclopedia KVM/VirtManager - Community Ubuntu Documentation Mac sleep wake for network access Wake a sleeping Mac from the network - Mac OS X Hints About Wake on Demand page's description: <p>The Wake on Demand feature of Mac OS X v10.6 or later, lets your Mac continue to share items (such as music, printers, files, or your screen) when it is asleep.</p> Access Your Computer Anytime and Save Energy with Wake-on-LAN page's description: You want access to your home computer wherever you are, whatever you're doing, whether that's via a remote desktop connection, SSH, FTP, web interface, or any other remote access you've set up. The catch is, you don't like throwing money away to an always-on system. Luckily you can have your digital cake and eat it, too, and today I'll show you how to boot and shut down your system remotely so that it's ready for you when you need it and it's not wasting energy when you don't. Indicator of iMac sleep status - Mac OS X Hints pmset(1) Mac OS X Manual Page SmartSleep Why hibernate or 'safe sleep' mode is no longer necessary in OS X Lion (Updated) | TUAW - The Unofficial Apple Weblog page's description: Update: Several commenters expressed concern that disabling safe sleep could expose you to the possibility of drive corruption if you lose power or Dan Bishop » How to mount SFTP/SSH shares in OS X NOW UPDATED to include OS X 10.8 firewall blocks ssh since Sept 12 update: Apple Support Communities OS X: How to reset the DNS cache page's description: <p>Learn how to reset (flush) the DNS cache. </p> osx - List all members of a group (Mac OS X) - Super User Prevent .DS_Store file creation on network volumes - Mac OS X Hints Time Machine: How to transfer backups from the current backup drive to a new backup drive page's description: <p>If you want to switch to a different TIme Machine backup drive, use this article to learn how to transfer your existing Time Machine backups to the new backup drive, and then use it for regular Time Machine backups.</p> Lock the keychain when the screensaver activates - Mac OS X Hints HOWTO: Fix file sorting in Finder’s column view on Mac OS X Lion « inner.geek Force every folder to be arranged by kind and sorted by name? - MacRumors Forums page's description: Force every folder to be arranged by kind and sorted by name? Mac OS X 10.7 Lion svn Executable Files in SVN Apache Subversion FAQ git A Gaggle Of Git Tips | Viget "I use git rebase -i to make sure every commit is clean. For example, when I have two commits with broken code followed by a third clean commit" Effectively Using Git With Subversion | Viget Emmanuel Bernard: How to install Git and git-svn on Mac OS X web Apache 2.4 [ubuntu] Apache 2.4 is ready for you! page's description: ! Please move thread to Server Platforms ! (my mistake) The latest stable apache web server 2.4.2 is available for both 12.04 LTS and Quantal Quetzal ! Test away! Current apache 2.2 users please backup your stuff beforehand! apt-add-repository ppa:ptn107/apache apt-get update apt-get install apache2 https://launchpad.net/~ptn107/+archive/apache Alias 403 Forbidden with Apache - Stack Overflow Expressions in Apache HTTP Server - Apache HTTP Server Question #224526 : Questions : Ubuntu page's description: As company compliance to Requirement 10 of PCI DSS, I recently installed a File Integrity Monitoring system using OSSEC HIDSi and it's been up and running. We are also required to conduct internal vulnerability scan with our network to comply with Requirement 11 and so I used Nexpose Rapid7. After scanning, report says that Linux server running OSSEC is vulnerable through its outdated Apache server (version 2.22) and suggest to upgrade it to version 2.4. Apache server is required for the OSSE... Upgrading to 2.4 from 2.2 - Apache HTTP Server digest auth mod_auth_digest - Apache HTTP Server TracStandalone – The Trac Project apache - How do you htdigest 400 user accounts? - Stack Overflow Advanced Techniques with mod_rewrite - Apache HTTP Server Apache Apache Core Features ErrorDocument directive Apache vs Lighttpd - WikiVS "In Lighttpd you're restricted to rewriting via the config level only, which means for things like Wordpress you will need to hard code the rewrite rule in." apache2 - enabling and disabling sites - Apache - Snipplr Social Snippet Repository page's description: enable and disable sites and modules in apache 2 Beefed Up mod_autoindex Listings « My Ride Home Bug 31210 – Problematic competition between mod_rewrite and mod_dir " > /* if someone used the PASSTHROUGH flag in per-dir > * context we just ignore it. It is only useful > * in per-server context > */ " Bug 38642 – mod_rewrite adds path info postfix after a substitution occured Crazy Advanced Mod_Rewrite Debug Tutorial page's description: Crazy Advanced Mod_Rewrite Debug Tutorial How can I check which version of apache is installed on a Debian machine? - Stack Overflow htpasswd - Manage user files for basic authentication - Apache HTTP Server "The SHA encryption format does not use salting" mod rewrite - .htaccess RewriteRule - DOCUMENT_ROOT and RewriteBase - Stack Overflow mod_alias - Apache HTTP Server mod_autoindex - Apache HTTP Server RewriteRule Flags - Apache HTTP Server Setting up an SSL server with Apache2 page's description: Tips for a Debian GNU/Linux System Administrator. Setting up Self-Signed SSL Certificate to use with Apache Web Server | Knowledge by Experience page's description: In this article, we will see, how to setup a self-signed SSL certificate and configure it to use with Apache Web Server in Ubuntu Linux platform. This i... CSS CSS white-space property page's description: Free HTML CSS JavaScript DOM jQuery XML AJAX RSS ASP .NET PHP SQL tutorials, references, examples for web building. domains AdamsNames IMPORTANT - AdamsNames Changes Breaking: Registry Operator AdamsNames Hacked Locking Up .TC, .GD & .VC page's description: According to a press release we just received by* KSregistry GmbH, which is owned by Key-Systems GmbH, “a third party has executed a transfer of the domain name adamsnames.net and now operates a shadow registry under this domain”. Adams Names is the Registry for the ccTLD’s of .TC, .GD and .VG and uses KSregistry as its back end to operate the registries. “According to the CEO of AdamsNames Ltd., Mr. Carsten Pauli, this transfer was not authorized by the registry operator”. “KSregistry IMPORTANT - AdamsNames Changes (.TC - .GD - .VG) | Hexonet DNS Network Tools: DNS,IP,Email page's description: DNS and Network troubleshooting and diagnostic tools integrated into one sweet interface. Traceroute, Ping, Domain Name Server (DNS) Lookup, WHOIS Deploying DNSSEC | ICANN DNS: DNAME is useless - davidb dives in page's description: DNAME, if you are not aware, is a DNS record type defined in RFC 2672. If you are familiar with the DNS’s CNAME record, then think of DNAME as … BIND - Wikipedia, the free encyclopedia BIND 9's New Resource Records | DNAME, Domain Alias | InformIT page's description: DNS's new version of BIND, BIND 9, implements two new Resource Records to help you take DNS to an advanced level. Learn about them quickly in this article. TLDs GTLD – Trusted Information on Generic Top Level Domains – Verisign page's description: Verisign brings extensive gTLD expertise. We provide premium consulting and technical services to help you apply for, manage, and monetize your new gTLD. List of Internet top-level domains - Wikipedia, the free encyclopedia When will the new gTLDs be released? : Marcaria.com Support page's description: When will the new gTLDs be released?. New gTLDs. Domain Names New TLD List 2012 - New Top Level Domains - New TLDs 2012 page's description: Comprehensive list of the new Top Level Domains (TLD's) for the New TLD program from ICANN in 2012. Free Website Uptime Monitoring - Uptime Robot Linux Basics - Set A Static IP On Ubuntu | HowtoForge - Linux Howtos and Tutorials page's description: Linux Basics - Set A Static IP On Ubuntu subdomain - what are the allowed characters in a sub-domain - Stack Overflow 10 Free Services to Monitor Your Site's Uptime page's description: This series is supported by Rackspace, the better way to do hosting. Learn more about Rackspace's hosting solutions here. You can't sit staring at your monitor 24 hours a day to... Three Letter Domain names page's description: 3 letter domain names .ORG Registrars | .ORG, The Public Interest Registry| Buy, Sell, Register .ORG Domain Names FastCGI Integrating FastCGI with Java Apache module mod_fastcgi Roundcube change password #1483886 (Roundcube doesn't work when password contains escape character "\") – Roundcube Webmail roundcubemail/plugins/password at master · roundcube/roundcubemail · GitHub page's description: The Roundcube Webmail suite. Contribute to roundcubemail development by creating an account on GitHub. roundcubemail/plugins/password/config.inc.php.dist at master · roundcube/roundcubemail · GitHub page's description: The Roundcube Webmail suite. Contribute to roundcubemail development by creating an account on GitHub. Backslash Character in IMAP Password? - Chilkat Q&A Forum page's description: I do have a question though as a user is experiencing a bug: their password has a backslash in it and the library is not able to connect to the IMAP server because the string is not properly escaped. Is there a best practice for this? 28941 – backslash and Double Quote " not escaped for IMAP username Login roundcubemail/plugins/password/drivers at master · roundcube/roundcubemail · GitHub page's description: The Roundcube Webmail suite. Contribute to roundcubemail development by creating an account on GitHub. roundcubemail/plugins/password/drivers/ldap_simple.php at master · roundcube/roundcubemail · GitHub page's description: The Roundcube Webmail suite. Contribute to roundcubemail development by creating an account on GitHub. roundcubemail/plugins/password/drivers/chpasswd.php at master · roundcube/roundcubemail · GitHub page's description: The Roundcube Webmail suite. Contribute to roundcubemail development by creating an account on GitHub. rcube_utils.php in subversion/trunk/roundcubemail/program/include – Roundcube Webmail URLs What Every Developer Should Know About URLs page's description: I have recently written about the value of fundamentals in software development. I am still firmly of the opinion that you need to have your fundamentals down PURL Home Page bitly wikis Redmine Redmine - How to make wiki public - Redmine page's description: Redmine Redmine - RedmineTextFormatting - Redmine page's description: Redmine RedmineWikiFormatting Anchors in wiki pages - Redmine page's description: Redmine Using anchors in redmine - Alexey Bokov’s weblog » Blog Archive » Redmine as corporate wikipedia Feature #4482: Cache textile rendering - Redmine page's description: Redmine Introducing the Redmine Google Docs Plugin | Evolving Web TWiki ForceNewRevisionCheckBox < Codev < TWiki Is there a way to list all the child topics in a parent topic < Support < TWiki ProgrammingSearchesInTWiki < Main < TWiki TextFormattingRules < TWiki < TWiki TreePlugin < TWiki < TWiki TWiki on Ubuntu 10.04 (Lucid) – Linode Library page's description: Install and configure a structured wiki with TWiki. TWikiDocumentation < TWiki < TWiki TWikiOnUbuntu < Codev < TWiki TWikiPreferences < TWiki < TWiki TWikiVariables < TWiki < TWiki BlackListPlugin < Plugins < TWiki Confluence Licensing | Atlassian Pricing | Atlassian Confluence page's description: Confluence pricing starts at $10 for 10 users and scales with your growing business, from startup to enterprise. Download Confluence or try hosted. Convert HTML to XHTML page's description: Online HTML to XHTML converter tool, copy and paste your HTML source code into the box below. Data URI scheme - Wikipedia, the free encyclopedia How to Block Certain Sites in Google Search Results without Extensions | Web Talk page's description: Google users are accustomed to modify the Google official home page with a lot of extensions able to modify the design of the Google search engine page as How to change Tomcat default port ? html - Making an svg image object clickable with onclick, avoiding absolute positioning - Stack Overflow URL Decoder/Encoder weird square favicon | Firefox Support Forum | Mozilla Support How do I force a favicon refresh - Stack Overflow DBs MDB Linux MDB driver - alpha version page's description: OpenOffice.org: The Free, Open Source Office Suite The Electrofriend: How to compile mdbtools on Mac OS X 10.4 and 10.5 MDB Tools - Unlocking Your Data How to Open and Edit MS Access Databases from Mac OS X page's description: Information on how to read and query MS Access databases from Mac OS X. SQL MySQL dynamic SQL How To have Dynamic SQL in MySQL Stored Procedure - Stack Overflow MySQL – Writing dynamic SQL in stored procedures « IT Integrated Business Solutions MySQL :: Re: Dynamic SQl in Triggers/Procdures "Stored procedures called from triggers operate under the same restrictions as triggers, i.e., no dynamic SQL is allowed." MySQL Workbench MySQL :: Download MySQL Workbench MySQL Bugs: #40167: no method to show hidden relationships again MySQL Bugs: #46626: Unable to copy-paste selected tables between two instances of Workbench MySQL Bugs: #67322: MySQL Workbench not installing Ubuntu 12.10 MySQL Workbench Loses Saved Connections - Database Administrators Stack Exchange mysql - ERROR: Error 1005: Can't create table (errno: 121) - Stack Overflow string primary keys mysql - performance penalty of strings as primary keys? - Stack Overflow "we use varchar(32) for primary keys (GUIDs) and we haven't met performance issues of this. Our product is a web site with extreme overload and is critical to be stable. We use SQL Server 2005." vs. other SQL DBs The Codex » Do Not Pass This Way Again --- arguments for MySQL: better UI (phpMyAdmin): "as a user, a company head, and a person who, frankly has no time to screw around with crappy front-ends [which were] ignored because the backend is *so amazingly awesome*" (may be referring to lack of sufficiently-good phpMyAdmin equivalents for other DBs?) ariejan.net page's description: a blog by ariejan de vroom about software engineering and craftsmanship. casting - How to use the CAST function correctly in a MySql SELECT statement? - Stack Overflow "VARCHAR isn't a valid type for the CAST function, but CHAR is." Creating a MySQL View directly in phpMyAdmin | Sky on Tech Getting out of MySQL Character Set Hell < Blue Box Blog How Do I Enable Remote Access To MySQL Database Server? page's description: MySQL Remote Access - A step-by-step guide to enable remote access to a MySQL database server under Linux, UNIX and BSD operating systems. How do I quickly rename a mysql database (change schema name)? - Stack Overflow linux - How to output MySQL query results in csv format? - Stack Overflow mysql - #1071 - Specified key was too long; max key length is 767 bytes - Stack Overflow MySQL – Extract or Restore a Single Table From a Huge mysqldump File page's description: A while back, I wrote an article that explained some awk magic for extracting the restore information for a single table from a mysqldump file. Since then I've created a Perl script that accomplishes the same thing, but is a little more flexible. MySQL :: MySQL 5.1 Reference Manual :: 13.2.6 LOAD DATA INFILE Syntax MySQL :: MySQL 5.1 Reference Manual :: 13.2.8.1 SELECT ... INTO Syntax MySQL :: MySQL 5.5 Reference Manual :: 10.1.9.2 CONVERT() and CAST() MySQL :: MySQL 5.5 Reference Manual :: 11.3 Date and Time Types MySQL :: MySQL 5.5 Reference Manual :: 11.4.2 The BINARY and VARBINARY Types MySQL :: MySQL 5.5 Reference Manual :: 13.1.15 CREATE PROCEDURE and CREATE FUNCTION Syntax MySQL :: MySQL 5.5 Reference Manual :: 13.5 SQL Syntax for Prepared Statements MySQL :: MySQL 5.5 Reference Manual :: 13.6.7.3 RESIGNAL Syntax MySQL :: MySQL 5.5 Reference Manual :: 13.6.7.4 SIGNAL Syntax MySQL :: MySQL 5.5 Reference Manual :: 13.7.1.3 GRANT Syntax MySQL :: MySQL 5.5 Reference Manual :: 13.7.5.11 SHOW CREATE PROCEDURE Syntax MySQL :: MySQL 5.5 Reference Manual :: 14.3.15 Limits on InnoDB Tables MySQL :: MySQL 5.5 Reference Manual :: 14.4.2.1 Overview of Fast Index Creation MySQL :: MySQL 5.5 Reference Manual :: 4.5.1.1 mysql Options MySQL :: MySQL 5.5 Reference Manual :: 4.5.1.2 mysql Commands MySQL :: MySQL 5.5 Reference Manual :: 8.3.8 Comparison of B-Tree and Hash Indexes MySQL :: MySQL 5.5 Reference Manual :: 9.2 Schema Object Names MySQL :: MySQL 5.5 Reference Manual :: MySQL Glossary :: clustered index "Because modifying the columns of the clustered index is an expensive operation, choose primary columns that are rarely or never updated." MySQL :: MySQL 5.6 Reference Manual :: 13.1.1 ALTER DATABASE Syntax MySQL :: MySQL 5.6 Reference Manual :: 4.5.4 mysqldump — A Database Backup Program MySQL :: Re: How to Restore a particular table from the mysqldump of a whole database? MySQL :: Re: latin1_bin vs latin1_general_cs MySQL :: Re: utf8_unicode_ci vs utf8_general_ci MySQL Bugs: #62207: Table comments are truncated to 66 characters rather than the 2048 the db allows MySQL Lists: mysql: Re: Why does mysql drop index very very slow in a large table? MySQL Lists: mysql: RE: Why does mysql drop index very very slow in a large table? MySQL on Mac OS X MySQLdb Need MySQL 4 to ignore ALTER TABLE errors - Stack Overflow What's the opposite of mysqldump to load data back into a database? | drupal.org Extend phpMyAdmin Session Timeout Value (Expired Session) PostgreSQL disk space PostgreSQL: Disk space not released after TRUNCATE - Database Administrators [#JENA-28] Drop Temporary Tables in Postgres (PATCH) - ASF JIRA VACUUM FULL - PostgreSQL wiki PostgreSQL: Documentation: 8.3: CLUSTER Re: ERROR: could not write block 196261 of temporary file: No space left PostgreSQL: PostgreSQL: In place UPDATE disk suddenly full, postgres using all space - Untangle Forums page's description: A customer box that's never used more than a few gigs of space suddenly ran out of disk space so bad the captive portal page wouldn't load properly. doc PostgreSQL: Documentation: 8.3: Array Functions and Operators PostgreSQL: Documentation: 8.3: Control Structures PostgreSQL: Documentation: 8.3: Error Codes PostgreSQL: Documentation: 8.3: Errors and Messages PostgreSQL: Documentation: 8.3: hstore PostgreSQL: Documentation: 8.3: Object Identifier Types PostgreSQL: Documentation: 8.3: pg_enum PostgreSQL: Documentation: 8.3: PL/Python Functions PostgreSQL: Documentation: 8.3: ROLLBACK TO SAVEPOINT PostgreSQL: Documentation: 8.3: Row and Array Comparisons PostgreSQL: Documentation: 8.3: String Functions and Operators PostgreSQL: Documentation: 8.3: System Information Functions PostgreSQL: Documentation: 8.3: The Statistics Collector PostgreSQL: Documentation: 8.4: Errors and Messages PostgreSQL: Documentation: 8.4: Function Overloading PostgreSQL: Documentation: 8.4: Query Language (SQL) Functions PostgreSQL: Documentation: 8.4: WITH Queries (Common Table Expressions) PostgreSQL: Documentation: 9.0: Calling Functions PostgreSQL: Documentation: 9.1: COMMENT PostgreSQL: Documentation: 9.1: CREATE OPERATOR CLASS PostgreSQL: Documentation: 9.1: CREATE RULE PostgreSQL: Documentation: 9.1: CREATE TYPE PostgreSQL: Documentation: 9.1: hstore PostgreSQL: Documentation: 9.1: Object Identifier Types PostgreSQL: Documentation: 9.1: PL/Python - Python Procedural Language PostgreSQL: Documentation: 9.1: Procedural Languages PostgreSQL: Documentation: 9.1: psql PostgreSQL: Documentation: 9.1: Query Language (SQL) Functions PostgreSQL: Documentation: Manuals: Log File Maintenance PostgreSQL: Documentation: Manuals: PostgreSQL 9.1: PostgreSQL 9.1.1 Documentation PostgreSQL: Documentation: Manuals: psql PostgreSQL: Documentation: Manuals: System Administration Functions PostgreSQL: Documentation: Manuals: Template Databases PostgreSQL: Documentation: Manuals: WITH Queries (Common Table Expressions) PostgreSQL: Documentation: 9.1: Binary Data Types invalid byte sequence errors postgresql - How to solve UTF8 invalid byte sequence copy errors on a restore, when the source database is encoded in UTF8? - Database Administrators Stack Exchange invalid byte sequence for encoding "UTF8": 0x00 - Grokbase page's description: (6 replies) Hi, I've got another problem. I sometimes get the following SQLException when doing an insert: ERROR: invalid byte sequence for encoding "UTF8": 0x00 Exception: org.postgresql.util.PSQLException org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525) org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309) org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188) PostgreSQL - hackers - Making TEXT NUL-transparent page's description: Making TEXT NUL-transparent. Occasionally, we get bitten by embedded NUL bytes in TEXT values. We take care of generating proper UTF-8, but this additional restriction sometimes slips by. It would... --- Lack of support for NUL bytes is a critical limitation of PostgreSQL when dealing with arbitrary input data which should be stored verbatim MySQL Converting from other Databases to PostgreSQL - PostgreSQL wiki Converting MySQL to PostgreSQL - Wikibooks, open books for an open world my2pg.pl MySQL vs PostgreSQL - WikiVS "PostgreSQL will feature the MERGE clause in a future version [5], which follows the SQL:2008 standard. This can do the same as MySQL's non-standard 'INSERT IGNORE','REPLACE' and 'INSERT ... ON DUPLICATE UPDATE' statements but with more granularity." "MySQL triggers are also not activated by cascading updates and deletes even when caused by a SQL statement" sql - How can you represent inheritance in a database? - Stack Overflow PostGIS Installing PostGIS on Ubuntu PostgreSQL [KyngChaos Wiki] page's description: Mac OS X installers for PostgreSQL, and GIS extensions PostGIS and pgRouting. Built for Lion and Snow Leopard, 64bit only. NOTE: I do not support any other Postgres distribution in my extensions. Please do not try to install PostGIS in another Postgres and then ask why it won't install. postgresql - Struggling with enabling a PostGIS database on Mac - GIS Install Postgres 9.1, PostGIS and create PostGIS template on Ubuntu 11.10 Oneiric Ocelot — Gist » PostgreSQL – Change Default Encoding of New Databases To UTF-8 (Optional) Journal [GENERAL] ROLLBACK in a function - Google Groups [PostgreSQL-Hackers] DOMAINs and CASTs - Grokbase page's description: (33 replies) Hi, If i create a DOMAIN an then want to create a CAST from that domain to another type it gives an error. Consider this example: """ create domain datetime as timestamp with time zone check (value between '1753-01-01 00:00:00' and '9999-12-31 23:59:59'); create function datetime2int(datetime) returns int language sql stable strict as $$ select $1::date - '1753-01-01'::date; $$; create cast(datetime as int) with function datetime2int(datetime); """ if i try to cast, get this error: select [SOLVED] PostgreSQL Can't Rename Table Constraints page's description: ' I had to rename a table yesterday due to a contact / group name change in the office and sadly I'm the only person who knows how to barely interact /hw/hw1/student/Hw1/postgresql-8.0.3/src/backend/access/transam/xact.c – cs186 – Trac #1018728: postgres NAMEDATALEN limitation create problems | drupal.org Constraint name update in PostgreSQL - Stack Overflow database - how to emulate "insert ignore" and "on duplicate key update" (sql merge) with postgresql? - Stack Overflow How can I change 'shmmax' page's description: I have installed Oracle 9i on RedHat 9. Current value of 'shmmax' is 33554432. Some people recommend value of appr. 50% of the RAM. I tried to change the value of 'shmmax' in two ways: 1. cat 268435456 > /proc/sys/kernel/shmmax 2. sysctl -w kernel.shmmax=268435456 How Do I Enable remote access to PostgreSQL database server? page's description: A step by step guide for enabling remote access to your PostgreSQL database server under Linux or UNIX operating system so that client can connect server remotely. How to edit system catalogs in PostgreSQL 8.1? - Server Fault ilines -- universal newlines from any data source « Python recipes « ActiveState Code logging - Where postgresql logs are on mac os x? - Stack Overflow Maximum columns problem - dBforums page's description: Hi all, I have roughly 30,000 objects (tissue samples) for which I would like to store 1500 attributes for each sample. Each attribute is a numerical MLA Wire: Postgresql: Indexes on Foreign Keys MySQL and Postgres command equivalents (mysql vs psql) | End Point Blog page's description: End Point developers blog about ecommerce, databases, PostgreSQL, MySQL, Interchange, Ruby on Rails, Spree, Django, PHP, Android, hosting, Git, version control, Perl, Python, Java, and SEO. Omega Glory - PostgreSQL Slow Count Workaround pgAdmin Options - Tab 3 (Query) page's description: pgAdmin is the leading graphical Open Source management, development and administration tool for PostgreSQL, running on Windows, Linux, Solaris, FreeBSD and Mac OSX phpPgAdmin - Wikipedia, the free encyclopedia Postgres Session Variables – Neat. | An Oak In The Fall page's description: Postgres Session Variables – Neat. Postgresql - concat_ws like function? - Stack Overflow postgresql - Hash a column in postgres using sha-256 - Stack Overflow PostgreSQL - How to Create User-Defined Type (UDT) - SQLines page's description: You can create a user-defined type using CREATE DOMAIN and CREATE TYPE statements. Quick Example: -- Define a type using CREATE DOMAIN CREATE DOMAIN addr VARCHAR(90) NOT NULL DEFAULT 'N/A'; -- Define a type using CREATE TYPE CREATE TYPE address AS (city VARCHAR(90), street VARCHAR(90)); -- Use them in a table CREATE TABLE location (ship_address addr, full_address address); postgresql - How to include files relative to the current executing script in psql? - Stack Overflow postgresql - Putting EXPLAIN results into a table? - Stack Overflow PostgreSQL - sql - foreign key on pg_shadow page's description: foreign key on pg_shadow. Dear list, Upon designing our application we thought that the following setup would be a good idea to implement security: Using the pg_shadow table as it is: |... PostgreSQL and bloat page's description: /dev/dim PostgreSQL on Mac OS X PostgreSQL services Mac OS X Lion start/stop | blog.hersoncruz.com postgresql, DROP FUNCTION without knowing the number/type of parameters? - Stack Overflow PostgreSQL: assigning ROWNUM (row number) to each returned row | EXPLAIN EXTENDED page's description: How to create fast database queries pqc - PostgreSQL Query Cache - Google Project Hosting psql -f COPY from STDIN - Grokbase page's description: (5 replies) The following command works fine when pasing it to psql via the -c option: cat event.csv | \ psql -c "COPY (event_id, event_name) FROM STDIN DELIMITER AS ',' NULL AS ''" When executed from a file via -f, it does nothing (no error messages either): event.sql: COPY (event_id, event_name) FROM STDIN DELIMITER AS ',' NULL AS '' cat event.csv | psql -f event.sql What's the problem? Many thanks in advance. -- Best Regards, Tarlika Elisabeth Schmitz Psycopg Re: 1600 column limit per table Re: generic options for explain Re: Restoring right side of the display security - How can I hash passwords in postgresql? - Stack Overflow select * from depesz; » Blog Archive » Should you use HASH index? select * from depesz; » Blog Archive » Waiting for 8.4 – hash based DISTINCT SourceForge.net: phpPgAdmin: Detail: 3072065 - "Auto login" doesn't work page's description: phpPgAdmin is a fully functional web-based administration utility for a PostgreSQL database server. It handles all the basic functionality as well as some advanced features such as triggers, views and functions (stored procs) sql - Foreign key to a pg_catalog table in PostgreSQL - Stack Overflow sql - PostgreSQL HASH index - Stack Overflow "It should be noted that as of version 8.4 the issue with Hash indexes being less efficient and slower than b-tree indexes is resolved" sql - What is the maximum number of columns in a PostgreSQL select query - Stack Overflow String Functions and Operators Compatibility - PostgreSQL wiki GUI Database Design Tools - PostgreSQL wiki Implementation Limits For SQLite sql - How can you represent inheritance in a database? - Stack Overflow xkcd • View topic - Inheritance in SQL page's description: also "One table per class with type field: Same as above, with a column in the parent class table indicating the sub-class." "Or... use Postgres http://www.postgresql.org/docs/8.1/stat ... herit.html" xpath to sql translation page's description: Are there any tools (java classes, tag libraries) which can translate xpath statements into a SQL query? Given an xpath query which has a predicate that filters node values or "I've never seen an Xpath to SELECT [] FROM [] WHERE clause translation. And it is not easy to do that, because you have to have rules in how you store xml in a relational database. I think that's also the reason there are no tools to do that." " We have found a couple of products on IBM's Alphaworks site. One of them uses the "DB2 XML Extenders" mapping of XML<=>SQL. The other seems to create a default mapping based on SQL metadata. Both of them are limited to Linux & Windows. While we may use these, our main RDB is DB2 for ISeries. So we are still checking. If you are curious, the links are: http://www.alphaworks.ibm.com/tech/xtable http://www.alphaworks.ibm.com/tech/db2uriaccess " http://publib.boulder.ibm.com/infocenter/iadthelp/v7r0/index.jsp?topic=/com.ibm.etools.logging.ui.doc.user/ref/rmapping_XPath_SQL.html Object-relational database - Wikipedia, the free encyclopedia Python parallel Documentation for processing-0.50 ParallelProcessing - PythonInfo Wiki 16.2. threading — Higher-level threading interface — Python v2.7.3 documentation Parallel Python - Home page's description: Parallel Python 19.6. xml.dom — The Document Object Model API — Python v2.7.2 documentation 20.6. urllib2 — extensible library for opening URLs — Python v2.7.2 documentation 26.4. The Python Profilers — Python v2.7.2 documentation 27.6. warnings — Warning control — Python v2.7.2 documentation 3. Data model — Python v2.7.3 documentation 3.4.1 Basic customization 3.6.2 String Formatting Operations 5. Built-in Types — Python v2.7.3 documentation 5. Expressions — Python v2.7.2 documentation 7.2. re — Regular expression operations — Python v2.7.2 documentation 9.7. itertools — Functions creating iterators for efficient looping — Python v2.7.2 documentation Differences between CPython and Jython Django | GeoDjango | Django documentation page's description: Django is a high-level Python Web framework that encourages rapid development and clean, pragmatic design. MySQLdb User's Guide Overview — Python v2.7.2 documentation PEP 0263 -- Defining Python Source Code Encodings page's description: None Psycopg Python Exception Handling Techniques - Doug Hellmann urllib2 - The Missing Manual page's description: Website of Michael Foord. Python programming articles, projects and technical blog. PEP 3132 -- Extended Iterable Unpacking page's description: None psycopg2.extensions.querycancelederror: copy from stdin failed: error in .read() call - Google Search 13.1. csv — CSV File Reading and Writing — Python v2.7.3 documentation compiled Jython vs. CPython | Python | Python page's description: compiled Jython vs. CPython Python Python "the benchmarks comparing Jython+JIT to CPython are mostly in favour of CPython" "An advantage of jython is that it profits from speedups of the JVM's. Since Java is more widespread than CPython, there is in general more interest in speeding up JVM's than in speeding up the CPython byte code interpreter." Issue 1519638: Unmatched Group issue - workaround - Python tracker 19.5. XML Processing Modules — Python v2.7.4 documentation LDAP LDAPv3 Distinguished Names Appendix E: LDAP core.schema BitTorrent Sync --- SECURITY WARNING: There is an important security hole in the Linux version of BitTorrent Sync: when btsync is run with no arguments, it makes all your files suddenly *world-readable and world-writable*, via a publicly-accessible, unprotected web interface (the WebUI). The WebUI by default allows anyone on the web to create a sync folder to view and edit any files in directories writable by you. To fix this, you apparently *must* use a config file (with the --config option) which is appropriately secured by setting webui > password. If you are currently running btsync without a secured config file, you should run `killall btsync` to turn off the WebUI. You can use `lsof -i` to verify that the WebUI is not running. The security hole has been reported at http://forum.bittorrent.com/topic/18612-security-hole-in-linux-webui-makes-all-your-files-publicly-accessible/ , but it's not clear when/whether they will fix it. WebUI --- located at http://hostname:8888/gui/ BitTorrent WebUI - Videos & Guides - Help - BitTorrent - Delivering the World's Content page's description: BitTorrent is a fast and easy client for Windows and Mac with many features. Question about the webUI - BitTorrent Sync - BitTorrent Forums page's description: Question about the webUI - posted in BitTorrent Sync: Because I'd like to run this on a headless linux server, I'm obviously not going to be connecting from localhost. When I connect from a LAN interface on it's LAN IP I get "Invalid request" as shown below:- However, if I create an SSH tunnel so I'm connecting from localhost (In this case, 0.0.0.0:8889 --> localhost:8888) it works:- Is there anyway to get BitTorrent Sync to accept LAN requests? Keeping an S... .SyncIgnore is great but... - BitTorrent Sync - BitTorrent Forums page's description: .SyncIgnore is great but... - posted in BitTorrent Sync: .SyncIgnore is a file where you can filter out files you don't want synced. However it seems that when I put files in here bittorrent decides to delete those files rather than leave them un-touched. That is unexpected. Is this a bug? Expected behavior? Am I using it wrong? Cheers Install on Linux - BitTorrent Sync - BitTorrent Forums page's description: Page 1 of 2 - Install on Linux - posted in BitTorrent Sync: I just got my invite for Sync really like it so far, but i am not able to install the Linux version (SyncApp_i386-1.0.63). my Linux expert says it is missing its header. do we do something wrong or is this an bug? Move synced directory - BitTorrent Sync - BitTorrent Forums page's description: Move synced directory - posted in BitTorrent Sync: I would like to move where a directory is synced to without re-syncing it. Suppose I have given a read-only key to 10 other people, and now I want it stored in a different place on my machine. Is there any way of doing that without having them all delete the old and add a new key? Bug #788256 “inkscape cannot dock toolbars” : Bugs : “inkscape” package : Ubuntu page's description: Binary package hint: inkscape I installed Inkscape for the first time on Ubuntu 11.04 and I see that the main toolbar and the toolbar for sticking lines and segments where on the right side (later noticed the "wide" and "standard" views). 1) I tried to move the main toolbar and it worked like expected in vertical mode. I could however not dock the toolbar on top, horizontally. 2) When I tried to move the other toolbar it would not dock anywhere, not even where it was at the beginning. Pro... Compatibility - Microsoft Access 2000 - CodeWeavers Converting UTF8 to Latin1 Creating Hyperlinks in Adobe Acrobat « Acrobat for Legal Professionals page's description: The Acrolaw Blog is a resource for lawyers, law firms, paralegals, legal IT pros and anyone interested in the use of Acrobat in the legal community. Rick Borstein– the author of the blog– is the Business Development Manager for Acrobat in the Legal Market for Adobe Systems. English to French, Italian, German & Spanish Dictionary - WordReference.com page's description: Free online Oxford dictionaries - Spanish, French, Italian, German and more. Conjugations, audio pronunciations and forums for your questions. Hamming distance - Wikipedia, the free encyclopedia How To Create An Image Map Using GIMP page's description: Have you ever wanted to add an image map to your web site? An image map is a graphic that contains hotspots that link to URLs. They are used as a means t java - What is a regex "independent capturing group"? - Stack Overflow Password Strength Test PHP: $_SERVER - Manual Safari Books Online - Home utf8-decoder virtualbox.org • View topic - Shared folder permissions WARNING: <file> failed verification -- update discarded (will try again). XSLT Tutorial page's description: Free HTML XHTML CSS JavaScript jQuery XML DOM XSL XSLT RSS AJAX ASP .NET PHP SQL tutorials, references, examples for web building. cryptography - Is SHA1 better than md5 only because it generates a hash of 160 bits? - IT Security Stack Exchange Google Google Calendar remember password Recent Tags Recently Bookmarked