HNHacker News
TopNewBestAskShowJobs

george_ciobanu

220 karma · joined December 6, 2010

submissionscomments
george_ciobanu··on Visual language for data (no-code SQL for non-tech ppl)
Author here: Only supported DB as a data source is Postgres.

Note 1: to create account enter your email and press Login/Signup. It will create a new account if it does not exist

Note 2: Ignore the "Cannot connect to datasource" error message

Note 3: When you create a datasource, the tool connects to the DB and downloads the schema.

Note 4: There is a bug in Top10, don't use it.

Note 5: you can see the generated SQL in the console if you want to

This is a tool I built to extract data from relational databases more easily, and I think/hope non-tech people will appreciate it. I know the UX needs a lot of love but I am happy with the overall process of asking a question and getting the answer.

The FAQ section is not updated from the template I used :-)

george_ciobanu··on Primer: Statistical Armour
Super helpful and well documented article, thank you!
george_ciobanu··on Show HN: Datagridxl2.js – Fast Excel-like data table library
Wonderful work! If you think your table is the best, as someone who is pondering buying it, you'd save me some time if you had a quick comparison matrix with your main competitors. It seems counterintuitive to provide that but most people will do the research anyway so you're just saving them some time searching and cataloguing alternatives.
george_ciobanu··on Ask HN: What concepts have you never truly understood?
Thank you both, that was super helpful
george_ciobanu··on Ask HN: What concepts have you never truly understood?
Eigenvalues. I can do the math for them but don't quite understand what their intuitive meaning is - if any.
george_ciobanu··on Ask HN: What concepts have you never truly understood?
This is a great explanation. As someone who's a relatively recent convert to FP and am currently writing both imperative and functional code I will test my own depth of knowledge by trying to explain it

1. In traditional (imperative) languages you can have functions that deliberately or accidentally either modify the data they were given or do some other stuff that changes data somewhere else in your program or the computer. Let's take an example of each. Say you have a function that adds two numbers a and b. In imperative languages you could return a+b into b. In other words the sum(a,b) operation would change b. That's not cool in FP: you are (almost never) allowed to change the input you received. This way whenever the function is called with a and b it always returns the sum (otherwise if you call sum(a,b) again you will pass in a modified b).

This makes every function guaranteed to always return the same value for the same arguments. If you accidentally try to change a parameter in your code it will fail.

But you still need to make changes to the world - you do so by chaining these functions and using the output from one as input to the next and so on.

Last but not least, functions that have side effects (e.g. print to the screen) are marked differently and usually their effect is isolated.

george_ciobanu··on Ask HN: What concepts have you never truly understood?
This is my take on it: when you start something it's at first easy and then it gets really hard. Or boring. Or you get distracted or disenchanted. But if you stick with it long enough you eventually become an expert in the space (or what you are building becomes good enough) that it's not state of the art. And then you can innovate on it or sell it or sell your skills. But you have to get through that tough valley in the middle.
george_ciobanu··on Ask HN: Should I give up and get a job?
Many people get startup ideas came by working at a company and noticing a gap in tooling, a super manual process or an error prone one or something that is hard to use effectively. Taking a job can be a path to your dream, be it by finding ideas or by funding your future build time, or by growing your list of connections etc. You can come back to the same idea later or come up with better ones. Some dreams take a while to accomplish, you have to try hard and not give up. The steps to get there are not the same for everyone. Some start early others learn a lot from their corporate experience.

And yes, if you want to be a founder and don't think your own ideas are commercialisable, either partner with someone who has them (and find the ones you both like) or get really good at understanding what the job of each product around us is - practice the methods in https://www.fullstory.com/blog/clayton-christensen-jobs-to-b... on a daily basis and soon you will see lots of gaps in the market. Some of them might be narrow but very valuable, few will be wide enough to make a small business of, and very very few will yield multi-million dollar companies. Why do you have your own software company? Is it because you love independence or you think you'll enjoy being a founder or just a technical founder? No bad answers here it's just important to understand what drives this dream of yours. Then it gets easier to find the right path to your ultimate goal.

george_ciobanu··on Tell HN: My fingers are frustrated that my laptop does not autocomplete text
Makes sense
george_ciobanu··on A viable solution for Python concurrency
Free Dask cluster available to use at tcp://3.216.44.221:8786

tldr: you can use our 4-computer Dask cluster (including two GPUs, a GTX 1080Ti and a Radeon 6900XT) at no cost. If you need even more computing power, message me (george AT lindenhoney DOT com).

FAQ

What is Dask? Dask is a Python framework for distributed computing, designed to enable data scientists to process large amounts of data and huge computations on a scale from 1 to thousands of computers.

How do I use the cluster you created? Install Dask (python -m pip install "dask[complete]" from dask.distributed import Client client = Client(tcp://3.216.44.221:8786) Use it! https://examples.dask.org

Do I need to sign up? No. You can literally just use it as above from any Python script or notebook.

Why are you making it available? I’m looking to better understand how people use Dask and how to best make it available to data scientists as an easy to use service.

What can I use the cluster for? Anything you want such as data science, web crawling (except spam, porn, illegal activities or DoS) etc. Please be nice.

Can I hack your cluster? Probably not. But ff you find any security issues please let us know instead and we will fix them.

What’s the catch? Do you track my usage? None. These are my gaming/closet computers that I just want people to use. I do track anonymous function calls people make and the total volume of data that passes through the system (bandwidth, disk usage, RAM usage etc) but I do not look at or save any of your data.

How can I add my own worker machines to the cluster? Easy - set up Dask worker(s) and point them to tcp://3.216.44.221:8786

How about security and confidentiality? These are computers I have at home so all you have is my promise that I won’t look/save/copy your data or code. Pinky swear. However, it is possible for other unfriendly users to look at your data if you save it, even temporarily, on the disk, since all Dask tasks run under the same user.

Who are you? https://www.linkedin.com/in/georgeciobanunyc

What if someone else who uses the cluster messes up with my data, copies it or otherwise takes it down? Use your best judgement. I hardened the cluster’s security to the best of my ability but I can’t guarantee that someone else won’t mess with them. If you work for the NSA/a bank/IRS/etc you should definitely not upload sensitive data to these computers.

I need more GPUs or a bigger (hundreds or thousands of computers) cluster! Glad to help, just email me (see above).

I need a larger cluster but private (using AWS, Azure, GCP) Same as above, email me and I can help.

What are the computer specs? Two of them are AMD processors with 8 physical cores each, the other is a quad core Intel and the last one is a Mac (Intel, 4 cores). The dedicated graphics cards (GPUs) are on the AMD computers.

george_ciobanu··on No laughing matter? what the Romans found funny
Haha I also had a different interpretation, that his kids are very likely to die in order to support the astrologer's prediction. Too dark?
george_ciobanu··on French Appeal Court affirms decision that copyright claims on GPL are invalid
https://en.m.wikipedia.org/wiki/Vernor_v._Autodesk,_Inc.

Has some intersection with this case

george_ciobanu··on Show HN: Minimal versioned log structured relational DB in Common Lisp
Check out Datomic
george_ciobanu··on [Ask HN] From days to minutes by using Dask and Spark–what else should I learn?
Thank you so much!
george_ciobanu··on Ask HN: Who wants to be hired? (November 2020)
Location: Greater NYC area Remote: yes Willing to relocate: no Technologies: Resume: https://www.dropbox.com/s/3cqatqshaqck3fq/george%20ciobanu%2... LinkedIn: https://www.linkedin.com/in/georgeciobanunyc/ Email: geo [dot] ciobanu [at] gmail.com

Product Manager / Product Owner with experience at both startups (no-code, behavior change, online video, online collaboration for industrial designers / mechanical engineers ) and Google (legal compliance, global infrastructure).

Degree in Computer Engineering, internet as SWE at Microsoft, Google, Facebook.

george_ciobanu··on On Trouser Pockets
So where to order? Sign me up please.
george_ciobanu··on Representing Graphs by Knuth Trees (1974) [pdf]
check out Datomic and Datalog.
george_ciobanu··on Grumpy Website – a blog about everything wrong with modern web & tech
It's not stupidity it can be lack of knowledge, could be a day when you are tired and forget or you clumsily opened both at once.

Thinking about people as stupid, as a designer, is suboptimal and miguided in my opinion.

george_ciobanu··on The 40% Keyboard
Check out KeyMouse, super cool concept.
george_ciobanu··on Ask HN: Whats the best book on your favorite programming language or topic?
Check out Programming pearls by Jon Bentley. Reads like a novel, teaches phenomenal foundations.
george_ciobanu··on Decisions, Decisions or Why Baskets of Options Dominate
There is an underlying assumption that a basket of features = sum(individual features). That is true sometimes, but other times a bunch of features launched together have a compound aggregate value - they're much more valuable launched together than individually.

But for cases where that's not true this is an excellent insight.

The part I didn't understand was the P50. Why do you get a demerit if you do 100% of everything, and how is discovering and solving an objective discovered along the way encouraged? I would love if the author or someone else explained it to me. Overall a great article.

Bit of advice: I'd mention early in the article and/or the title that this will apply to product thinking. I was curious about the financial part and pleasantly discovered that it uses this learning in product development - though way far down the page, I almost didn't finish reading it.

george_ciobanu··on Disney Is Placing Classic Fox Movies into Its Vault
I used to live in a studio (high ceilings) in Chelsea, Manhattan. I paid 500 for a projector and you can use almost any speaker. You can get a good one for 500 these days. So the whole cost is 1000. The speaker need not be very loud and one empty wall (or a white screen) is all you need. The image was amazing and the size huge. The projector was in my bookcase, on one of the shelves. Sometimes I'd get lazy and use the projector speakers and it was fine.

The projector-wall distance was no more than 5m. A short throw projector can work with even less distance.

So absolutely doable in a small space.

I'm never going back to a regular TV.

george_ciobanu··on Yes, Estimate Software Projects
No better way to learn than by trial and error. If your team is reasonable they will point out why something is easier or harder than you thought. And that's part of learning so you shouldn't feel bad about it. Would you be upset at a child learning a second language or an instrument? No, that's why they are learning because they don't know. The worst thing you can do is not try to estimate. Just make sure to do your homework, whatever that means for your projects: look at existing code, try to do a detailed breakdown that shows why you think it takes this long, read API docs etc.
george_ciobanu··on Algebra, Topology, Differential Calculus, and Optimization Theory for CS and ML [pdf]
Check out Wolfram Alpha
george_ciobanu··on Algebra, Topology, Differential Calculus, and Optimization Theory for CS and ML [pdf]
I went to high school in Romania and first two years of college as well. We did tons of theory on about 2/3 (if not 3/4) of the material here (I also covered some of it when I continued my college in Montreal, Canada). But that took about 6 years of daily (maybe there was a day in the week when we didn't do math) study. And I'm sure we didn't cover it in the same depth as they do here (for most things we did a lot of proofs and theory). So it's possible but it takes a lot of time. In addition, it was usually motivated by the next step: you need to learn how to compute the inverse matrix in order to further process it with more complex algorithms which you actually use in labs or some sort of application (even if it's made up).

The interesting thing is that, for a Math student (or a college professor) this is the FOUNDATION of math you need in order to study advanced stuff. For some of the recent math proofs (think famous ones) you'd need to study a whole year (after you know most of this stuff) just to learn the theory foundations for that proof.

I'm of course exaggerating a bit - most Math majors would probably go through most of the stuff in this PDF but not necessarily all (machine learning stuff for example, and possibly numerical analysis stuff) of it. And if they do they usually forget* most of it, except the areas they use in their daily research (assuming they got for an advanced degree). And when you use some of this stuff every day it becomes second nature after a certain point.

My experience is mostly based on the Romanian educational system which is typically more hardcore science (Math and Physics) even for Computer Engineering degrees.

*Sometimes you don't forget stuff, you just don't think about it until you see it again (concrete example for me: Schur decomposition) and then partial memories of it come back.

george_ciobanu··on Ask HN: What are you learning in 2019?
Clojure, Hoplon web framework and Datomic.
george_ciobanu··on Palmerston Island, Population 35
Just one photo?
george_ciobanu··on A Year Ago I Put Saltwater in a Jar [video]
Don't lock the kids in a jar! :D
george_ciobanu··on Things that helped me move into engineering management
Also check out the book: Managing Humans: Biting and Humorous Tales of a Software Engineering Manager
george_ciobanu··on “Be yourself” is terrible advice
My version of it: don't be yourself, work towards being the best person you can be.
← PreviousPage 2 of 5Next →