| View previous topic :: View next topic |
| Author |
Message |
BaldieJr
Joined: 02 Jul 2004 Posts: 23
|
Posted: Mon Sep 13, 2004 12:55 am Post subject: SQLite :) |
|
|
Would be an awesome addition, especially with all the neat GUI additions.
http://www.sqlite.org/ |
|
| Back to top |
|
 |
BaldieJr
Joined: 02 Jul 2004 Posts: 23
|
Posted: Mon Sep 13, 2004 1:10 am Post subject: |
|
|
Oh, and sockets would also be kick-@@@  |
|
| Back to top |
|
 |
Chris Site Admin
Joined: 02 Mar 2004 Posts: 10471
|
Posted: Mon Sep 13, 2004 1:14 am Post subject: |
|
|
That looks pretty interesting. I must admit it would really super-charge data storage and retrieval to have a mini SQL engine (much more powerful than INI files or even the registry).
However, I worry about the cost/benefit. Not many users know SQL, and even if they did they wouldn't be likely to need it for most typical automation tasks. Still, I'll add it to the list to research some more. Perhaps it can be added as an optional external module or something.
Thanks.
| Quote: | | Oh, and sockets would also be kick-@@@ | Socket is kind of vague -- what kind of sockets? |
|
| Back to top |
|
 |
BoBo Guest
|
Posted: Mon Sep 13, 2004 3:21 pm Post subject: |
|
|
Here we go:
| Quote: | Many times I've wished for a simple way to run SQL queries from a batch file, or have a commandline-based SQL query tool, so AnalogX SQLCMD was born!
AnalogX SQLCMD is pretty simple, it just allows you to specify a database, username and password (if necessary) and a SQL query you wish to perform. The results are either output to the screen, or alternatively output into a log file that you specify. Very simple to use but if you've needed the functionality in the past, you know how handy it can be.
Please Note: This program is a commandline application. |
[more...]
 |
|
| Back to top |
|
 |
BoBo Guest
|
Posted: Mon Sep 13, 2004 3:30 pm Post subject: |
|
|
Quiet SQL v2.0 - SQL AnyWhere Runtime ISQL Replacement
[Download] (61 K)
 |
|
| Back to top |
|
 |
Chris Site Admin
Joined: 02 Mar 2004 Posts: 10471
|
Posted: Mon Sep 13, 2004 3:51 pm Post subject: |
|
|
| I'm sure others will probably check out these links, so thanks for posting them. |
|
| Back to top |
|
 |
BoBo Guest
|
Posted: Wed Sep 15, 2004 9:41 pm Post subject: |
|
|
| Quote: | SQL Query Generator (Open Source)
The SQL Query Generator is a command line program that will help you with making INSERT INTO , UPDATE, and DELETE queries. The entire source is (to the best of my knowlege) ANSI C compliant, so it should compile on any system. When using this program, you will need a CREATE TABLE query stored as plain text in a file(example). The reason you need this file is because SQL Query Generator reads this file to get the column names for creating queries. |
[more...]
 |
|
| Back to top |
|
 |
Atomhrt
Joined: 02 Sep 2004 Posts: 128 Location: Sunnyvale
|
Posted: Thu Sep 16, 2004 12:06 am Post subject: |
|
|
| Chris wrote: | That looks pretty interesting. I must admit it would really super-charge data storage and retrieval to have a mini SQL engine (much more powerful than INI files or even the registry).
However, I worry about the cost/benefit. Not many users know SQL, and even if they did they wouldn't be likely to need it for most typical automation tasks. |
I was thinking the other day that I wished for an alternative way, as opposed to INI files, to store the results of the new GUI's. A DB would be good for that. I do not think end-users would need to know any SQL, you could just add commands to AHK. For example:
DB, add, string, tag-name
DB, update, new-string, tag-name
DB, delete, tag-name
| Quote: | | Oh, and sockets would also be kick-@@@ |
| Quote: | | Socket is kind of vague -- what kind of sockets? |
TCP sockets for sending messages? _________________ I am he of whom he speaks! |
|
| Back to top |
|
 |
Chris Site Admin
Joined: 02 Mar 2004 Posts: 10471
|
Posted: Thu Sep 16, 2004 12:58 am Post subject: |
|
|
| Thanks for the ideas. |
|
| Back to top |
|
 |
jack
Joined: 04 Sep 2004 Posts: 77 Location: UK
|
Posted: Thu Sep 16, 2004 5:47 pm Post subject: |
|
|
| Quote: | I was thinking the other day that I wished for an alternative way, as opposed to INI files, to store the results of the new GUI's. A DB would be good for that. I do not think end-users would need to know any SQL, you could just add commands to AHK. For example:
DB, add, string, tag-name
DB, update, new-string, tag-name
DB, delete, tag-name |
gui4cli uses the registry in a similar manner. you can do, for example:
RegSet USER:mykey myval "some text" CREATE
that USER: means that the value will be under HKEY_CURRENT_USER\Software\Gui4Cli\
jack |
|
| Back to top |
|
 |
BoBo Guest
|
Posted: Thu Sep 16, 2004 7:20 pm Post subject: |
|
|
| Quote: | | TCP sockets for sending messages? |
Any request on implementing AHK features to connect to "outer space" are (IMHO) a l'ill suspicious. AHK Spam booster ? AHK virus accelerator ??
Yep, I'm paranoid - flaming me is a waste of time  |
|
| Back to top |
|
 |
Chris Site Admin
Joined: 02 Mar 2004 Posts: 10471
|
Posted: Thu Sep 16, 2004 7:24 pm Post subject: |
|
|
| It's a valid concern; thanks for the reminder. |
|
| Back to top |
|
 |
Atomhrt
Joined: 02 Sep 2004 Posts: 128 Location: Sunnyvale
|
Posted: Fri Sep 17, 2004 1:19 am Post subject: |
|
|
| BoBo wrote: | | Quote: | | TCP sockets for sending messages? |
Any request on implementing AHK features to connect to "outer space" are (IMHO) a l'ill suspicious. AHK Spam booster ? AHK virus accelerator ??
Yep, I'm paranoid - flaming me is a waste of time  |
Or chat, perhaps between two or more people, or one person and a computer.
I wrote a socket client that ran from the command line so that I could include it in various sections of remote tasks that I would execute from my desk. It would send me progress reports, etc, that I could watch with my "listening server" gui. _________________ I am he of whom he speaks! |
|
| Back to top |
|
 |
Atomhrt
Joined: 02 Sep 2004 Posts: 128 Location: Sunnyvale
|
Posted: Fri Sep 17, 2004 1:22 am Post subject: |
|
|
| jack wrote: | | Quote: | I was thinking the other day that I wished for an alternative way, as opposed to INI files, to store the results of the new GUI's. A DB would be good for that. I do not think end-users would need to know any SQL, you could just add commands to AHK. For example:
DB, add, string, tag-name
DB, update, new-string, tag-name
DB, delete, tag-name |
gui4cli uses the registry in a similar manner. you can do, for example:
RegSet USER:mykey myval "some text" CREATE
that USER: means that the value will be under HKEY_CURRENT_USER\Software\Gui4Cli\
jack |
Thanks Jack. I not a big fan of using the registry. I always try to avoid it. _________________ I am he of whom he speaks! |
|
| Back to top |
|
 |
jack
Joined: 04 Sep 2004 Posts: 77 Location: UK
|
Posted: Fri Sep 17, 2004 5:59 am Post subject: |
|
|
| Atomhrt wrote: |
Thanks Jack. I not a big fan of using the registry. I always try to avoid it. |
hmm. i take the view that odd bits of rubbish, such as the last thing i selected in some gui, are just what the registry should be used for! |
|
| Back to top |
|
 |
|