jchris + database   70

Installing PostgreSQL on Mac OS X 10.4
Installing PostgreSQL on Mac OS X 10.4
perl  database  postgres  osx 
may 2018 by jchris
How to speed up your MySQL queries 300 times | Opensource.com
MySQL has a built-in slow query log. To use it, open the my.cnf file and set the slow_query_log variable to "On." Set long_query_time to the number of seconds that a query should take to be considered slow, say 0.2. Set slow_query_log_file to the path where you want to save the file. Then run your code and any query above the specified threshold will be added to that file.
database  mysql  knowhow  performance 
may 2018 by jchris
Horizontally scaling databases: MySQL/Postgres Sharding
At some point, a single database instance starts to creak as more objects are added to it, even with read-only replication. A battle-proven strategy here is to scale horizontally via sharding, however there be dragons. Here are general design principles on sharding with relational databases such as MySQL and Postgres.
database  design  postgres 
april 2018 by jchris
IP2Location™ IP-Country Database [DB1] | IP2Location.com
DB1 IP-Country Database (USD $49.00 / Year * FOR SINGLE SERVER) -==- IP2Location™ IP-Country Database [DB1] provides a solution to determine the country of origin for any IP address in a few simple steps. First, retrieve the IP address from the networking protocol or server-side variable of the Web server. Next, translate the IP address to an IP number in decimal format to speed up the database query. Lastly, reverse lookup the IP number from the IP2Location™ database to pinpoint the exact geographical location. -==- This is a database subscription service. You can download all monthly updates for free if subscription is active. -==- IPv4 and IPv6 supported.
database  ip  networking  sysadmin 
february 2018 by jchris
Debian packages as Graph Database – There and back again
I have been playing around with Neo4j as graph database, and searching for a big dataset I decided to look at Debian packages (source and binary) from stable, testing, sid, and experimental, and represent all of that in a big graph database.
database  visualization  ebook 
september 2017 by jchris
The Helsinki Declaration (IT-version): The Helsinki declaration: observation 1
About how database web application development nowadays has gone absolutely and utterly absurd. -==- May 2008 - in Helsinki - a new approach for designing and implementing database web applications was presented. It was there and then declared to be "the only right way to build these kind of applications."
september 2017 by jchris
bobby-tables.com: Ein Leitfaden gegen SQL-Einschleusung
Bobby Tables: Ein Leitfaden gegen SQL-Einschleusung (how to prevent SQL Injection)
sql  database  xkcd 
november 2014 by jchris
Flat File Database Manager
Free flat-file database management system written in Perl, that can handle multiple databases and configures easily to any number of fields. Works virtually 'straight out of the box'. Ideal when you don't need huge, relational, database setups like MYSQL etc. -=- Best used on Unix based Apache Web Servers.
database  perl 
april 2010 by jchris
Das Pflanzenreich
Die geläufigste Unterteilung des Pflanzenreiches ist nach A. Engler, 1954, die hier als Grundlage dient. Erweitert wurde sie dann nach den Arbeiten von L. Watson and M. J. Dallwitz (2000).
botanik  garten  knowhow  database 
may 2008 by jchris
Im Kräuterlexikon des Kräuter-Almanach finden Sie mehr als 200 Kräuter mit Fotos und fundierten Beschreibungen. -=- Wir beschreiben überwiegend heimische Gartenkräuter und Wikdkräuter.
garten  kräuter  pflanzen  database 
april 2008 by jchris
Zimmerpflanzenlexikon.info - Das große Lexikon der Zimmerpflanzen
Zimmerpflanzen sind schon seit vielen Jahren ein großes Hobby von mir, und aus einem kleinen Projekt an der Uni ist inzwischen diese Website geworden. Bisher war das Lexikon nur Teil meiner privaten Homepage, aber da sich eigentlich die meisten Besucher
botanik  database  lexikon  pflanzen 
april 2008 by jchris
500 für den Naturgartenbau verwendbare, einheimische Stauden und Gehölze mit Fotos und 320 Bildtafeln von Dr. Wilhelm Otto Thomé, Flora von Deutschland, Österreich und der Schweiz (1875-1905). -=- Die Kennzahlen (FRN/LTK) entsprechen den Angaben der
botanik  database  garten  pflanzen 
april 2008 by jchris
* 8000 Zeitungen & Magazine : METAGRID - Die Datenbank für Publikationen im Web
Metagrid ist der redaktionell gepflegte Katalog für alle Online-Publikationen im Internet. Sie können nach Zeitungen und Magazinen weltweit recherchieren.
bibliothek  database  deutsch  search  zeitschriften  zeitungen 
april 2008 by jchris
Progetto Dryades / Dryades Project
[...] the development of innovative tools for the identification of organisms, and on their introduction in the world of education, from primary schools to universities. The website of Dryades gives access to interactive guides for the identification of p
biologie  botanik  database  tools  italien  lang:en  lang:it 
april 2008 by jchris
DBMEdit-- DBM Database Editor
If you use DBM files, this program makes them easy to edit. Each value stored in a DBM file is treated as several "fields", delimited by a user-defined string-- in effect, supporting multiple columns within the one-column DBM format. This program displays
cgi  database  perl 
november 2007 by jchris
ONLamp.com -- Using MySQL to Stop Editing Web Pages
Although there's much that can be done with web design, sometimes I find it to be extremely boring. When I'm deep into a Perl project, the last thing I want is to meet with other department managers to discuss changes in the text on the corporate web site
article  cms  database  mysql  perl  tips  webdesign  oreilly  onlamp 
november 2007 by jchris
Wir hacken eine SAP Datenbank
Wie man ein SAP hacken kann und dabei seinen Spaß hat -=- Warnung: Kids, don't do that at home. Allerdings benutzen wir nur Standardtechniken, die jedem Admin lange bekannt sind.
database  hack  howto  security  tutorial 
november 2007 by jchris
CDR - Common Lisp Document Repository
The Common Lisp Document Repository is a repository of documents that are of interest to the Common Lisp community. The most important property of a CDR document is that it will never change: if you refer to it, you can be sure that your reference will al
common-lisp  database  directory  documentation  lisp  reference 
october 2007 by jchris
teltarif.de - 0180-Telefonbuch
Das 0180-Telefonbuch ist eine Liste mit günstigeren Ersatznummern für die teuren Hotlines mit der Vorwahl 0180 und lebt von der Mitarbeit der Benutzer. Wenn Sie eine Nummer kennen, die noch nicht in der Liste enthalten ist, tragen Sie diese bitte in das
auskunft  0180  deutsch  telefon  teltarif  database 
september 2007 by jchris
heise Security - Know-how - Giftspritze
SQL-Injection - Angriff und Abwehr -=- SQL-Injection bezeichnet das Einschleusen von eigenen Befehlen in eine SQL-Datenbank. Überprüft eine Web-Applikation Benutzereingaben nicht ausreichend, ist damit jede Datenbank auf jedem Betriebssystem verwundbar.
article  database  programming  security  sql  sql-injection  heise 
september 2007 by jchris
Archival Research Catalog - Main Page
The Archival Research Catalog (ARC) is the online catalog of NARA's nationwide holdings in the Washington, DC area, Regional Archives and Presidential Libraries.
database  gallery  history 
july 2007 by jchris
ART-Guide - Sammlung kunsthistorischer Internetquellen
ART-Guide bietet Zugang zu ausgewählten kunsthistorischen Internetquellen, wie Fachportalen, Bilddatenbanken, Suchmaschinen oder Mailinglisten. Thematisch umfasst die Sammlung die gesamte Europäische Kunstgeschichte von der Kunst der Spätantike bis hin
art  kunst  database  portal  reference  xrefs 
july 2007 by jchris
Fake Name Generator
We've generated millions of names for hundreds of companies and individuals! We can provide test data in several formats (including MySQL, CSV, tab delimited, and Excel) absolutely free through our Order in Bulk page.
database  generator  identity  privacy  security  testing 
july 2007 by jchris
Garten + Pflanzen: Gartenpflanzen, Wildpflanzen, Gartengestaltung, Naturgarten anlegen @ GartenDatenbank.de
Diese persönliche Pflanzendatenbank von Gabriele Jesdinsky und anderen Garten- und Pflanzenliebhabern ist seit 1999 entstanden und soll eine Möglichkeit zum schnellen Nachschlagen, zur Fortbildung sowie zur Entspannung und Freude durch das Betrachten sc
garten  pflanzen  database  reference  @goodie 
july 2007 by jchris
Advanced filesystems beyond metacrap | Not a blog
With the Redmond megacorporation doing it, implementing database filesystems is popular these days. Without much success. Metacrap is not the only problem. The lack of human-readable unique identifiers is another potential problem, at least from the point
article  blog  database  design  metadata  filesystem 
december 2006 by jchris
isbndb.com - free ISBN database
ISBNdb.com project is a database of books in different languages providing on-line and remote research tools for individuals, librarians, scientists, etc. Taking data from hundreds of libraries across the world ISBNdb is a unique tool you won't find anywh
biblio  books  isbn  database  library  reference 
december 2006 by jchris
WTU Herbarium Image Collection - Burke Museum
Washington State contains a diverse array of landscapes, from lush coastal rainforests to dry sagebrush plains, high alpine meadows and much more in between. Across these landscapes an equally diverse array of plants can be found; by our estimate Washingt
botanik  database  pflanzen  gallery  photography  reference 
november 2006 by jchris
Welcome to Discogs a user-built database of music information. Imagine a site with discographies of all labels, all artists, all cross-referenced. It's getting closer every day.
music  community  database  discography 
october 2006 by jchris
Botanikseite mit Datenbanken für botanische Pflanzennamen und Giftpflanzen sowie vielen Fotos
Botanikus versteht sich als populär-wissenschaftliche Botanikseite und ist somit nicht nur für botanische Laien sondern auch für Schüler, Auszubildende, Studenten und Fachleute eine wahre Fundgrube.
botanik  database  foto  howto  pflanzen  reference  tips 
october 2006 by jchris
Encyclopedia - ChemgaPedia
ChemgaPedia ist die weltweit umfangreichste curriculare Enzyklopädie zur Chemie. Sie umfasst über 15.000 Seiten, 25.000 Medienobjekte, 900 Übungen und 2.500 Glossar- und Biographieeinträge in den Fächern: Chemie, Biologie, Pharmazie, Mathematik,Physi
chemistry  chemie  database  encyclopedia  knowhow  reference 
october 2006 by jchris
Mork: a case study in "clever" programming -- The Hard Way
I had a bit of a coding itch to scratch, so I decided on a whim to take a look at Mozilla's address book format. -=- I learned that Mozilla stores history and address book data in users' profiles in a textual database format called Mork. Rather than store
article  database  design  mork  mozilla  firefox  programming 
september 2006 by jchris
Debian Package Tags
The size of Debian increases, and the "Sections:" system has proven unable to scale to keep pace with it. -=- There has been much consensus around a multiple tags per package solution: the Debian Package Tags system is a working implementation.
database  debian  linux  metadata  reference  tagging 
september 2006 by jchris
Welcome to MusicBrainz! - MusicBrainz
MusicBrainz is a community music metadatabase that attempts to create a comprehensive music information site. You can use the MusicBrainz data either by browsing this web site, or you can access the data from a client program — for example, a CD player
audio  music  community  database 
august 2006 by jchris
Startseite - Der Bio-Gärtner
diese Internet-Präsenz möchte Ihnen als Nachschlagewerk und Einkaufsberater für alle Fragen dienen, die anderswo nicht, oder nicht ausreichend, beantwortet werden. Besonderen Wert habe ich hierbei auf eine ökologische Betrachtungsweise gelegt, und i
garten  bio  database  gewürze  naturgarten  pflanzen 
june 2006 by jchris
O'Reilly Radar > Database War Stories #9 (finis): Brian Aker of MySQL Responds
Brian Aker of MySQL sent me a few email comments about this whole "war stories" thread, which I reproduce here. Highlight -- he says: "Reading through the comments you got on your blog entry, these users are hitting on the same design patterns. There are
architecture  database  oreilly  mysql  tim-oreilly 
may 2006 by jchris
Geeking with Greg: Early Amazon: Splitting the website
Now that commodity Linux servers are so commonplace, it is easy to forget that, during the mid and late 1990's, there was a lively debate between whether sites should scale up using massive, mainframe-like servers (Sun's Star Fire being a good example) or
amazon  cluster  database  linux  sql  history 
may 2006 by jchris
O'Reilly Radar > Database War Stories #8: Findory and Amazon
Once Greg Linden had pinged me about BigTable (leading to yesterday's entry), it occurred to me to ask Greg for his own war stories, both at Findory and Amazon. We hear a recurrent theme: the use of flat files and custom file systems. Despite the furor th
database  amazon  oreilly  tim-oreilly  web2.0 
may 2006 by jchris
O'Reilly Radar > Database War Stories #7: Google File System and BigTable
Greg Linden of Findory wrote: "I've been enjoying your series on O'Reilly Radar about database war stories at popular startups. I was thinking that it would be fantastic if you could get Jeff Dean or Adam Bosworth at Google to chat a little bit about thei
database  design  google  oreilly  tim-oreilly  web2.0 
may 2006 by jchris
O'Reilly Radar > Database War Stories #6: O'Reilly Research
In building our Research data mart, which includes data on book sales trends, job postings), blog postings, and other data sources, Roger Magoulas has had to deal with a lot of very messy textual data, transforming it into something with enough structure
database  oreilly  sql  tim-oreilly  web2.0 
may 2006 by jchris
Computer and Information Science Papers CiteSeer Publications ResearchIndex
CiteSeer is a scientific literature digital library and search engine that focuses primarily on the literature in computer and information science. CiteSeer aims to improve the dissemination and feedback of the scientific literature and to provide improve
aggregator  database  paper  reference  science  citeseer 
may 2006 by jchris
The Encyclopedia of Computer Languages
HOPL: an interactive Roster of Programming Languages -- Welcome to HOPL, the History of Programming Languages. -- This site is concerned with the idea-historical treatment of the development of programming languages as a means of human expression and crea
@goodie  database  history  hopl  language  programming  reference 
may 2006 by jchris
O'Reilly Radar > Database War Stories #5: craigslist
Eric Scheide of craigslist offered me a stream of consciousness summary of the craigslist database setup. At a conference last year, Craig showed a slide (which helped inspire my postings about asymmetric competition) that listed the number of employees a
database  craigslist  oreilly  tim-oreilly  web2.0 
april 2006 by jchris
O'Reilly Radar > Database War Stories #4: NASA World Wind
Patrick Hogan of NASA World Wind, an open source program that does many of the same things as Google Earth, uses both flat files and SQL databases in his application. Flat files are used for quick response on the client side, while on the server side, SQL
article  database  nasa  world_wind  web2.0  oreilly  tim-oreilly 
april 2006 by jchris
O'Reilly Radar > Database War Stories #3: Flickr
Continuing my series of queries about how "Web 2.0" companies used databases, I asked Cal Henderson of Flickr to tell me "how the folksonomy model intersects with the traditional database. How do you manage a tag cloud?"
article  database  flickr  oreilly  tim-oreilly  folksonomy  tagging  web2.0 
april 2006 by jchris
O'Reilly Radar > Database War Stories #2: bloglines and memeorandum
In Monday's installment, Cory Ondrejka of Second Life said "flat files don't cut it", but Mark Fletcher of bloglines and Gabe Rivera of memeorandum.com apparently don't agree.
database  oreilly  tim-oreilly  bloglines  memeorandum  web2.0 
april 2006 by jchris
O'Reilly Radar > Web 2.0 and Databases Part 1: Second Life
As part of the prep for my keynote on Wednesday at the MySQL User Conference, I decided to ask some of my Web 2.0 friends just how they were using databases in their applications. Over the next couple of days, I'm going to post what I heard back. I'm not
database  mysql  oreilly  tim-oreilly  web2.0 
april 2006 by jchris
Museum of Hoaxes
The Museum was established in 1997 in order to promote knowledge about the phenomenon of hoaxes. It plays host to a variety of humbugs and hoodwinks—from ancient deceptions all the way up to modern schemes, dupes, and dodges that circulate on the intern
cool  database  folklore  fun  history  hoax  humor  museum  reference 
april 2006 by jchris
ONLamp.com -- Writing Apache's Logs to MySQL
In Profiling LAMP Applications with Apache's Blackbox Logs, I discussed using Apache's built-in logging directives to record server performance metrics. By recording performance metrics, web server administrators can have a historical record of how the se
apache  database  howto  mysql  sysadmin  webmaster  onlamp  oreilly 
april 2006 by jchris
Welcome to the Daversy project -- Daversy is a source control tool for relational databases. -- That means that it can help you do the following things :

* Keep a history of changes to your database.
* Instantly create a database for any version o
database  backup  cvs  programming  scm  subversion  sql  mysql 
april 2006 by jchris
Mapping Objects to Relational Databases: O/R Mapping In Detail
Most modern business application development projects use object technology such as Java or C# to build the application software and relational databases to store the data. This isn’t to say that you don’t have other options, there are many applicati
database  persistence  design  howto  java  sql  tutorial 
april 2006 by jchris
Main Page - Forensics Wiki
This is the Forensics Wiki, devoted to information about digital forensics. -- Much of computer forensics is focused on the tools and techniques used by investigators, but there are also a number of important papers, people, and organizations involved. Ma
@goodie  @toread  forensics  security  wiki  database  howto  sysadmin 
march 2006 by jchris
Nested Sets -- Working with hierarchies in relational databases
Something that I have been asked about MANY times before is how to handle tree data in a relational database. There are several ways to do it, and this is the result of my investigations into this subject when I was new to database design and I have writt
database  sql  tree  tutorial 
february 2006 by jchris
TurboGears: Front-to-Back Web Development
Create a database-driven, ready-to-extend application in minutes. All with designer friendly templates, easy AJAX on the browser side and on the server side, not a single SQL query in sight with code that is as natural as writing a function.
ajax  database  framework  javascript 
january 2006 by jchris
memcached: a distributed memory object caching system
memcached is a high-performance, distributed memory object caching system, generic in nature, but intended for use in speeding up dynamic web applications by alleviating database load.
caching  database  distributed  perl 
december 2005 by jchris
TrimQuery - TrimPath - Trac
For rich web application developers, the TrimQuery engine from TrimPath is a lightweight GPL open-source component that lets you have the power of SQL queries while running in a web browser.
ajax  dhtml  javascript  sql  database 
december 2005 by jchris
AJAX MAssive Storage System (AMASS)
The AJAX MAssive Storage System (AMASS) uses a hidden flash applet to allow JavaScript AJAX applications to store an arbitrary amount of sophisticated information on the client side. This information is permanent and persistent; if a user closes their bro
ajax  database  javascript  web  flash 
december 2005 by jchris
Linking Chan/Seon/Zen Figures and Their Texts: Mohr: JoDI
Problems and Developments in the Construction of a Relational Database
database  design 
october 2005 by jchris

related tags

0180  @goodie  @toread  aggregator  ajax  amazon  apache  architecture  art  article  audio  auskunft  backup  baum  biblio  bibliothek  bibtex  bildagentur  bio  biologie  blog  bloglines  books  botanik  caching  cgi  chemie  chemistry  citeseer  cluster  cms  common-lisp  community  cool  craigslist  cvs  database  debian  design  deutsch  development  dhtml  directory  discography  distributed  diy  documentation  ebook  education  encyclopedia  filesystem  firefox  flash  flickr  folklore  folksonomy  fonts  forensics  foto  framework  freeware  fun  gallery  garten  generator  gewürze  google  hack  hausbau  heise  history  hoax  hopl  howto  humor  hypercard  identity  image  ip  isbn  italien  java  javascript  join  knowhow  kräuter  kunst  lang:en  lang:it  language  lexikon  library  linux  lisp  macintosh  mashup  memeorandum  metadata  mork  mozilla  museum  music  mysql  nasa  naturgarten  networking  onlamp  openoffice  oreilly  osx  paper  performance  perl  persistence  pflanzen  photography  portal  postgres  postgresql  privacy  programming  quotes  reference  resource  science  scm  search  security  sql  sql-injection  subversion  sysadmin  tagging  taxonomy  telefon  teltarif  testing  tim-oreilly  tips  tools  tree  tutorial  typography  visualization  web  web2.0  webdesign  webmaster  wiki  world_wind  xkcd  xrefs  zeitschriften  zeitungen 

Copy this bookmark: