Content Tagged "db"

TL;DR : My windows service wasn't installed properly. Change the config file to point the DB to an accessible directory and reinstall the service. When trying to build a perioduc Celery task, I got the following error with Redis on Windows (running as a windows service): redis.exceptions…

TL;DR: Use a JOIN . I've got a table representing a tree, using two columns: and I want to select all children for parents whose CLASS_ID have a certain value (e.g. abcd ). The way I could do it was via a JOIN statement: This will: Perform a join where child.parent_prop_id = parent.prop_id…

The other day I've been confronted with a strange situation: I forgot the admin password for a django application. I was playing with installing my own pypi repository, I've configured and deployed a test application and, after a couple of weeks, I forgot the password. I tried several times bu I…

The other day I got a question: How to add a numeric PK column to an already existent table? A quick look on the net showed that it is indeed possible to add an auto-incrementing PK to an already existing table ( if you don't have already a PK that is! ). The code is quite simple too! The statement…

Following the previous incursions in Oracle and their own documentation, we decided it was useful to attach schemas to the inserted data, just because only XML with schemas attached can be indexed. When you have some million entries, indexing seems like a good idea (once you decide what to index…

I've upgraded my MacPro's hardware a bit the other day and I've noticed that something went bye-bye when running eclipse . Namely eclipse itself wasn't working anymore. So I thought: What a great opportunity to do an update (eclipse, jdk...). And MacPorts . Because I wanted to upgrade my python to…