Difference: DatabaseProgrammingBookmarks (1 vs. 24)

Revision 2428 Dec 2010 - TobyCabot

Line: 1 to 1
 (Back to ProgrammingBookmarks)

Relational databases aren't cool, but they are hugely important to businesses around the world. I've been involved with databases for quite a while, in some cases actively pushing their limits.

Line: 58 to 58
  http://www.mongodb.org/display/DOCS/Home - "Mongo (from "humongous") is a high-performance, open source, schema-free document-oriented database."
Changed:
<
<		http://incubator.apache.org/cassandra/ - "Cassandra is a highly scalable, eventually consistent, distributed, structured key-value store. Cassandra brings together the distributed systems technologies from Dynamo and the data model from Google's BigTable. Like Dynamo, Cassandra is eventually consistent. Like BigTable, Cassandra provides a ColumnFamily-based data model richer than typical key/value systems."
>
>		http://cassandra.apache.org/ - "Cassandra is a highly scalable, eventually consistent, distributed, structured key-value store. Cassandra brings together the distributed systems technologies from Dynamo and the data model from Google's BigTable. Like Dynamo, Cassandra is eventually consistent. Like BigTable, Cassandra provides a ColumnFamily-based data model richer than typical key/value systems."
  http://code.google.com/p/redis/ - "A persistent key-value database with built-in net interface written in ANSI-C for Posix systems", "Redis is a key-value database. It is similar to memcached but the dataset is not volatile, and values can be strings, exactly like in memcached, but also lists and sets with atomic operations to push/pop elements."

Revision 2304 Dec 2010 - TobyCabot

Line: 1 to 1
 (Back to ProgrammingBookmarks)

Relational databases aren't cool, but they are hugely important to businesses around the world. I've been involved with databases for quite a while, in some cases actively pushing their limits.

Line: 35 to 35
  http://wfb2sql.sf.net/ - a neat idea - a script to translate the CIA World Fact Book into SQL.
Changed:
<
<		http://dev.mysql.com/tech-resources/articles/hierarchical-data.html - Managing Hierarchical Data in MySQL
>
>		http://dev.mysql.com/tech-resources/articles/hierarchical-data.html - Managing Hierarchical Data in MySQL
http://dirtsimple.org/2010/11/simplest-way-to-do-tree-based-queries.html - The simplest(?) way to do tree-based queries in SQL
 

Representing Database schemas in XML

Revision 2216 Dec 2009 - TobyCabot

Line: 1 to 1
 (Back to ProgrammingBookmarks)

Relational databases aren't cool, but they are hugely important to businesses around the world. I've been involved with databases for quite a while, in some cases actively pushing their limits.

Added:
>
>		Relational database can be "normalized" to make them more consistent and harder to break: http://en.wikipedia.org/wiki/Database_normalization
 Lately, the most interesting database I've used is Postgresql. Dumb name, great product. http://www.postgresql.org/

Oracle is big and ugly, but so are Mack trucks. Both are useful. Oracle runs on Linux, there are some products to help with this process at: http://www.orasoft.org/

Revision 2112 Oct 2009 - TobyCabot

Line: 1 to 1
 (Back to ProgrammingBookmarks)

Relational databases aren't cool, but they are hugely important to businesses around the world. I've been involved with databases for quite a while, in some cases actively pushing their limits.

Line: 49 to 49
 http://dewdrop.sourceforge.net/ - XML schema and tools for generating DDL
http://www.pimentech.fr/en/technologies/outils
Added:
>
>

Non-SQL Databases

Because SQL isn't always the best choice.

http://www.mongodb.org/display/DOCS/Home - "Mongo (from "humongous") is a high-performance, open source, schema-free document-oriented database."

http://incubator.apache.org/cassandra/ - "Cassandra is a highly scalable, eventually consistent, distributed, structured key-value store. Cassandra brings together the distributed systems technologies from Dynamo and the data model from Google's BigTable. Like Dynamo, Cassandra is eventually consistent. Like BigTable, Cassandra provides a ColumnFamily-based data model richer than typical key/value systems."

http://code.google.com/p/redis/ - "A persistent key-value database with built-in net interface written in ANSI-C for Posix systems", "Redis is a key-value database. It is similar to memcached but the dataset is not volatile, and values can be strings, exactly like in memcached, but also lists and sets with atomic operations to push/pop elements."

Revision 2005 Jun 2009 - TobyCabot

Line: 1 to 1
 (Back to ProgrammingBookmarks)

Relational databases aren't cool, but they are hugely important to businesses around the world. I've been involved with databases for quite a while, in some cases actively pushing their limits.

Line: 33 to 33
  http://wfb2sql.sf.net/ - a neat idea - a script to translate the CIA World Fact Book into SQL.
Changed:
<
<

Representing Databases in XML

>
>		http://dev.mysql.com/tech-resources/articles/hierarchical-data.html - Managing Hierarchical Data in MySQL

Representing Database schemas in XML

  There are many XML schemas for representing relational database metadata:

Revision 1910 Jan 2007 - TobyCabot

Line: 1 to 1
 (Back to ProgrammingBookmarks)

Relational databases aren't cool, but they are hugely important to businesses around the world. I've been involved with databases for quite a while, in some cases actively pushing their limits.

Line: 9 to 9
  SQL isn't the only way to talk to a database. Xplain is an alternative: http://www.berenddeboer.net/xplain/index.html
Added:
>
>		http://datadraw.sourceforge.net/ - a tool to generate special-purpose databases in C. Very fast, not relational.
 

Documentation

This tool builds javadoc-like pages from an Oracle schema. I'm not sure that this is a good idea in general (better to generate docs from the source code), but it could be extremely useful for reverse-engineering. http://oraschemadoc.sourceforge.net/
Line: 45 to 47
 http://dewdrop.sourceforge.net/ - XML schema and tools for generating DDL
http://www.pimentech.fr/en/technologies/outils
Deleted:
<
<		http://datadraw.sourceforge.net/ - a tool to generate special-purpose databases in C. Very fast, not relational.

-- TobyCabot - 23 May 2002

Revision 1810 Jan 2007 - TobyCabot

Line: 1 to 1
 (Back to ProgrammingBookmarks)

Relational databases aren't cool, but they are hugely important to businesses around the world. I've been involved with databases for quite a while, in some cases actively pushing their limits.

Line: 45 to 45
 http://dewdrop.sourceforge.net/ - XML schema and tools for generating DDL
http://www.pimentech.fr/en/technologies/outils
Added:
>
>		http://datadraw.sourceforge.net/ - a tool to generate special-purpose databases in C. Very fast, not relational.
 -- TobyCabot - 23 May 2002

Revision 1710 Jul 2006 - TobyCabot

Line: 1 to 1
 (Back to ProgrammingBookmarks)

Relational databases aren't cool, but they are hugely important to businesses around the world. I've been involved with databases for quite a while, in some cases actively pushing their limits.

Line: 42 to 42
 http://erw.dsi.unimi.it/ - has their own schema
http://www.danny.cz/datadesigner.en.html - has a schema
http://jakarta.apache.org/commons/sandbox/sql/ - Jakarta Commons SQL project
Changed:
<
<		http://dewdrop.sourceforge.net/ - XML schema and tools for generating DDL
>
>		http://dewdrop.sourceforge.net/ - XML schema and tools for generating DDL
http://www.pimentech.fr/en/technologies/outils
  -- TobyCabot - 23 May 2002
Added:
>
>

Revision 1623 Apr 2004 - TobyCabot

Line: 1 to 1
 (Back to ProgrammingBookmarks)

Relational databases aren't cool, but they are hugely important to businesses around the world. I've been involved with databases for quite a while, in some cases actively pushing their limits.

Line: 36 to 36
 There are many XML schemas for representing relational database metadata:

http://www.w3.org/XML/RDB.html - article on w3c website.

Changed:
<
<		http://www.memoriapersistente.pt/en/opensource/gaudi/ - a Java tool that has its own schema for database metadata.
>
>		Gaudi (see above) has its own schema for database metadata.
 http://sourceforge.net/projects/zsqlml - XML DTD and XSLT sheets for various databases.
Hibernate has an option that generates DDL from the hibernate mapping file.
http://erw.dsi.unimi.it/ - has their own schema
http://www.danny.cz/datadesigner.en.html - has a schema
Changed:
<
<		http://jakarta.apache.org/commons/sandbox/sql/ - Jakarta Commons SQL project
>
>		http://jakarta.apache.org/commons/sandbox/sql/ - Jakarta Commons SQL project
http://dewdrop.sourceforge.net/ - XML schema and tools for generating DDL
  -- TobyCabot - 23 May 2002

Revision 1515 Nov 2003 - TobyCabot

Line: 1 to 1
 (Back to ProgrammingBookmarks)

Relational databases aren't cool, but they are hugely important to businesses around the world. I've been involved with databases for quite a while, in some cases actively pushing their limits.

Line: 12 to 12
 

Documentation

This tool builds javadoc-like pages from an Oracle schema. I'm not sure that this is a good idea in general (better to generate docs from the source code), but it could be extremely useful for reverse-engineering. http://oraschemadoc.sourceforge.net/
Added:
>
>		http://www.izzysoft.de/?topic=oracle - orarep is a script that generates a nice-looking report about an oracle database instance.
 

Development

http://www.memoriapersistente.pt/en/opensource/gaudi/ - a Java tool for visual development of database tables.

Revision 1422 Sep 2003 - TobyCabot

Line: 1 to 1
 (Back to ProgrammingBookmarks)

Relational databases aren't cool, but they are hugely important to businesses around the world. I've been involved with databases for quite a while, in some cases actively pushing their limits.

Line: 7 to 7
  Oracle is big and ugly, but so are Mack trucks. Both are useful. Oracle runs on Linux, there are some products to help with this process at: http://www.orasoft.org/
Added:
>
>		SQL isn't the only way to talk to a database. Xplain is an alternative: http://www.berenddeboer.net/xplain/index.html
 

Documentation

This tool builds javadoc-like pages from an Oracle schema. I'm not sure that this is a good idea in general (better to generate docs from the source code), but it could be extremely useful for reverse-engineering. http://oraschemadoc.sourceforge.net/

Revision 1311 Sep 2003 - TobyCabot

Line: 1 to 1
 (Back to ProgrammingBookmarks)

Relational databases aren't cool, but they are hugely important to businesses around the world. I've been involved with databases for quite a while, in some cases actively pushing their limits.

Line: 15 to 15
  http://www.danny.cz/datadesigner.en.html - visual tool for designing database tables, plus a back-end which can translate them into SQL. Gaudi looks better.
Added:
>
>		http://www.59uptime.com/db/index.html - a Java GUI to build database schemas
 http://erw.dsi.unimi.it/ - a web-based tool for database maintenance. Also an excellent example of clean web design using CSS.

http://mdbtools.sourceforge.net/ - tools to manipulate MS Jet (.mdb) databases and move their data into real dbms's.

Revision 1221 Aug 2003 - TobyCabot

Line: 1 to 1
 (Back to ProgrammingBookmarks)

Relational databases aren't cool, but they are hugely important to businesses around the world. I've been involved with databases for quite a while, in some cases actively pushing their limits.

Line: 23 to 23
  http://dbmonster.kernelpanic.pl/ - DB Monster generates large quantities of random data which can be fed into a database and used for stress testing.
Added:
>
>		http://wfb2sql.sf.net/ - a neat idea - a script to translate the CIA World Fact Book into SQL.
 

Representing Databases in XML

There are many XML schemas for representing relational database metadata:

Revision 1116 Aug 2003 - TobyCabot

Line: 1 to 1
 (Back to ProgrammingBookmarks)

Relational databases aren't cool, but they are hugely important to businesses around the world. I've been involved with databases for quite a while, in some cases actively pushing their limits.

Line: 33 to 33
 Hibernate has an option that generates DDL from the hibernate mapping file.
http://erw.dsi.unimi.it/ - has their own schema
http://www.danny.cz/datadesigner.en.html - has a schema
Added:
>
>		http://jakarta.apache.org/commons/sandbox/sql/ - Jakarta Commons SQL project
  -- TobyCabot - 23 May 2002

Revision 1030 Jul 2003 - TobyCabot

Line: 1 to 1
 (Back to ProgrammingBookmarks)

Relational databases aren't cool, but they are hugely important to businesses around the world. I've been involved with databases for quite a while, in some cases actively pushing their limits.

Line: 13 to 13
 

Development

http://www.memoriapersistente.pt/en/opensource/gaudi/ - a Java tool for visual development of database tables.
Changed:
<
<		http://www.danny.cz/datadesigner.en.html - visual tool for designing database tables, plus a back-end which can translate them into SQL.
>
>		http://www.danny.cz/datadesigner.en.html - visual tool for designing database tables, plus a back-end which can translate them into SQL. Gaudi looks better.
  http://erw.dsi.unimi.it/ - a web-based tool for database maintenance. Also an excellent example of clean web design using CSS.
Line: 23 to 23
  http://dbmonster.kernelpanic.pl/ - DB Monster generates large quantities of random data which can be fed into a database and used for stress testing.
Added:
>
>

Representing Databases in XML

There are many XML schemas for representing relational database metadata:

http://www.w3.org/XML/RDB.html - article on w3c website.
http://www.memoriapersistente.pt/en/opensource/gaudi/ - a Java tool that has its own schema for database metadata.
http://sourceforge.net/projects/zsqlml - XML DTD and XSLT sheets for various databases.
Hibernate has an option that generates DDL from the hibernate mapping file.
http://erw.dsi.unimi.it/ - has their own schema
http://www.danny.cz/datadesigner.en.html - has a schema

 -- TobyCabot - 23 May 2002

Revision 915 Jul 2003 - TobyCabot

Line: 1 to 1
 (Back to ProgrammingBookmarks)

Relational databases aren't cool, but they are hugely important to businesses around the world. I've been involved with databases for quite a while, in some cases actively pushing their limits.

Line: 11 to 11
 This tool builds javadoc-like pages from an Oracle schema. I'm not sure that this is a good idea in general (better to generate docs from the source code), but it could be extremely useful for reverse-engineering. http://oraschemadoc.sourceforge.net/

Development

Changed:
<
<		http://www.memoriapersistente.pt/opensource/gaudi/ - a Java tool for visual development of database tables.
>
>		http://www.memoriapersistente.pt/en/opensource/gaudi/ - a Java tool for visual development of database tables.
  http://www.danny.cz/datadesigner.en.html - visual tool for designing database tables, plus a back-end which can translate them into SQL.

Revision 828 Apr 2003 - TobyCabot

Line: 1 to 1
 (Back to ProgrammingBookmarks)

Relational databases aren't cool, but they are hugely important to businesses around the world. I've been involved with databases for quite a while, in some cases actively pushing their limits.

Line: 21 to 21
  http://senora.sourceforge.net/ - a command-line tool for Oracle with a plugin architecture. Aims to replace sqlplus (which would be a wonderful thing to do).
Added:
>
>		http://dbmonster.kernelpanic.pl/ - DB Monster generates large quantities of random data which can be fed into a database and used for stress testing.
 -- TobyCabot - 23 May 2002

Revision 707 Apr 2003 - TobyCabot

Line: 1 to 1
 (Back to ProgrammingBookmarks)

Relational databases aren't cool, but they are hugely important to businesses around the world. I've been involved with databases for quite a while, in some cases actively pushing their limits.

Line: 19 to 19
  http://mdbtools.sourceforge.net/ - tools to manipulate MS Jet (.mdb) databases and move their data into real dbms's.
Added:
>
>		http://senora.sourceforge.net/ - a command-line tool for Oracle with a plugin architecture. Aims to replace sqlplus (which would be a wonderful thing to do).
  -- TobyCabot - 23 May 2002

Revision 620 Jan 2003 - TobyCabot

Line: 1 to 1
 (Back to ProgrammingBookmarks)

Relational databases aren't cool, but they are hugely important to businesses around the world. I've been involved with databases for quite a while, in some cases actively pushing their limits.

Line: 17 to 17
  http://erw.dsi.unimi.it/ - a web-based tool for database maintenance. Also an excellent example of clean web design using CSS.
Added:
>
>		http://mdbtools.sourceforge.net/ - tools to manipulate MS Jet (.mdb) databases and move their data into real dbms's.
 -- TobyCabot - 23 May 2002

Revision 518 Sep 2002 - TobyCabot

Line: 1 to 1
 (Back to ProgrammingBookmarks)

Relational databases aren't cool, but they are hugely important to businesses around the world. I've been involved with databases for quite a while, in some cases actively pushing their limits.

Line: 15 to 15
  http://www.danny.cz/datadesigner.en.html - visual tool for designing database tables, plus a back-end which can translate them into SQL.
Added:
>
>		http://erw.dsi.unimi.it/ - a web-based tool for database maintenance. Also an excellent example of clean web design using CSS.
 -- TobyCabot - 23 May 2002

Revision 407 Sep 2002 - TobyCabot

Line: 1 to 1
 (Back to ProgrammingBookmarks)

Relational databases aren't cool, but they are hugely important to businesses around the world. I've been involved with databases for quite a while, in some cases actively pushing their limits.

Line: 13 to 13
 

Development

http://www.memoriapersistente.pt/opensource/gaudi/ - a Java tool for visual development of database tables.
Added:
>
>		http://www.danny.cz/datadesigner.en.html - visual tool for designing database tables, plus a back-end which can translate them into SQL.
 -- TobyCabot - 23 May 2002

Revision 327 Jun 2002 - TobyCabot

Line: 1 to 1
 (Back to ProgrammingBookmarks)

Relational databases aren't cool, but they are hugely important to businesses around the world. I've been involved with databases for quite a while, in some cases actively pushing their limits.

Line: 7 to 7
  Oracle is big and ugly, but so are Mack trucks. Both are useful. Oracle runs on Linux, there are some products to help with this process at: http://www.orasoft.org/
Changed:
<
<		Documentation - this tool builds javadoc-like pages from an Oracle schema. I'm not sure that this is a good idea in general (better to generate docs from the source code), but it could be extremely useful for reverse-engineering. http://oraschemadoc.sourceforge.net/
>
>

Documentation

This tool builds javadoc-like pages from an Oracle schema. I'm not sure that this is a good idea in general (better to generate docs from the source code), but it could be extremely useful for reverse-engineering. http://oraschemadoc.sourceforge.net/

Development

http://www.memoriapersistente.pt/opensource/gaudi/ - a Java tool for visual development of database tables.
  -- TobyCabot - 23 May 2002

Revision 223 May 2002 - TobyCabot

Line: 1 to 1
 (Back to ProgrammingBookmarks)

Relational databases aren't cool, but they are hugely important to businesses around the world. I've been involved with databases for quite a while, in some cases actively pushing their limits.

Line: 6 to 7
  Oracle is big and ugly, but so are Mack trucks. Both are useful. Oracle runs on Linux, there are some products to help with this process at: http://www.orasoft.org/
Changed:
<
<		-- TobyCabot - 06 Sep 2001
>
>		Documentation - this tool builds javadoc-like pages from an Oracle schema. I'm not sure that this is a good idea in general (better to generate docs from the source code), but it could be extremely useful for reverse-engineering. http://oraschemadoc.sourceforge.net/

-- TobyCabot - 23 May 2002

Revision 106 Sep 2001 - TobyCabot

Line: 1 to 1
Added:
>
>		(Back to ProgrammingBookmarks)

Relational databases aren't cool, but they are hugely important to businesses around the world. I've been involved with databases for quite a while, in some cases actively pushing their limits.

Lately, the most interesting database I've used is Postgresql. Dumb name, great product. http://www.postgresql.org/

Oracle is big and ugly, but so are Mack trucks. Both are useful. Oracle runs on Linux, there are some products to help with this process at: http://www.orasoft.org/

-- TobyCabot - 06 Sep 2001

View topic | History: r24 < r23 < r22 < r21 | More topic actions...
Copyright © 2008-2024 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding The Caboteria? Send feedback