tags: blog, database

Action executed in 0.000

Each Tag

blog, database

Common tags - number of posts

TrickleUp (11), OSM (3), mapper (2), PostgreSQL (2), beer (2), math (2), comment (2), geo (2), ERD (2), food (2), web (2), politics (2), nutrition (2), TIGER (1), map (1), HTML (1), Linux (1), awesome header (1), PostGIS (1), Elwing (1), bug (1), cookie (1), local (1), to read (1), threading (1), USDA (1), model (1), custom (1), cms (1), structure (1), Mozilla (1), wine (1), online (1), CHART (1), CSS (1), open source (1), image tag (1), programming (1), JpGraph (1), client (1), Web 2.0 (1), exception handler (1), developer (1), Zach (1), user input (1), software (1), Akonadi (1), fiction (1), recipes (1), normal form (1), changeset (1), articles (1), authentication (1), parenting (1), fosm (1), poll (1), Python (1), number (1), trackbacks (1), Xerces (1), Debian (1), DC (1), scrape (1), graph (1), TrickleUp Effect (1), PowerMac G5 (1), upgrade (1), traffic (1), fan (1), JavaScript (1), manager (1), kernel (1), aggregate (1), speed (1), scan (1), anonymity (1), java (1), friend (1), maps (1), Jenkins (1), science (1), news (1), tech (1), environment (1), privacy (1), interactive (1), GIS (1), comments (1), address (1), Thoughts (1), Bryce (1), advice (1),

3 way join

TrickleUp, blog, database

Sub groups 1

TrickleUp, bug, comments, database, kernel (1), aggregate, blog (1), HTML, blog, image tag (1), beer, blog (1), PostGIS, PostgreSQL, TIGER, beer, database, map, programming (1), Web 2.0, blog, online (1), JavaScript, Mozilla, blog, developer, open source, web (1), Debian, Linux, OSM, blog, fosm, geo, mapper, math, politics (1), blog, to read (1), TrickleUp, anonymity, authentication, blog, cookie, privacy (1), database, fiction, interactive (1), Jenkins, blog, java, tech (1), Akonadi, ERD, PostgreSQL, database (1), Bryce, blog, friend (1), Zach, blog, cms (1), TrickleUp, blog, threading (1), database, food, manager, nutrition, recipes, scan (1), advice, blog, parenting (1), blog, client, web (1), USDA, database, nutrition (1), OSM, blog, geo, mapper, math, politics (1), CSS, awesome header, blog, custom (1), Thoughts, TrickleUp, articles, blog (1), blog, maps (1), blog, science (1), TrickleUp, blog, news, structure (1), OSM, Python, changeset, database (1), TrickleUp, blog, trackbacks (1), blog (1), blog, environment (1), Elwing, PowerMac G5, database, fan, normal form, upgrade (1), database, exception handler, number, software, user input (1), DC, GIS, address, database (1), CHART, JpGraph, Xerces, database, graph, scrape, speed, traffic (1), TrickleUp, TrickleUp Effect, blog, poll (1), blog, food, local, wine (1), ERD, database, model (1)

Blogging

Readers may now post comments on articles. You may be wondering why don't i just use some blogging software. "Why reinvent the wheel?"

Well one reason is to exercise my programming abilities. Also, i want a blog that blends seemlessly into the my web site. It can't look like a separate entity in any way. Any blogger i'd use must be fully open source.

WordPress looks interesting, but it uses that pseudo-relational sell-out database MySQL, which doesn't even have support for views, transactions, or foreign-key constraints. PostgreSQL is much better. However when i release my blogging software, it will use ODBC.

Database

Blog entries are now in a database. I've got the hooks for comments. I'll need to create a new table for them. I'll work on that tonight. For now they won't be recursive comments.