=== The Babase Documentation === * [[http://papio.biology.duke.edu/pocket_reference.pdf|The Babase Pocket Reference]] is the place to go for diagrams * [[http://papio.biology.duke.edu/babase_system_html|The Babase Technical Documentation]] * Overview of [[WhatIsBabase|the Babase software project]] for the general public === Related Sites === * [[http://www.princeton.edu/~baboon/|The Amboseli Baboon Research Project]] * [[http://www.princeton.edu/~baboon/monitoring_guide.htm|Amboseli Baboon Research Project Monitoring Guide]] === Documentation on the software Babase uses === * The [[http://www.postgresql.org|PosgreSQL]] web site * Postgresql version 16 [[http://www.postgresql.org/docs/16/static/index.html|documentation]] * There are two complete on-line books on PostgreSQL. These include information on accessing the database using the psql Unix command. * [[http://www.postgresql.org/docs/books/awbook.html|PostgreSQL: Introduction and Concepts]] * [[http://www.faqs.org/docs/ppbook/book1.htm|Practical PostgreSQL]] * The Babase phpPgAdmin interface contains little question marks which are links to documentation * The [[http://phppgadmin.sourceforge.net/|phpPgAdmin]] web site * The phpPgAdmin [[http://phppgadmin.sourceforge.net/?page=faq|documentation]] is geared to the system's administrator but may contain some useful information === Places to go for help === Babase users are encouraged to ask questions, both on the Babase mailing list and on the mailing lists setup for questions on the software which Babase is made of. The article [[http://www.catb.org/~esr/faqs/smart-questions.html|How to Ask Questions the Smart Way]] provides good information on how to get answers when writing public mailing lists. When asking SQL related question it will almost certainly be a good idea to include a reference to http://papio.biology.duke.edu/pocket_reference.pdf and the entity-relationship diagrams contained therein. For questions specific to babase write to the [[BabaseMailingLists|Babase mailing list]] or look through its associated [[http://www.eco.princeton.edu/pipermail/babase/|archive]] to see if the question has not already been answered. For questions about SQL there is PostgreSQL's mailing list for [[http://archives.postgresql.org/pgsql-novice/|beginner's questions]], PostgreSQL's mailing list for [[http://archives.postgresql.org/pgsql-sql/|SQL questions]], and the PostgreSQL [[http://archives.postgresql.org/pgsql-general/|general mailing list]]. For questions on the Babase web interface, including how to submit SQL queries, download results, and so forth, there is the phpPgAdmin [[http://sourceforge.net/forum/forum.php?forum_id=115884|help forum]]. If you have a Babase-specific question, check the [[FAQs|Babase FAQs]] before asking a data manager or project leader. === Tips === Save your queries so you can re-run them later, need be. Put the really useful ones on this wiki.