9 ms·

Show HN: Ananas – a hackable data tool for beginners

359 points by millboh 7y ago

overcast 7y ago
My unprofessional professional opinion. The product looks great, but the name has to go. I can't imagine pronouncing that, let alone communicating it over a phone. Any simple word before analytics would be better. Edit: pineapplytics is the obvious cute and available one, however may still be difficult to communicate.
- henrikschroder 7y ago
  Fun fact: Only the English language calls the fruit "pineapple", almost every other language calls it "ananas" or similar.
  - overcast 7y ago
    I looked it up, I get it, but this post and the site, are targeting English speaking.
    - ygjb 7y ago
      Now I really want the author to rename it pineapple in the English localization, and leave it Ananas every where else...
    - _frkl 7y ago
      Well, or they just want everyone to be able to access it? There is really no choice than to publish something like this in English. Just a guess, but I'd guess the amount of people ccessing it who are not native English speakers is larger than those who are.
  - pmelendez 7y ago
    That's a bit bold statement... In Spanish is Piña and in Portuguese is Abacaxi, but a good amount of laguanges does call it ananas
    - caiocaiocaio 7y ago
      In Portugal Portuguese it's Ananás.
      - michaelmior 7y ago
        I think this is also true in the Spanish dialects spoken in many regions.
    - maximente 7y ago
      > In Spanish is Piña equally as bold, and also incorrect: ananá is what you'll hear in Argentina, possibly elsewhere.
      - deleted 7y ago
        [deleted]
  - pimterry 7y ago
    The Guardian made a helpful infographic a little while back about exactly this: https://static.guim.co.uk/sys-images/Guardian/Pix/pictures/2013/11/13/1384357483102/Pineapple.png https://static.guim.co.uk/sys-images/Guardian/Pix/pictures/2...
  - mikorym 7y ago
    That's not true. In my native language it is called "pynappel". EDIT: I guess that may be why you said "almost" but that, in turn, is almost impossible.
  - hondadriver 7y ago
    We call pineapple juice 'ananassap' in Dutch and sometimes use it as if it would be an English word as a joke.
  - techie128 7y ago
    Its called "ananas" in Marathi as well. Marathi is a regional language in India.
- millboh 7y ago
  Delighted that this is one of the first comments! :) The product was designed to make analytics easy. We found that the word Analytics is not easy to pronounce too. So we decided to make the word analytics easy too! But thanks for your comments, we will consider about it.
  - koolba 7y ago
    I think the name and logo are nice (pineapple database right?) but agree that it's both difficult to spell and pronounce (particularly for people who refer to them as "pineapples"). If you want to be cheeky, CONCAT(SUBSTR('analyst', 1, 4), 'desktop') is available for a .com domain.
    - bhou 7y ago
      Love this CONCAT(SUBSTR('analyst', 1, 4), 'desktop') idea! ;)
- dugluak 7y ago
  People have same opinion about Azure. Microsoft didn't change it. Ananas is still not that bad.
  - tlrobinson 7y ago
    "Ananas" alone might not be that bad, but "ananasanalytics.com" certainly is. Bob Loblaw's Law Blog, anyone?
- caiocaiocaio 7y ago
  I really loved the name, but there was a bit of disconnect because I thought something named pineapple would lead me to a more exciting, artsy page.
- aiisjustanif 7y ago
  Who said it was made by an English speaker...? Typical. Smh.
  - dang 7y ago
    I appreciate the push for tolerance behind your comment, but being snide doesn't help. Please don't on HN. https://news.ycombinator.com/newsguidelines.html https://news.ycombinator.com/newsguidelines.html Edit: while I have you, could you please also stop posting unsubstantive comments to HN generally? You've done that a fair bit and we're trying for something a little better than that here. In addition to the site guidelines, you might also find these links helpful for getting the spirit of the site: https://news.ycombinator.com/newswelcome.html https://news.ycombinator.com/newswelcome.html https://news.ycombinator.com/hackernews.html https://news.ycombinator.com/hackernews.html http://www.paulgraham.com/trolls.html http://www.paulgraham.com/trolls.html http://www.paulgraham.com/hackernews.html http://www.paulgraham.com/hackernews.html
- djmips 7y ago
  your opinion is bananas
tracer4201 7y ago
No Redshift support? Hmmm.
- bhou 7y ago
  It is on our roadmap! We will continue adding more data sources in the following release.
kfk 7y ago
This looks good. One of your competitors charges about $4,000 per seat per year so this seems to be a good space. If you add the possibility of building user defined nodes with Python you’d have a solid product.
- bhou 7y ago
  We will release a user-defined function with Javascript in next release. Python is on the roadmap too.
  - kfk 7y ago
    Will you have a server too? Another issue is scheduling, triggers, etc.. You are in this strange space between Excel and “enterprise” ETL like Talend. We are so frustrated with the current poor state of data prep that we went to Python based workflows with the idea of scheduling, triggering, via Airflow. Seems to work well so far. But your IDE for data prep is a bit better positioned than what we use now (Jupyter).
    - millboh 7y ago
      Actually, we provide a command-line interface, you can do pretty much everything the UI does with command-line. And you can also run it in server mode with command-line. In the current version, we haven't covered scheduling yet. A possible solution would be scheduling through Airflow BashOperator in airflow. Or we can implement scheduling solution into the server itself.
- justaguyhere 7y ago
  woah, that is steep. who is this competitor?
  - alienreborn 7y ago
    Probably Informatica or Talend which are two of the most popular Enterprise ETL tools.
  - 7y ago
thoughtpalette 7y ago
Looks great to me. Nice job shipping!
- millboh 7y ago
  Thanks
Jazgot 7y ago
Is the name inspired by Orange [1]? [1] https://orange.biolab.si https://orange.biolab.si
jugg1es 7y ago
Does this have any sort of hinting for indexed queries at all? I would worry that a beginner would create a horrid mess of queries that could consume all available resources.
- millboh 7y ago
  That's a good point. Actually we think of this tool as a collaboration tool which enables non technical users and data engineers to share this visual DAG and work together. The Apache Beam runners we use behind the scene have a Query planner to optimize chained queries . However you're totally right . This can't help a non technical users to write messy queries. The visual DAG should however helps them to split a complex query into simpler ones.
robtherobber 7y ago
I can't download it: https://github.com/ananas-analytics/ananas-desktop https://github.com/ananas-analytics/ananas-desktop , I get a Github server error. Is it just me? Edit: not just me, Github issues.
- notduncansmith 7y ago
  Looks like GitHub is experiencing errors, just had the same problem with an unrelated repo.
  - robtherobber 7y ago
    Thanks!
    - millboh 7y ago
      Yep we expected anything but Github issue ;)
lucasverra 7y ago
Can we hook this to an api GET request ? I guess i could API -> download JSON -> Ananas, but you know..:)
- millboh 7y ago
  The API data source is a great idea! You can create a feature request on our github. (Otherwise we will create it ) We will try to put that into following releases.
- cr0sh 7y ago
  I was thinking the same thing, for like IoT monitoring sensors, etc - but it is open source; grab it (once GH is back online), add the new "source", and issue a PR - that'd be the way to do it I think...
eli_gottlieb 7y ago
Ok, but why did you name it after pineapples?
- millboh 7y ago
  Ananas, Analytics made easy :) Pineapple was cool too. Will probably change it if we see more comments ;)
  - SysINT 7y ago
    Pomme-stylo-anana or name it after Pikotaro!
  - hondadriver 7y ago
    No just keep it. Its fun and why has the name to be an existing English word? Fun fact: if everybody starts using it, it will eventually become proper English.
dewey 7y ago
Pretty similar to https://github.com/getredash/redash https://github.com/getredash/redash from a first look. What would you say are the main differences?
- millboh 7y ago
  It seems that Redash is a BI tool and close source. Ananas is open source, and can be used not only as a BI tool, but also an ETL tool. More over, you can run your pipeline on your own infrastructure, as Ananas can be run on multiple execution engines
  - codetrotter 7y ago
    Parent commenter linked to their GitHub repo. Redash is open source under the terms of the two-clause BSD license. (Maybe they edited to add link, maybe you overlooked it?)
    - millboh 7y ago
      Oh, sorry about that, my bad. I just looked through redash home page, but didn't find the open source link
      - dewey 7y ago
        The Github link is in the footer of the site, but the icon is very small.
      - djmips 7y ago
        redash source <- search
        deleted 7y ago
        [deleted]
- kfk 7y ago
  Redash is comparable to Superset, Tableau, etc.. Ananas analytics is comparable to Talend, Airflow, etc.
najarvg 7y ago
This looks very good and a fit for my end users who deal with excel files all the time. Is there any plans to add Excel as a datasource? Cannot convert to CSV without major pain since excel files are exports from mainframe apps which are out of my control. Thanks
- millboh 7y ago
  Excel source was one of our first supported data sources. See our early video demo: https://www.youtube.com/watch?v=GwqZlhmei78 https://www.youtube.com/watch?v=GwqZlhmei78. We just created an issue on GitHub: https://github.com/ananas-analytics/ananas-desktop/issues/60 https://github.com/ananas-analytics/ananas-desktop/issues/60 We will add this feature back in the following release.
nishkalkashyap 7y ago
I would recommend code-signing the build before distributing.
- millboh 7y ago
  Thanks for your feedback, we will look for some affordable code-signing certificates. Any suggestions? By the way, here is the issue link: https://github.com/ananas-analytics/ananas-desktop/issues/61 https://github.com/ananas-analytics/ananas-desktop/issues/61
  - pimterry 7y ago
    I set up code signing for an electron app relatively recently. Best option I could find was Digicert. Really sucks that this stuff is necessary nowadays and not free, but it's not so bad. That's for Windows - for Mac you'll also need an Apple developer account, afaik they're the only people who can issue certs. EDIT: Woah, I take that back. Digicert has now gone up from $74/year to $474/year, which is crazy. I now also need a new certificate provider...
    - NewsAware 7y ago
      For Electron signing we use Tucows Code signing certs (you need to register as Tucows auther for free) which are provided by Comodo for $140 for 2 years. Didn't have any issues besides getting a proper CI/CD process running.
    - justinclift 7y ago
      There aren't any great options, but if it helps we (sqlitebrowser.org) went with Certum: https://en.sklep.certum.pl/data-safety/code-signing-certificates.html https://en.sklep.certum.pl/data-safety/code-signing-certific... We chose the "Open Source Code Signing" option, with it being stored on a physical keyfob thing (eg not "in the cloud"). Total cost, including the new key fob and super expensive, week+ delay, mandatory postage (!) was around 135 Euro.
    - nishkalkashyap 7y ago
chrsstrm 7y ago
At what scale has this been tested? As in, are you aware of any data file size limits? I have a csv with ~6M rows and when paging through the docs the "Exploring your data source" gave me pause thinking this app might try and open all 6M rows at once. Will I be OK importing such a large source or will my computer turn into a space heater before refusing to respond?
- bhou 7y ago
  Ananas has been tested on production processing terabyte data on a daily basis (with Google Dataflow, but you can achieve the same thing with your own spark cluster too). In term of exploring large source file, the design principle is to paginate any kind of data that support random access records (for example CSV, logs, etc). So when "exploring the data" of a CSV with 6M rows, Ananas will not load 6M rows at once, but read a few rows at a time for each page. For example, in this early demo video, exploring a 755M CSV file in seconds. https://www.youtube.com/watch?v=GwqZlhmei78&t=01m00s https://www.youtube.com/watch?v=GwqZlhmei78&t=01m00s
jbverschoor 7y ago
The app icon is transparent on mac, and thereforce only clickable on the border
jbverschoor 7y ago
Unfortunately it's created by an unientified developer
- jessaustin 7y ago
  Be sure and write some special firewall rules before running this...
yazan94 7y ago
This looks really cool! Thanks for sharing, I can't wait to test this
canada_dry 7y ago
An older, but very slick tool for wrangling data: http://vis.stanford.edu/wrangler/ http://vis.stanford.edu/wrangler/ Which is now a commercial tool: https://www.trifacta.com/products/wrangler-editions/#wrangler https://www.trifacta.com/products/wrangler-editions/#wrangle...
mingabunga 7y ago
Thought about adding some words to the data output using natural language generation? Eg arria.com or other nlg vendor?
- millboh 7y ago
  Excellent idea. We've though about Machine learning transformer including NLP . This NLG is something which would definitively nice to have. Please create an issue and we will prioritize it.
mtarnovan 7y ago
This looks a bit like https://metabase.com https://metabase.com -- anyone used both and can make a comparison?
- mjirv 7y ago
  Metabase is much more for data visualization. As far as I know it doesn't really have any ETL features. I could actually see this being pretty useful as an ETL layer to go along with Metabase if someone were trying to build a free/open source BI stack.
- wiremine 7y ago
  Curious if anyone has used Metabase for serious work and can comment on it. I tried setting it up and got frustrated pretty quickly with the UX. It looks slick, but the mental model was confusing...
  - btown 7y ago
    My startup seriously evaluated Metabase, but inevitably you'll want joins, and Metabase is fundamentally opposed to the idea: https://metabase.com/blog/Joins/ https://metabase.com/blog/Joins/ ... and if you're writing SQL for your views, you might as well be writing SQL. We ended up shelling out for Tableau - it's pricey at $840/yr, but it supports joins out of the box (it even has a drag-and-drop interface to set up joins!), has practically every bell and whistle you could ask for, and allows you to do "exploratory analysis over screenshare in realtime with non-technical colleagues, without context switching to a coding mindset or needing to look up field names you may never have used before." I think it's intuitive and worth every penny, but YMMV. Would recommend everyone try the public version to get a feel for it. EDIT: as others have said, Ananas is actually ETL + BI, whereas Metabase and Tableau are BI on top of a database. Tableau can stand in for good ETL due to its join support in certain scenarios. It's better than Metabase, but not necessarily comparable to Ananas.
    - getsauce 7y ago
      Metabase added joins to query builder in a recent release: https://github.com/metabase/metabase/releases/tag/v0.33.0-preview https://github.com/metabase/metabase/releases/tag/v0.33.0-pr...
dlphn___xyz 7y ago
what advantages does this have over the ELK stack?
richk449 7y ago
Can I use this if all I have is an odbc connection?
- millboh 7y ago
  What kind of data source exactly do you need? We should be able to add Microsoft datasource such as MSSQL if you request it.
- rmbeard 7y ago
  I have the opposite issue is there a way to connect to a cloud database without an ODBC connection?
sails 7y ago
This is great. Things to keep on your radar: Meltano spun out of Gitlab is working in this domain, I think they are making progress. https://meltano.com/ https://meltano.com/ dbt are building the transformation engine that Meltano is using (I think), and are worth keeping an eye on https://www.getdbt.com/ https://www.getdbt.com/ In my experience the issue with this domain isn't the "one-off" analysis, but rather orchestrating the BI function across the business, maintaining the single source of truth, testing and deploying across the ETL/ELT layers. I can't speak to how well Ananas is managing these but Meltano and dbt are giving this area a lot of thought.
mtw 7y ago
This looks great as a promise - I looked into visualizations provided, and we need much more than what's provided though
VvR-Ox 7y ago
Oh nice - thank you very much! :-D I thought about writing my own app for exactly that task but when I see yours I think I don't need to do that anymore. Awesome! :-)
pplonski86 7y ago
What is your business model?
mrtweetyhack 7y ago
Orange does this https://github.com/biolab/orange3 https://github.com/biolab/orange3
programbreeding 7y ago
Just FYI, about 1/3 of the way down your Getting Started page[0] it has a broken link[1] to the fifa2019.csv file. The first link on the page is valid[2], but the second one leads to a 404 due to pointing to .../raw/... rather than .../blob/... [0] https://ananasanalytics.com/docs/user-guide/getting-started https://ananasanalytics.com/docs/user-guide/getting-started [1] https://github.com/ananas-analytics/ananas-examples/raw/master/FifaPlayer2019/fifa2019.csv https://github.com/ananas-analytics/ananas-examples/raw/mast... [2] https://github.com/ananas-analytics/ananas-examples/blob/master/Fifa2019/fifa2019.csv https://github.com/ananas-analytics/ananas-examples/blob/mas...
- bhou 7y ago
  Thanks for the reminder, the links are fixed now.
towlinson 7y ago
What about bananas?
nishkalkashyap 7y ago
I would recommend distributing binaries from a dedicated release server combined with a CDN. Possibly digital ocean spaces. It really increases download speeds for end user as compared to gitHub releases.

359 points by millboh 7y ago

My unprofessional professional opinion. The product looks great, but the name has to go. I can't imagine pronouncing that, let alone communicating it over a phone. Any simple word before analytics would be better. Edit: pineapplytics is the obvious cute and available one, however may still be difficult to communicate.

henrikschroder 7y ago
Fun fact: Only the English language calls the fruit "pineapple", almost every other language calls it "ananas" or similar.
- overcast 7y ago
  I looked it up, I get it, but this post and the site, are targeting English speaking.
  - ygjb 7y ago
    Now I really want the author to rename it pineapple in the English localization, and leave it Ananas every where else...
  - _frkl 7y ago
    Well, or they just want everyone to be able to access it? There is really no choice than to publish something like this in English. Just a guess, but I'd guess the amount of people ccessing it who are not native English speakers is larger than those who are.
- pmelendez 7y ago
  That's a bit bold statement... In Spanish is Piña and in Portuguese is Abacaxi, but a good amount of laguanges does call it ananas
  - caiocaiocaio 7y ago
    In Portugal Portuguese it's Ananás.
    - michaelmior 7y ago
      I think this is also true in the Spanish dialects spoken in many regions.
  - maximente 7y ago
    > In Spanish is Piña equally as bold, and also incorrect: ananá is what you'll hear in Argentina, possibly elsewhere.
    - deleted 7y ago
      [deleted]
- pimterry 7y ago
  The Guardian made a helpful infographic a little while back about exactly this: https://static.guim.co.uk/sys-images/Guardian/Pix/pictures/2013/11/13/1384357483102/Pineapple.png https://static.guim.co.uk/sys-images/Guardian/Pix/pictures/2...
- mikorym 7y ago
  That's not true. In my native language it is called "pynappel". EDIT: I guess that may be why you said "almost" but that, in turn, is almost impossible.
- hondadriver 7y ago
  We call pineapple juice 'ananassap' in Dutch and sometimes use it as if it would be an English word as a joke.
- techie128 7y ago
  Its called "ananas" in Marathi as well. Marathi is a regional language in India.
millboh 7y ago
Delighted that this is one of the first comments! :) The product was designed to make analytics easy. We found that the word Analytics is not easy to pronounce too. So we decided to make the word analytics easy too! But thanks for your comments, we will consider about it.
- koolba 7y ago
  I think the name and logo are nice (pineapple database right?) but agree that it's both difficult to spell and pronounce (particularly for people who refer to them as "pineapples"). If you want to be cheeky, CONCAT(SUBSTR('analyst', 1, 4), 'desktop') is available for a .com domain.
  - bhou 7y ago
    Love this CONCAT(SUBSTR('analyst', 1, 4), 'desktop') idea! ;)
dugluak 7y ago
People have same opinion about Azure. Microsoft didn't change it. Ananas is still not that bad.
- tlrobinson 7y ago
  "Ananas" alone might not be that bad, but "ananasanalytics.com" certainly is. Bob Loblaw's Law Blog, anyone?
caiocaiocaio 7y ago
I really loved the name, but there was a bit of disconnect because I thought something named pineapple would lead me to a more exciting, artsy page.
aiisjustanif 7y ago
Who said it was made by an English speaker...? Typical. Smh.
- dang 7y ago
  I appreciate the push for tolerance behind your comment, but being snide doesn't help. Please don't on HN. https://news.ycombinator.com/newsguidelines.html https://news.ycombinator.com/newsguidelines.html Edit: while I have you, could you please also stop posting unsubstantive comments to HN generally? You've done that a fair bit and we're trying for something a little better than that here. In addition to the site guidelines, you might also find these links helpful for getting the spirit of the site: https://news.ycombinator.com/newswelcome.html https://news.ycombinator.com/newswelcome.html https://news.ycombinator.com/hackernews.html https://news.ycombinator.com/hackernews.html http://www.paulgraham.com/trolls.html http://www.paulgraham.com/trolls.html http://www.paulgraham.com/hackernews.html http://www.paulgraham.com/hackernews.html
djmips 7y ago
your opinion is bananas

tracer4201 7y ago

No Redshift support? Hmmm.

bhou 7y ago
It is on our roadmap! We will continue adding more data sources in the following release.

kfk 7y ago

This looks good. One of your competitors charges about $4,000 per seat per year so this seems to be a good space. If you add the possibility of building user defined nodes with Python you’d have a solid product.

bhou 7y ago
We will release a user-defined function with Javascript in next release. Python is on the roadmap too.
- kfk 7y ago
  Will you have a server too? Another issue is scheduling, triggers, etc.. You are in this strange space between Excel and “enterprise” ETL like Talend. We are so frustrated with the current poor state of data prep that we went to Python based workflows with the idea of scheduling, triggering, via Airflow. Seems to work well so far. But your IDE for data prep is a bit better positioned than what we use now (Jupyter).
  - millboh 7y ago
    Actually, we provide a command-line interface, you can do pretty much everything the UI does with command-line. And you can also run it in server mode with command-line. In the current version, we haven't covered scheduling yet. A possible solution would be scheduling through Airflow BashOperator in airflow. Or we can implement scheduling solution into the server itself.
justaguyhere 7y ago
woah, that is steep. who is this competitor?
- alienreborn 7y ago
  Probably Informatica or Talend which are two of the most popular Enterprise ETL tools.
- 7y ago

thoughtpalette 7y ago

Looks great to me. Nice job shipping!

millboh 7y ago
Thanks

Jazgot 7y ago

Is the name inspired by Orange [1]? [1] https://orange.biolab.si https://orange.biolab.si

jugg1es 7y ago

Does this have any sort of hinting for indexed queries at all? I would worry that a beginner would create a horrid mess of queries that could consume all available resources.

millboh 7y ago
That's a good point. Actually we think of this tool as a collaboration tool which enables non technical users and data engineers to share this visual DAG and work together. The Apache Beam runners we use behind the scene have a Query planner to optimize chained queries . However you're totally right . This can't help a non technical users to write messy queries. The visual DAG should however helps them to split a complex query into simpler ones.

robtherobber 7y ago

I can't download it: https://github.com/ananas-analytics/ananas-desktop https://github.com/ananas-analytics/ananas-desktop , I get a Github server error. Is it just me? Edit: not just me, Github issues.

notduncansmith 7y ago
Looks like GitHub is experiencing errors, just had the same problem with an unrelated repo.
- robtherobber 7y ago
  Thanks!
  - millboh 7y ago
    Yep we expected anything but Github issue ;)

lucasverra 7y ago

Can we hook this to an api GET request ? I guess i could API -> download JSON -> Ananas, but you know..:)

millboh 7y ago
The API data source is a great idea! You can create a feature request on our github. (Otherwise we will create it ) We will try to put that into following releases.
cr0sh 7y ago
I was thinking the same thing, for like IoT monitoring sensors, etc - but it is open source; grab it (once GH is back online), add the new "source", and issue a PR - that'd be the way to do it I think...

eli_gottlieb 7y ago

Ok, but why did you name it after pineapples?

millboh 7y ago
Ananas, Analytics made easy :) Pineapple was cool too. Will probably change it if we see more comments ;)
- SysINT 7y ago
  Pomme-stylo-anana or name it after Pikotaro!
- hondadriver 7y ago
  No just keep it. Its fun and why has the name to be an existing English word? Fun fact: if everybody starts using it, it will eventually become proper English.

dewey 7y ago

Pretty similar to https://github.com/getredash/redash https://github.com/getredash/redash from a first look. What would you say are the main differences?

millboh 7y ago
It seems that Redash is a BI tool and close source. Ananas is open source, and can be used not only as a BI tool, but also an ETL tool. More over, you can run your pipeline on your own infrastructure, as Ananas can be run on multiple execution engines
- codetrotter 7y ago
  Parent commenter linked to their GitHub repo. Redash is open source under the terms of the two-clause BSD license. (Maybe they edited to add link, maybe you overlooked it?)
  - millboh 7y ago
    Oh, sorry about that, my bad. I just looked through redash home page, but didn't find the open source link
    - dewey 7y ago
      The Github link is in the footer of the site, but the icon is very small.
    - djmips 7y ago
      redash source <- search
      - deleted 7y ago
        [deleted]
kfk 7y ago
Redash is comparable to Superset, Tableau, etc.. Ananas analytics is comparable to Talend, Airflow, etc.

najarvg 7y ago

This looks very good and a fit for my end users who deal with excel files all the time. Is there any plans to add Excel as a datasource? Cannot convert to CSV without major pain since excel files are exports from mainframe apps which are out of my control. Thanks

millboh 7y ago
Excel source was one of our first supported data sources. See our early video demo: https://www.youtube.com/watch?v=GwqZlhmei78 https://www.youtube.com/watch?v=GwqZlhmei78. We just created an issue on GitHub: https://github.com/ananas-analytics/ananas-desktop/issues/60 https://github.com/ananas-analytics/ananas-desktop/issues/60 We will add this feature back in the following release.

nishkalkashyap 7y ago

I would recommend code-signing the build before distributing.

millboh 7y ago
Thanks for your feedback, we will look for some affordable code-signing certificates. Any suggestions? By the way, here is the issue link: https://github.com/ananas-analytics/ananas-desktop/issues/61 https://github.com/ananas-analytics/ananas-desktop/issues/61
- pimterry 7y ago
  I set up code signing for an electron app relatively recently. Best option I could find was Digicert. Really sucks that this stuff is necessary nowadays and not free, but it's not so bad. That's for Windows - for Mac you'll also need an Apple developer account, afaik they're the only people who can issue certs. EDIT: Woah, I take that back. Digicert has now gone up from $74/year to $474/year, which is crazy. I now also need a new certificate provider...
  - NewsAware 7y ago
    For Electron signing we use Tucows Code signing certs (you need to register as Tucows auther for free) which are provided by Comodo for $140 for 2 years. Didn't have any issues besides getting a proper CI/CD process running.
  - justinclift 7y ago
    There aren't any great options, but if it helps we (sqlitebrowser.org) went with Certum: https://en.sklep.certum.pl/data-safety/code-signing-certificates.html https://en.sklep.certum.pl/data-safety/code-signing-certific... We chose the "Open Source Code Signing" option, with it being stored on a physical keyfob thing (eg not "in the cloud"). Total cost, including the new key fob and super expensive, week+ delay, mandatory postage (!) was around 135 Euro.
  - nishkalkashyap 7y ago

chrsstrm 7y ago

At what scale has this been tested? As in, are you aware of any data file size limits? I have a csv with ~6M rows and when paging through the docs the "Exploring your data source" gave me pause thinking this app might try and open all 6M rows at once. Will I be OK importing such a large source or will my computer turn into a space heater before refusing to respond?

bhou 7y ago
Ananas has been tested on production processing terabyte data on a daily basis (with Google Dataflow, but you can achieve the same thing with your own spark cluster too). In term of exploring large source file, the design principle is to paginate any kind of data that support random access records (for example CSV, logs, etc). So when "exploring the data" of a CSV with 6M rows, Ananas will not load 6M rows at once, but read a few rows at a time for each page. For example, in this early demo video, exploring a 755M CSV file in seconds. https://www.youtube.com/watch?v=GwqZlhmei78&t=01m00s https://www.youtube.com/watch?v=GwqZlhmei78&t=01m00s

jbverschoor 7y ago

The app icon is transparent on mac, and thereforce only clickable on the border

jbverschoor 7y ago

Unfortunately it's created by an unientified developer

jessaustin 7y ago
Be sure and write some special firewall rules before running this...

yazan94 7y ago

This looks really cool! Thanks for sharing, I can't wait to test this

canada_dry 7y ago

An older, but very slick tool for wrangling data: http://vis.stanford.edu/wrangler/ http://vis.stanford.edu/wrangler/ Which is now a commercial tool: https://www.trifacta.com/products/wrangler-editions/#wrangler https://www.trifacta.com/products/wrangler-editions/#wrangle...

mingabunga 7y ago

Thought about adding some words to the data output using natural language generation? Eg arria.com or other nlg vendor?

millboh 7y ago
Excellent idea. We've though about Machine learning transformer including NLP . This NLG is something which would definitively nice to have. Please create an issue and we will prioritize it.

mtarnovan 7y ago

This looks a bit like https://metabase.com https://metabase.com -- anyone used both and can make a comparison?

mjirv 7y ago
Metabase is much more for data visualization. As far as I know it doesn't really have any ETL features. I could actually see this being pretty useful as an ETL layer to go along with Metabase if someone were trying to build a free/open source BI stack.
wiremine 7y ago
Curious if anyone has used Metabase for serious work and can comment on it. I tried setting it up and got frustrated pretty quickly with the UX. It looks slick, but the mental model was confusing...
- btown 7y ago
  My startup seriously evaluated Metabase, but inevitably you'll want joins, and Metabase is fundamentally opposed to the idea: https://metabase.com/blog/Joins/ https://metabase.com/blog/Joins/ ... and if you're writing SQL for your views, you might as well be writing SQL. We ended up shelling out for Tableau - it's pricey at $840/yr, but it supports joins out of the box (it even has a drag-and-drop interface to set up joins!), has practically every bell and whistle you could ask for, and allows you to do "exploratory analysis over screenshare in realtime with non-technical colleagues, without context switching to a coding mindset or needing to look up field names you may never have used before." I think it's intuitive and worth every penny, but YMMV. Would recommend everyone try the public version to get a feel for it. EDIT: as others have said, Ananas is actually ETL + BI, whereas Metabase and Tableau are BI on top of a database. Tableau can stand in for good ETL due to its join support in certain scenarios. It's better than Metabase, but not necessarily comparable to Ananas.
  - getsauce 7y ago
    Metabase added joins to query builder in a recent release: https://github.com/metabase/metabase/releases/tag/v0.33.0-preview https://github.com/metabase/metabase/releases/tag/v0.33.0-pr...

dlphn___xyz 7y ago

what advantages does this have over the ELK stack?

richk449 7y ago

Can I use this if all I have is an odbc connection?

millboh 7y ago
What kind of data source exactly do you need? We should be able to add Microsoft datasource such as MSSQL if you request it.
rmbeard 7y ago
I have the opposite issue is there a way to connect to a cloud database without an ODBC connection?

sails 7y ago

This is great. Things to keep on your radar: Meltano spun out of Gitlab is working in this domain, I think they are making progress. https://meltano.com/ https://meltano.com/ dbt are building the transformation engine that Meltano is using (I think), and are worth keeping an eye on https://www.getdbt.com/ https://www.getdbt.com/ In my experience the issue with this domain isn't the "one-off" analysis, but rather orchestrating the BI function across the business, maintaining the single source of truth, testing and deploying across the ETL/ELT layers. I can't speak to how well Ananas is managing these but Meltano and dbt are giving this area a lot of thought.

mtw 7y ago

This looks great as a promise - I looked into visualizations provided, and we need much more than what's provided though

VvR-Ox 7y ago

Oh nice - thank you very much! :-D I thought about writing my own app for exactly that task but when I see yours I think I don't need to do that anymore. Awesome! :-)

pplonski86 7y ago

What is your business model?

mrtweetyhack 7y ago

Orange does this https://github.com/biolab/orange3 https://github.com/biolab/orange3

programbreeding 7y ago

Just FYI, about 1/3 of the way down your Getting Started page[0] it has a broken link[1] to the fifa2019.csv file. The first link on the page is valid[2], but the second one leads to a 404 due to pointing to .../raw/... rather than .../blob/... [0] https://ananasanalytics.com/docs/user-guide/getting-started https://ananasanalytics.com/docs/user-guide/getting-started [1] https://github.com/ananas-analytics/ananas-examples/raw/master/FifaPlayer2019/fifa2019.csv https://github.com/ananas-analytics/ananas-examples/raw/mast... [2] https://github.com/ananas-analytics/ananas-examples/blob/master/Fifa2019/fifa2019.csv https://github.com/ananas-analytics/ananas-examples/blob/mas...

bhou 7y ago
Thanks for the reminder, the links are fixed now.

towlinson 7y ago

What about bananas?

nishkalkashyap 7y ago

I would recommend distributing binaries from a dedicated release server combined with a CDN. Possibly digital ocean spaces. It really increases download speeds for end user as compared to gitHub releases.