161–170 of 273 posts
Earlier quoted context omitted.
I think that there's a rising "Maker" culture that focuses on building first and launching fast. For example: https://www.youtube.com/watch?v=6reLWfFNer0
@levelsio also published a book on the subject recently.
“You might be surprised to learn that in a developer’s life, there aren’t all that many chances to impress girls with your coding skills.” Ha ha. When my wife and I were new she asked to use my laptop and was surprised that it “had no icons”. (No window system). So I started to show her how to avoid using a GUI. 12 years later she uses a terminal about half of her time as a stock administrator.
Textbased internet surfing must be awesome.
working on a daily basis with excel/vba/sql and was intrigued for a moment. Then I wandered into the pricing and was truly surprised. Again, a niche tool that charges as much as the complete jetbrains suite (if you're a subscriber for 3 years).
I've paid, as just one example, $100 for what's 'basically' just of fancy keyboard shortcuts for just one of the tools I use frequently. If the benefits outweigh the costs, then the price is 'just right' (for you).
If you're working with Excel/VBA/SQL daily, then you might already have a nice 'working environment' in terms of the tools and workflow you use. But this still might be better than what you have now. I know I'd rather use C# and SQL than VBA or whatever it is you have to use with the similar recent-ish Excel add-ons.
Every place I have ever worked had that same kind of shitty Excel/Access pile of crap including the manual instructions. It's like people can't understand that if you can write down a procedure for someone to follow you can automate that procedure.
I'd bet a lot of the people you're casually insulting do understand that it could be automated, but, unlike you perhaps, they're more cognizant of the costs of automating it (and ensuring it continues to work).
Processing even slightly messy data can turn out to be a basically unlimited amount of work, easily.
FYI, Google Sheets has limited SQL support via their =QUERY() function: https://support.google.com/docs/answer/3093343?hl=en This has come in handy for me recently, but it's painful to try and edit even a simple SQL query in the cell edit field. However, it's super convenient to have this capability built into the spreadsheet. Marketing idea for QueryStorm: guides that apply your tool for specific data analysis/workf…
Earlier quoted context omitted.
@levelsio also published a book on the subject recently.
Do you happen to know the title of the book?
It's pretty good so far
Cool IDE, cool project. At the same time, it can all be done in Power Pivot and Power Query as long as you know how to use them.
You can use C# and SQL in Power Pivot and Power Query? I couldn't figure out how to do so based on a cursory web search. More generally, you can do all of this same 'stuff' in any language. This seems like a possibly better way to do the same things tho.
Most of your programming should be DAX plus a bit of worksheet functions. Some SQL to filter your data before loading into Power Pivot.
SQL yes, of course. You run SQL queries to load data into Power Pivot through a native SQL Server driver or native drivers for your DB or worst case ODBC.
Then you do all the BI analytics in DAX and show results in pivot tables. DAX is a very fast, concise and very, very powerful language for analytics. This is the whole purpose of OLAP.
Check out this video when you have time :)
Earlier quoted context omitted.
I would argue the you go the lesson slightly wrong. As a technical person you start with your great idea and get it working (not working is not the same as polished!). Then you HIRE someone who is great at marketing to help you figure out where it needs to be polished to sell it. The great marketing person will then do the work go get sales. Note, if you were a marketing person your lesson would be correct: you find…
Having built some very cool things that in the end nobody bought, I strongly disagree that one should just build the thing and then try to sell it. I also disagree that these two approaches lead to evolution vs revolution. Even if you have a revolutionary idea, and even if you can build it, it's still a waste of time if nobody will buy it. No matter how revolutionary your idea, you can try marketing it. If you are ev…
I'm working on a thing now which no one believes is possible in the AI space (and to be honest I didn't either).
So I built a tech demo which proved to myself that it really does work.
Now I do the "I'm doing XXXX", get the cynical "yeah right" look, but the idea is interesting enough that people are prepared to see the 30 second demo.
The demo is pretty cool.
After the demo I've had people ask if they can invest, without me asking, and I think every person I've demoed to thinks they would either buy it or know someone who would.
So I'd caution that not all advice is correct in every situation.
Even if hiding it for mobile seems like a good idea (not the target), someone looking at the website on mobile would acknowledge they can easily download the software later on.
Earlier quoted context omitted.
I've never used Firebird db so far. I have no idea how it differs. I will check it out, and possibly include it. QueryStorm already supports 6-7 different types of databases so one more won't be too difficult to add. Thanks for the tip!
Is it possible to run Window queries on SQLite? I think it's not! Firebird implements quite a few of these statements. I integrated most commercial db vendors and we even ran queries on imported data in a HSQLDB database. Firebird is just way ahead of HSQLDB, and HSQLDB is similar to SQLite feature-wise. I don't mean it would be cool to be able to export to Firebird. I mean that you might want to use Firebird as your…