Hacker News Reader

I'm writing a lot of little batch programs in my job. Like get those 1M records from db. Process them with an algorithm and write to results to this other table. I think you should write faster with Python. But performance of the processing is also important and LINQ helps a lot with the writing time.

View on HN

That'll of course depend completely on the nature of the things you do with those records you get from the database, but 1M recors don't seem like much (do you join them with something?).

But if LINQ is what you need, well, Python may have a similar or not, depending on how you use it, but there is no reason for you to start writting C# in Python.

This maybe a bit overkill, but you could take a look at ORM layers. Something like http://www.sqlalchemy.org/ instead of playing with SQL directly.

yeah, sqlalchemy core is pretty good _if you really need to build up dynamic queries_. (I haven't used the full up orm).

But if possible, I still just prefer looking at a full sql statement.

Reply on news.ycombinator.com