Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Magmain
The Sweet Roll Cooperative
15
|
Posted - 2016.03.30 20:43:51 -
[1] - Quote
Afternoon all!
I couldnGÇÖt find anything on this when I searched, but IGÇÖm at work and didnGÇÖt really try that hard either. I was wondering if anybody has any experience using MS Access when creating a desktop eve app. The reason for this? I have to make use of access for a class so IGÇÖm just trying to find a way to make it useful to me after the class also.
My experience with access is pretty much nonexistent, and my experience with crest is also very low. IGÇÖve used to old APIs before but that was a few years ago.
I would like to import crest market data and use access as a database for the app to pull from. Is this something that wonGÇÖt take me ages to get going? I can spend a week or so getting it to talk nicely before IGÇÖll start falling behind.
Any thoughts or insight will be appreciated
|
Mr Mac
Dark Goliath
130
|
Posted - 2016.03.30 21:48:12 -
[2] - Quote
Steve has nice codes to pull CREST using VBA with JSON Parser https://www.fuzzwork.co.uk/2014/07/26/excel-and-crest/ http://www.ediy.co.nz/vbjson-json-parser-library-in-vb6-xidc55680.html |
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
5970
|
Posted - 2016.03.31 12:06:22 -
[3] - Quote
VBA is a total pita to use with json.
Depending on what you want to do, you might find it easier to use python to update the database, then use access to do stuff with that loaded data.
I'm running again for CSM 11, and I'd appreciate your vote.
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
Hel O'Ween
Men On A Mission
159
|
Posted - 2016.03.31 16:51:45 -
[4] - Quote
As the (only?) old fart around who still uses VB6 on a regular basis, I once went hunting for JSON libraries when CREST came out, that can be used with VBA. The only working one I've found when doing a few very simple test was http://www.codeproject.com/Articles/720368/VB-JSON-Parser-Improved-Performance. It's based on another project, which is linked in its Github repository.
EVEWalletAware - an offline wallet manager.
|
Tehg Rhind
Atlantic Innovations
12
|
Posted - 2016.03.31 17:24:31 -
[5] - Quote
Last time I tried to work with MS Access and eve it was a huge pain. The problem is that many of the things you'll pull from use different xml scheme than what access is used to. The eve api for instance uses attribute centric xml, and access only works well with element centric (or the other way around). You'll hit similar issues with eve central. Some of these are avoidable by creating linked tables in access and handling the xml in excel tables, since excel is actually fairly competent at handling varied xml forms.
Another option which may or may not be available is to find another program that does all the back end work for you. The only market app I know of which is compatible with Microsoft access is Eve Wallet Aware. Not sure if it's working (tried to install it last night and I couldn't)
Not sure how any of this applies to CREST though. My experience is a bit dated. |
Magmain
The Sweet Roll Cooperative
15
|
Posted - 2016.03.31 18:02:35 -
[6] - Quote
Well, from my own failed tests and the comments here, it appears that Access won't really work for this. Does anybody have a suggestion for a free replacement to access that a person who is not that well versed in databases could get their head around? |
Desmont McCallock
601
|
Posted - 2016.03.31 18:11:45 -
[7] - Quote
Depends on your perspective.
If we are talking about RDBMS, here's my opinion.
If you wonna stick with Microsoft use SQL Server. It's an RDBMS that suites any need. Now that SQL Server is coming to Linux, same way that Linux bash is coming to Windows (only WIndows 10), I can see anyone's investment on SQL Server to pay off.
On the other hand, if you wonna avoid Microsoft, I would recommend Postgre. Sure MySQL is great too but from the 'investment' point of you, I would go with Postgre. |
Magmain
The Sweet Roll Cooperative
15
|
Posted - 2016.03.31 19:51:31 -
[8] - Quote
Desmont McCallock wrote:Depends on your perspective.
If we are talking about RDBMS, here's my opinion.
If you wonna stick with Microsoft use SQL Server. It's an RDBMS that suites any need. Now that SQL Server is coming to Linux, same way that Linux bash is coming to Windows (only WIndows 10), I can see anyone's investment on SQL Server to pay off.
On the other hand, if you wonna avoid Microsoft, I would recommend Postgre. Sure MySQL is great too but from the 'investment' point of you, I would go with Postgre.
I have no qualms with Microsoft really, my job basically revolves around talking them up all day long lol. Now, I've never used SQL server before, so how would you rate the "learning curve" so to speak?
I've looked into MySQL and the free version didn't really do it for me. I'll take a peak at Postgre.
Thanks for the advice!
|
Desmont McCallock
601
|
Posted - 2016.03.31 21:57:35 -
[9] - Quote
Once you know the SQL basics, it all comes down to learning the syntax. T-SQL is preferable for SQL Server. Here you can see a small sample of the syntax differences between different SQL implementations (This is actual code used in the EVESDEtoSQL tool I made).
Here is a search guide on learning SQL. Personally it took me about a month to fully learn T-SQL, but I also had day by day practice at work. |
Steve Ronuken
Fuzzwork Enterprises Vote Steve Ronuken for CSM
5971
|
Posted - 2016.03.31 22:50:10 -
[10] - Quote
the biggest annoyance with postgres is needing to quote mixed case table names.
tbh, they're all pretty capable databases. (mysql being the least capable)
MS SQL has decent tools available (like the management studio). Postgres you'll be digging some more to get them.
Biggest difference for you is probably the amount of data you can store (for free). MS SQL express edition is 10GB. Postgres doesn't have an upper limit built in.
I'm running again for CSM 11, and I'd appreciate your vote.
Fuzzwork Enterprises
Twitter: @fuzzysteve on Twitter
|
|
Dragonaire
Here there be Dragons
80
|
Posted - 2016.04.02 15:24:30 -
[11] - Quote
When learn SQL make sure you learn the standards and not some vendor version it'll pay off more in the end. You can make SQL Server and MySQL both into modes that vary much improve their compatibility to SQL-92 standards. Postgres general follows the standards much closer and doesn't seem to have any options to do better. The advantage of course to using the standard syntax is that then you can switch DBs and at most have to just add or remove a few lines that switch to that mode but everything else is the same or to put it another way no vendor lock Another DB that actual has better then expected standard support is Access. I've been surprised many times how well it does but it still has many other limitations that make it hard to use for anything really complex.
I personally like MySQL or more correctly should say MariaDB as it's an improved version being developed by some of the original team from before MySQL got bought out.
Anyway that's my 2 cent worth.
Finds camping stations from the inside much easier.
Designer of Yapeal for the Eve API.
Check out the Yapeal PHP API Library thread.
|
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |