Welcome
Welcome to <strong>txtSQL</strong>.

You are currently viewing our boards as a guest, which gives you limited access to view most discussions and access our other features. By joining our free community, you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content, and access many other special features. Registration is fast, simple, and absolutely free, so please, <a href="/profile.php?mode=register">join our community today</a>!

"Infinite Complexity"

Track the development of 4.0 from here

"Infinite Complexity"

Postby FarazAli on Sun Jun 03, 2007 11:47 am

Yea, so other "flatfile" competitors out there have claimed to have something they call "infinitely complex" WHERE clauses (having multiple level parenthesis support)...

I just wanted to note that this has been implemented into 4.0 alpha for a while now, and I've recently added support for functions, booleans, constants, and field values...

so for example

WHERE ( round(`id`, `table.roundto`) != 4.10 AND ( strupper(`name`) != strlower('FARAZ' + `lastname`) ) )

I hope you guys get the point... I just don't feel like typing more examples out... I'll do that in the documentation when releasing 4.0

PS - running some quick benchmarks versus some other flatfile packages shows that txtSQL is rather fast ... faster than 2.2 final ... 8)
Latest txtSQL Stable Release: txtSQL 2.2 Final

Track 4.0 Development

Image
FarazAli
Site Admin
 
Posts: 73
Joined: Sun Mar 25, 2007 1:08 pm
Location: New Jersey, NJ

Postby Kenny N on Sat Mar 08, 2008 7:38 pm

Wow. It's pretty impressive that you lead txtSQL this far by your own. Look back 4-5 years ago, I sat in my university's library try to come up with a flat database that accept SQL syntaxes. That was when I came up with txtSQL . The initial codes was pretty premature ( was written in perl ) . I didn't know that you were able to carry on my ideas until these days . :) My efforts didn't go to waste after all . Btw, my name is Kenny Ngo, former developer at Nelogic Technologies .

Ohh few things that might interest you:

1. Relational Database
2. Store binary data

After I saw your project, I decided to write another flat database manipulator to compete with txtSQL's speed :) . So, you should tweak txtSQL to its fastest or you will loose in the competition .
Kenny N
 
Posts: 1
Joined: Sat Mar 08, 2008 7:20 pm

Postby FarazAli on Mon Mar 17, 2008 1:06 pm

Yea I remember you. I remember the email I sent you asking for permission to use the name "txtSQL".

I've carried the project quite a distance, and I plan on adding a whole bunch of new things. But right now time is scarce, as I prepare for MCATs and other issues with school.

As far as your program goes, it would be nice if you were to keep me posted on the developments.
Latest txtSQL Stable Release: txtSQL 2.2 Final

Track 4.0 Development

Image
FarazAli
Site Admin
 
Posts: 73
Joined: Sun Mar 25, 2007 1:08 pm
Location: New Jersey, NJ

Re: "Infinite Complexity"

Postby zzw08 on Tue Jul 14, 2009 5:36 am

http://www.fashion-products.com [url=http://www.fashion-products.com ]is a sell air force one,
air jordan,bape,kicks,nike,Jerseys,Shoes,Clothing,Bag,Glasses,Caps&Hats,sneakers,sunglasses,
watches,Jewelry,Electronics,NBA,NFL,NHL,MLB[/url]
shoes
clothing
Handbags Wallets
Hat
Sunglasses
Belts
Watches
Jewelry
zzw08
 
Posts: 53
Joined: Tue Jul 14, 2009 5:15 am


Return to 4.0 Development

Who is online

Users browsing this forum: No registered users and 0 guests

cron