Which SQL is best to use
Moderator: Rathinagiri
Which SQL is best to use
Dear Friends,
Some time ago, I was following thread on "Which SQL is best to use". This thread appears to be terminated without any conclusion. HMG community is still open on this point which IMHO,is very crucial for future of XBASE. Pl. conclude this issue.
Regards
IC Jindal
Some time ago, I was following thread on "Which SQL is best to use". This thread appears to be terminated without any conclusion. HMG community is still open on this point which IMHO,is very crucial for future of XBASE. Pl. conclude this issue.
Regards
IC Jindal
- Rathinagiri
- Posts: 5471
- Joined: Tue Jul 29, 2008 6:30 pm
- DBs Used: MariaDB, SQLite, SQLCipher and MySQL
- Location: Sivakasi, India
- Contact:
Re: Which SQL is best to use
IMHO, it is open because we can not come to a single conclusion.
Just like other software products, each of them is having its own advantages and disadvantages. Each one may have upper hand on portability, connectivity, security, networking.
With regard to me, I am using MysQL and don't have any problems with that. After that, I use SQLite. I wish I would try PostgreSQL and Firebird soon.
Just like other software products, each of them is having its own advantages and disadvantages. Each one may have upper hand on portability, connectivity, security, networking.
With regard to me, I am using MysQL and don't have any problems with that. After that, I use SQLite. I wish I would try PostgreSQL and Firebird soon.
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
South or North HMG is worth.
...the possibilities are endless.
Re: Which SQL is best to use
Hello IC Jindal,
Very happy to see your post
How are you? ![Smile :)](./images/smilies/icon_e_smile.gif)
I also agree with Rathi. I am adding one point more. As MySql has some licensing problems, I decided to use other DBMS, eg., Sqlite, Pgsql, Firebird etc.
Currrently I am developing an application for a medium sized pharmaceuticals company with HMG300+SQLite![Smile :)](./images/smilies/icon_e_smile.gif)
Again, our good old DBF (especially DBFCDX) has lots of power also.![Smile :)](./images/smilies/icon_e_smile.gif)
It's very hard to say a single DBMS is best. Eg., for a small to medium sized DBMS, one may select SQLite, but for a large DBMS with many online users one may select PostgreSql![Wink ;)](./images/smilies/icon_e_wink.gif)
With best regards.
Sudip
Very happy to see your post
![Very Happy :D](./images/smilies/icon_e_biggrin.gif)
![Smile :)](./images/smilies/icon_e_smile.gif)
I also agree with Rathi. I am adding one point more. As MySql has some licensing problems, I decided to use other DBMS, eg., Sqlite, Pgsql, Firebird etc.
Currrently I am developing an application for a medium sized pharmaceuticals company with HMG300+SQLite
![Smile :)](./images/smilies/icon_e_smile.gif)
Again, our good old DBF (especially DBFCDX) has lots of power also.
![Smile :)](./images/smilies/icon_e_smile.gif)
It's very hard to say a single DBMS is best. Eg., for a small to medium sized DBMS, one may select SQLite, but for a large DBMS with many online users one may select PostgreSql
![Wink ;)](./images/smilies/icon_e_wink.gif)
With best regards.
Sudip
With best regards,
Sudip
Sudip
-
- Posts: 132
- Joined: Thu Jul 31, 2008 12:05 pm
Re: Which SQL is best to use
Yo tambien quisiera empezar a utilizar SQL.
Que les parece si comienzo con Sqlite es mejor para empezar o me recomiendan otro?
Es facil de instalar? de donde lo descargo?
Si tienen algunos ejemplos para ir probando se los agradeceria.
Saludos
Claudio
I also would like to start using SQL.
They think if I start with Sqlite is better to start or recommend me another?
It is easy to install? where I download it?
If you have some examples to get tested ?
Greetings
Claudio
Que les parece si comienzo con Sqlite es mejor para empezar o me recomiendan otro?
Es facil de instalar? de donde lo descargo?
Si tienen algunos ejemplos para ir probando se los agradeceria.
Saludos
Claudio
I also would like to start using SQL.
They think if I start with Sqlite is better to start or recommend me another?
It is easy to install? where I download it?
If you have some examples to get tested ?
Greetings
Claudio
- Rathinagiri
- Posts: 5471
- Joined: Tue Jul 29, 2008 6:30 pm
- DBs Used: MariaDB, SQLite, SQLCipher and MySQL
- Location: Sivakasi, India
- Contact:
Re: Which SQL is best to use
Welcome.I also would like to start using SQL.
Yes. It is fine for single user or small network.They think if I start with Sqlite is better to start or recommend me another?
It is already installed and bundled with HMG 3.0It is easy to install? where I download it?
![Wink ;)](./images/smilies/icon_e_wink.gif)
You can find out working samples in HMG\samples\sqlite folder.If you have some examples to get tested ?
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
South or North HMG is worth.
...the possibilities are endless.
Re: Which SQL is best to use
You may also check at (viewtopic.php?f=15&t=853) with lots of discussion from Master Roberto, Friend Rathi and other experienced friends of this forumclaudiotedesco wrote: If you have some examples to get tested ?
![Smile :)](./images/smilies/icon_e_smile.gif)
With best regards.
Sudip
With best regards,
Sudip
Sudip
-
- Posts: 132
- Joined: Thu Jul 31, 2008 12:05 pm
Re: Which SQL is best to use
Hola Gente
Estuve viendo los ejemplo que estan en la carpeta HMG\samples\sqlite folder.
Lo ejecute sin inconveniente y lo veo muy util.
Pero me resulta un poco complejo entender bien las siguientes lineas, especialmente las que estan marcadas en rojo
function RefreshTable
sample.table.DeleteAllItems()
aTable := sql(dbo,"select * from new where date1 <= "+c2sql(ctod("15-04-2010")))
for i := 1 to len(aTable)
aCurRow := aTable
sample.table.additem({aCurRow[1],str(aCurRow[2]),str(aCurRow[3]),dtoc(aCurRow[4]),iif(aCurRow[5]==1,"True","False"),aCurRow[6]})
next i
if sample.table.itemcount > 0
sample.table.value := 1
endif
sample.table.Refresh
return nil
Les agradeceria si me pueden explicar dicho uso
Saludos
Claudio
Estuve viendo los ejemplo que estan en la carpeta HMG\samples\sqlite folder.
Lo ejecute sin inconveniente y lo veo muy util.
Pero me resulta un poco complejo entender bien las siguientes lineas, especialmente las que estan marcadas en rojo
function RefreshTable
sample.table.DeleteAllItems()
aTable := sql(dbo,"select * from new where date1 <= "+c2sql(ctod("15-04-2010")))
for i := 1 to len(aTable)
aCurRow := aTable
sample.table.additem({aCurRow[1],str(aCurRow[2]),str(aCurRow[3]),dtoc(aCurRow[4]),iif(aCurRow[5]==1,"True","False"),aCurRow[6]})
next i
if sample.table.itemcount > 0
sample.table.value := 1
endif
sample.table.Refresh
return nil
Les agradeceria si me pueden explicar dicho uso
Saludos
Claudio
-
- Posts: 132
- Joined: Thu Jul 31, 2008 12:05 pm
Re: Which SQL is best to use
I was watching the example that HMG are in the folder \ samples \ sqlite folder.
It runs without problem and I see it very useful.
But I find it a bit complex to understand well the following lines, especially those that are marked in red
function RefreshTable
sample.table.DeleteAllItems()
aTable := sql(dbo,"select * from new where date1 <= "+c2sql(ctod("15-04-2010")))
for i := 1 to len(aTable)
aCurRow := aTable
sample.table.additem({aCurRow[1],str(aCurRow[2]),str(aCurRow[3]),dtoc(aCurRow[4]),iif(aCurRow[5]==1,"True","False"),aCurRow[6]})
next i
if sample.table.itemcount > 0
sample.table.value := 1
endif
sample.table.Refresh
return nil
if I can explain this use
Greetings
Claudio
It runs without problem and I see it very useful.
But I find it a bit complex to understand well the following lines, especially those that are marked in red
function RefreshTable
sample.table.DeleteAllItems()
aTable := sql(dbo,"select * from new where date1 <= "+c2sql(ctod("15-04-2010")))
for i := 1 to len(aTable)
aCurRow := aTable
sample.table.additem({aCurRow[1],str(aCurRow[2]),str(aCurRow[3]),dtoc(aCurRow[4]),iif(aCurRow[5]==1,"True","False"),aCurRow[6]})
next i
if sample.table.itemcount > 0
sample.table.value := 1
endif
sample.table.Refresh
return nil
if I can explain this use
Greetings
Claudio
- Rathinagiri
- Posts: 5471
- Joined: Tue Jul 29, 2008 6:30 pm
- DBs Used: MariaDB, SQLite, SQLCipher and MySQL
- Location: Sivakasi, India
- Contact:
Re: Which SQL is best to use
Actually this sql() function is a wrapper function. It returns a two dimensional array of the SQL query record set. It is in Row,Col format.
The red colored code is used to update a HMG grid with the SQL record set.
The red colored code is used to update a HMG grid with the SQL record set.
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
South or North HMG is worth.
...the possibilities are endless.
Re: Which SQL is best to use
Friends,
I wish to opt for PostgreSQL. My all programmes are in Dos/Windows environment. On preliminary reading, I understand that PostgreSQL works best on Linux/ Unix OS. I have Ubuntu as 2nd OS on my laptop, along with Vista. Kindly guide me on this point.
Regards
IC Jindal
I wish to opt for PostgreSQL. My all programmes are in Dos/Windows environment. On preliminary reading, I understand that PostgreSQL works best on Linux/ Unix OS. I have Ubuntu as 2nd OS on my laptop, along with Vista. Kindly guide me on this point.
Regards
IC Jindal