SQLite now supports recursive CTEs
sqlite.org
SQLite now supports recursive CTEs
1–10 of 25 posts
Re: SQLite now supports recursive CTEs
#2I am really happy with this.
I also like the variety of examples they're providing. Granted, the Mandelbrot Set ASCII-Art is not something I'd see myself using, it's pretty cool!
Re: SQLite now supports recursive CTEs
#3This support was added in SQLite 3.8.3 and released in early February
Re: SQLite now supports recursive CTEs
#4This is awesome. Is there an Ubuntu PPA that keeps up with these releases?
Re: SQLite now supports recursive CTEs
#5It is strange that SQLite will get this before MySQL. But good job to the SQLite team!
Re: SQLite now supports recursive CTEs
#6yo .. that sudoko solver SQL and Madelbrot SQL is sick !!!
Re: SQLite now supports recursive CTEs
#7It is strange that SQLite will get this before MySQL. But good job to the SQLite team!
When it comes to SQL standard support my bet is always on SQLite before MySQL (except for any multi user/role stuff, of course).
Re: SQLite now supports recursive CTEs
#8It is strange that SQLite will get this before MySQL. But good job to the SQLite team!
When it comes to SQL standard support my bet is always on SQLite before MySQL (except for any multi user/role stuff, of course).
The other exception I'd note is type-related stuff, since, while MySQL isn't always in line with the standard there, SQLite has deliberately chosen a different course than teh standard when it comes to types.
Re: SQLite now supports recursive CTEs
#9I wrote some code in PostgreSQL to deal with children's deriving properties from parents, etc.
Finally I can have this in :)
Re: SQLite now supports recursive CTEs
#10This is awesome. I've used WITH RECURSIVE in postgres to do graph traversals (even replaced neo4j with postgres), and now this is also available with sqlite. I can see running tests in development becoming a whole lot easier.