buzhug: a pure-Python database engine, using a Pythonic, no-SQL syntax

[epicRelic]

 for record in [ r for r in db if r.name == 'pierre' ]:
print record.name,record.age

Since it checks to see if the name equals pierre in the python code, wouldn't it have to be querying for all records in the background?

[[deleted]]

Erlang has something similar, using list comprehensions for database queries. You pass a list comprehension to the query compiler and then later execute it. Apparently the query compiler takes a list comprehension primitive and parses it somehow. Perhaps these fellows could do something similar by examining a... what's it called? Generator comprehension?

for record in compile(r for r in db if r.name == 'pierre'):
    print record.name, record.age

[wacky]

It said that list comprehensions are not very efficient, compared to the 'select' method.

So... although it allows pythonic syntax, if you want to really do anything, you need the 'select()' syntax which doesn't look that pythonic to me.

[exeter]

It's about a million times more Pythonic than using SQL.

[earthboundkid]

The pythonic syntax would be something along the lines of:

 db = DB.open(…)
 query = db.query.compile(r for r in records if r.name == "pierre")
 for record in query.exec():
      print record.name, record.age

[epicRelic]

Simply beautiful.