AutoHotkey Homepage AutoHotkey Community
Let's help each other out
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

SQLite :)
Goto page 1, 2  Next
 
Post new topic   Reply to topic    AutoHotkey Community Forum Index -> Wish List
View previous topic :: View next topic  
Author Message
BaldieJr



Joined: 02 Jul 2004
Posts: 23

PostPosted: Mon Sep 13, 2004 12:55 am    Post subject: SQLite :) Reply with quote

Would be an awesome addition, especially with all the neat GUI additions.

http://www.sqlite.org/
Back to top
View user's profile Send private message
BaldieJr



Joined: 02 Jul 2004
Posts: 23

PostPosted: Mon Sep 13, 2004 1:10 am    Post subject: Reply with quote

Oh, and sockets would also be kick-@@@ Very Happy
Back to top
View user's profile Send private message
Chris
Site Admin


Joined: 02 Mar 2004
Posts: 10471

PostPosted: Mon Sep 13, 2004 1:14 am    Post subject: Reply with quote

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
View user's profile Send private message Send e-mail
BoBo
Guest





PostPosted: Mon Sep 13, 2004 3:21 pm    Post subject: Reply with quote

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...]
Cool
Back to top
BoBo
Guest





PostPosted: Mon Sep 13, 2004 3:30 pm    Post subject: Reply with quote

Quiet SQL v2.0 - SQL AnyWhere Runtime ISQL Replacement

[Download] (61 K)

Cool
Back to top
Chris
Site Admin


Joined: 02 Mar 2004
Posts: 10471

PostPosted: Mon Sep 13, 2004 3:51 pm    Post subject: Reply with quote

I'm sure others will probably check out these links, so thanks for posting them.
Back to top
View user's profile Send private message Send e-mail
BoBo
Guest





PostPosted: Wed Sep 15, 2004 9:41 pm    Post subject: Reply with quote

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...]

Cool
Back to top
Atomhrt



Joined: 02 Sep 2004
Posts: 128
Location: Sunnyvale

PostPosted: Thu Sep 16, 2004 12:06 am    Post subject: Reply with quote

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
View user's profile Send private message
Chris
Site Admin


Joined: 02 Mar 2004
Posts: 10471

PostPosted: Thu Sep 16, 2004 12:58 am    Post subject: Reply with quote

Thanks for the ideas.
Back to top
View user's profile Send private message Send e-mail
jack



Joined: 04 Sep 2004
Posts: 77
Location: UK

PostPosted: Thu Sep 16, 2004 5:47 pm    Post subject: Reply with quote

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
View user's profile Send private message
BoBo
Guest





PostPosted: Thu Sep 16, 2004 7:20 pm    Post subject: Reply with quote

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 ??

Rolling Eyes

Yep, I'm paranoid - flaming me is a waste of time Cool
Back to top
Chris
Site Admin


Joined: 02 Mar 2004
Posts: 10471

PostPosted: Thu Sep 16, 2004 7:24 pm    Post subject: Reply with quote

It's a valid concern; thanks for the reminder.
Back to top
View user's profile Send private message Send e-mail
Atomhrt



Joined: 02 Sep 2004
Posts: 128
Location: Sunnyvale

PostPosted: Fri Sep 17, 2004 1:19 am    Post subject: Reply with quote

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 ??

Rolling Eyes

Yep, I'm paranoid - flaming me is a waste of time Cool


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
View user's profile Send private message
Atomhrt



Joined: 02 Sep 2004
Posts: 128
Location: Sunnyvale

PostPosted: Fri Sep 17, 2004 1:22 am    Post subject: Reply with quote

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
View user's profile Send private message
jack



Joined: 04 Sep 2004
Posts: 77
Location: UK

PostPosted: Fri Sep 17, 2004 5:59 am    Post subject: Reply with quote

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
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    AutoHotkey Community Forum Index -> Wish List All times are GMT
Goto page 1, 2  Next
Page 1 of 2

 
Jump to:  
You can post new topics in this forum
You can reply to topics in this forum


Powered by phpBB © 2001, 2005 phpBB Group