Welcome to the E-Blah Community!
We would like to welcome you to our community and invite you to register an account or login.
Being a registered member is important, as it gives you several advantages over the normal Guest status. After registering you will be able to download files and images, post messages, and access member-only portions of the forum - just to name a few. Registration is quick and simple, and only takes about a minute of your time.

E-Blah Community    E-Blah SQL Technical Support    General E-Blah SQL  ›  what is sql?
Users Browsing Forum
No Members and 1 Guests

what is sql?  This thread currently has 143 views. Print
1 Pages 1 Recommend Thread
pumpchef
November 5, 2008, 2:06am Report to Moderator Report to Moderator
E-Blah Member
Posts: 21
Posts Per Day: 0.03
Time Online: 4 hours
what is SQL, i'm new to this in a way
Logged Offline
Private Message Private message
BattleMage
November 5, 2008, 2:42am Report to Moderator Report to Moderator
E-Blah Member
Posts: 78
Gender: Male
Posts Per Day: 0.03
Reputation: 100.00%
Reputation Score: +1 / -0
Time Online: 1 days 1 hours 24 minutes
Location: Ammerbuch, Germany
Age: 28
Structured Query Language. It's a syntax to query databases.
Logged Offline
Private Message Private message Reply: 1 - 6
pumpchef
November 5, 2008, 4:02am Report to Moderator Report to Moderator
E-Blah Member
Posts: 21
Posts Per Day: 0.03
Time Online: 4 hours
whats the difference in running eblah's sql vs their regular forum?
Logged Offline
Private Message Private message Reply: 2 - 6
BattleMage
November 5, 2008, 4:28am Report to Moderator Report to Moderator
E-Blah Member
Posts: 78
Gender: Male
Posts Per Day: 0.03
Reputation: 100.00%
Reputation Score: +1 / -0
Time Online: 1 days 1 hours 24 minutes
Location: Ammerbuch, Germany
Age: 28
SQL version requires a database. So you'll have to set up and run a database server. I'm not sure what databases are supportet at this time, I think it's only MySQL.
The regular version is file based so you do not need anything else to run it.
Logged Offline
Private Message Private message Reply: 3 - 6
pumpchef
November 5, 2008, 10:23am Report to Moderator Report to Moderator
E-Blah Member
Posts: 21
Posts Per Day: 0.03
Time Online: 4 hours
oh ok thanks
Logged Offline
Private Message Private message Reply: 4 - 6
vol7ron
November 14, 2008, 8:25am Report to Moderator Report to Moderator
E-Blah Member
Posts: 106
Gender: Male
Posts Per Day: 0.13
Reputation: 100.00%
Reputation Score: +9 / -0
Time Online: 1 days 1 hours 10 minutes
Location: Washington DC
Age: 26
SQL: Structured Query Language
In effect, you can retrieve data from a database using simple calls:
SELECT <fields> FROM <table> WHERE <condition is true>;
DELETE FROM <table> WHERE <condition is true>;
(the WHERE... is not mandatory)

Not only is it a little more secure and easier to pull and edit information, but it also has a performance increase.  Repeated searches can lay in a buffer in memory, which leads to fast retrievals.  It's necessary for common searches and routines.

Therefore, using something like a forum, where we're getting a post trail for a thread, we might do something like:
SELECT postID FROM post_thread_bridge WHERE threadID = 2;

So this will return all the posts from the table for the second thread in the forum.  Then you can join that with another table to get the post information, or maybe another table that has the user information.  The sky's the limit.



Increase vol7ron's Rating
Logged Offline
Private Message Private message Reply: 5 - 6
jamesorlakin
August 6, 2009, 1:50pm Report to Moderator Report to Moderator

E-Blah Member
Posts: 44
Gender: Male
Posts Per Day: 0.12
Time Online: 10 hours 35 minutes
Location: Hampshire, UK
Why change to SQL?
Let's let them develop more features in the original way ( CSS I think it is )


I don't know PERL!
Only Javascript, Visual BASIC, Windows command prompt
Logged Offline
Private Message Private message Reply: 6 - 6
1 Pages 1 Recommend Thread
Print