Leaderboard

The other day mikeytown2 posted one post in HTTP UDF's thread that got me thinking if there is better (different) method to send requests through the HTTP protocol to HTTP servers. There is Winhttp.dll that ships with windows and that is its main purpose. I couldn't find any examples of using this dll in AutoIt, so I came up with this. Microsoft about Windows HTTP Services: Microsoft Windows HTTP Services (WinHTTP) provides developers with an HTTP client application programming interface (API) to send requests through the HTTP protocol to other HTTP servers... .. blah, blah, and so on... This is an example of getting page header: #include "WinHttp.au3" Opt("MustDeclareVars", 1) ; Open needed handles Local $hOpen = _WinHttpOpen() Local $hConnect = _WinHttpConnect($hOpen, "msdn.microsoft.com") ; Specify the reguest: Local $hRequest = _WinHttpOpenRequest($hConnect, Default, "en-us/library/aa384101(VS.85).aspx") ; Send request _WinHttpSendRequest($hRequest) ; Wait for the response _WinHttpReceiveResponse($hRequest) Local $sHeader = _WinHttpQueryHeaders($hRequest) ; ...get full header ; Clean _WinHttpCloseHandle($hRequest) _WinHttpCloseHandle($hConnect) _WinHttpCloseHandle($hOpen) ; Display retrieved header MsgBox(0, "Header", $sHeader)Everything you need to be able to use this UDF can be found at WinHttp site. Remember, basic understanding of the HTTP protocol is important to use this interface. ProgAndy, trancexx WinHttp.au3 is completely free and no one has right to charge you for it. That's very important. If you feel WinHttp.au3 was helpful to you and you wish to support my further work you can donate to my personal account via PayPal address: trancexx at yahoo dot com I will appreciate that very much. Thank you in advance! :kiss:

I'm very happy with the couple {Mathematica, SQLite}. Yes I know: while SQLite is powerful and free, Mathematica is fantastic but not exactly cheap. I particularly appreciate its language and the uncompared possibilities it offers to manipulate and represent data. Yet if you're serious about modelling real-world data and behavior, you should consider investing in a serious tool.

Excel will become unresponsive, freeze and crash the bigger your data size becomes. Autoit has natively embedded functions to deal with SQLite databases, you can look it up in its helpfile. You can also find examples in the forum and around. This might be good enough for your personal use. In the long run if more people could work on your data as well you may want to switch to a regular database system like MySQL or MariaDB but they require a server to run on. But it's hard to tell precisely not knowing what data you're working on, from which sources and to what end

I use AutoIt mainly in the context of (heavily numerical) scientific research, and frankly, I wouldn't touch Excel with a bargepole, for a number of reasons. Firstly, it imposes highly restrictive limits on the size and shape of data sets. Secondly, although internally, it uses 15-digit precision in calculations (binary double precision), once a workbook is saved, all accuracy beyond four decimal places is lost; plus, errors due to premature rounding are common, and difficult to trace. Furthermore, the provided statistics are weak, and graphs are low-res and more suitable for a business powerpoint presentation than scientific publication. The problem is that it tries/claims to be a jack of all trades, so it ends up doing most things poorly. I grant you that worksheet editing is quick and intuitive, so it's perfect for accounting and taxes and such like. But when I make data edits I need to be able to keep a track record, so I keep separate AutoIt scripts that perform explicit data preprocessing for me (plus a personal worklog text file to keep track of what I did when, and which script produces what (type of) output). Of course I don't know what kind of modelling you do, or what your data sets actually look like. But if they can get large (>2GB), or if numerical accuracy or statistical significance is important, I wouldn't rely on an MS-Office tool to do science with. I'd say use a fast matrix/mathematical environment for computing with large datasets (I use Eigen, which is free (AutoIt wrapper library here, a dedicated statistics package for EDA and testing (I use Minitab (not free, but intuitive) and SAS (not at all intuitive), free version here), and a graphics package that allows you to control dpi for publishable figures (I mainly use gmt, also free; but may not be suited to your purpose).