Xavier Spriet
I'm a software developer currently located in Windsor, Ontario. I'm very interested in discrete math & algos, several programming languages (but I've been specializing in Python and PHP for now), and RDBMS. I'm currently learning about Android development, lisp and fuzzy graphs.Follow Me
Blogroll
Tags
Categories
- Events (1)
- tech (8)
- Computer Science (1)
- Databases (2)
- Django (1)
- linux (5)
- Programming (2)
- unix (4)
- Web Development (1)
- Web Frameworks (1)
Archives
Category Archives: Databases
Extending PostgreSQL with Python
One of the features I enjoy the most about PostgreSQL is the ability to write stored procedures in C, Perl, TCL, PgSQL, and yes… obviously also in Python. I’ve been using this feature since 7.4, so any recent version of … Continue reading
Fixing custom sequences in PostgreSQL
PostgreSQL provides a mechanism called sequences, which I believe is extracted from ANSI-SQL92, though I’m too lazy to check, which are basically stateful counters that provide some helper functions. The primary use of sequences in PostgreSQL and Oracle, is to … Continue reading
on Delicious
on Google Books
on HackerNews
on LinkedIn
on Twitter