HNHacker News
TopNewBestAskShowJobs

xq3000

33 karma · joined January 20, 2012

submissionscomments
xq3000··on Show HN: See how much your AI knows about you
550, with a few duplicates
xq3000··on Show HN: ScopeQL, a new query language based on relational algebra
Could this also be implemented as an ORM DSL to interface traditional SQL databases?
xq3000··on Screencasting.com – Learn how to create high-quality screencasts
Yes, the price seems to be way too high.

Sure, it’s nicely produced and marketed but maybe it is over-produced for its value proposition?

xq3000··on Tyler Cowen: If you're so smart, why aren't you rich?
http://archive.today/wgSM6
xq3000··on Help me evaluate the app code from a contractor in India
Hey.. So happens that I’ve been doing a very similar work for the past few months. I can take a look and help you define what “commercial-grade” design and code should look like.
xq3000··on Where to find UI/UX designers for startups?
Youtube has a bunch of simple and free UX and UI courses.

You might also want to search more specifically for information architecture, designing website navigation, picking a color scheme, basics of web fonts, designing forms, and UX user research.

xq3000··on Ask HN: Where/How to find a marketer for personal projects as a software dev?
I guess I could offer a few thoughts here, as I’ve been thinking about this for a while.

You say it’s for personal projects but if you care about marketing then I’m going to guess the projects are serious/ambitious enough.

In that case, as you build them, you’d probably first need to do some “marketing strategy” early on, then naming and branding, then some growth marketing/product design, then see how you would incorporate different types of analytics into the projects, then finally there would be a launch and running some campaigns and using the analytics methodically.

I’d say anything less than that would not really be any kind of methodical marketing. But people do get lucky with word of mouth sometimes.

So, basically, you could probably use a good amount of modern marketing skills.

The internet is, of course, full of options but it’s hard to filter through them.

Based on my watching this space for about 10 years, most of the one-person shops and small teams that do SEO and Wordpress websites will know very little about those things you’d need.

Maybe 1% of medium and large firms out there will work with that stuff in SaaS space but then they would likely be way too expensive for personal projects.

Which leaves you with two options IMHO, 1) to learn that stuff yourself (the path I took), or 2) to find a marketing/product/growth cofounder/advisor/consultant that has experiences in that niche, such as SaaS, for example.

Good luck

xq3000··on Ask HN: How would you create a new better Internet?
A better compression algorithm with middle-out
xq3000··on What’s it like to take a $249 drug-free psychedelic trip?
http://archive.today/7s39v
xq3000··on Why the scary, funny, profane ‘FAFO’ was 2022’s word of the year
http://archive.today/1lDFH
xq3000··on Ask HN: How do you set up a system to track customer's usage in AWS?
You could try posting this question on the official AWS forum https://repost.aws/
xq3000··on Git as backend
I think there are already some Git SDKs out there. For example https://github.com/go-git/go-git
xq3000··on Ask HN: Alternatives to Google Drive?
I wonder how many people would love to see you outsource a bunch of terraform/bash/dockerfile scripts for it
xq3000··on Ask HN: What are some of the best non-technical talks of all time?
To me, “Acres of Diamonds” is one of those.

https://www.temple.edu/about/history-traditions/acres-diamon...

xq3000··on “Swift is the only language I could find with over 100 keywords”
Smalltalk80 wins with only 6 keywords https://en.wikipedia.org/wiki/Smalltalk
xq3000··on Published my first proper product after working as a developer for 10 years
+1. In the US it’s either a quote or an estimate.

Which really depends on the industry and the business owner so the word you use should be configurable per account.

Similar to how different businesses use different words such as customer, client, patient, guest, patron, etc.

xq3000··on Show HN: A platform for the longest-lasting products in the world
So, here is a crazy thought:

This basically looks like a list with votes and comments.

Why not pivot it into a generic service for creating such lists?

xq3000··on Market Segmentation Can Accelerate Growth for Your SaaS Startup
“This video is private.”
xq3000··on GB Studio v1.2 Released
+10
xq3000··on Ask HN: Do You Email Yourself?
Haha, I remember those times when I would do that to save cool links for later. Good times. :)

Then, they made Pocket [1].

The real question is what comes after Pocket?

[1] https://getpocket.com/

xq3000··on Ask HN: 120M rows Postgres – how can I speed up queries?
By index encoding I just mean putting “encoded” values into the indexed column of your table. Something like this: “city:department:sku”.

This technique is a bit advanced, borrowed from hierarchical databases, and optimizes for specific queries known upfront, so it’s cool but not very flexible. There is a lot more to making it work. You can watch [1], if interested.

But I’d also +1 other suggestions here on fine tuning your db engine and just scaling up the server.

[1] https://youtu.be/jzeKPKpucS0

Disclaimer: I’m with AWS.

xq3000··on Chautauqua
Pretty cool! I live 20 min from one of them in Boulder, CO.

The speech “Acres of Diamonds” was also delivered there https://en.wikipedia.org/wiki/Russell_Conwell

xq3000··on Ask HN: 120M rows Postgres – how can I speed up queries?
There is not a lot of specific details here but have you already tried and exhausted things like analyzing execution plans, index optimizations, index encoding, value encoding, denormalization, read replicas, and [front] caching?
xq3000··on Ask HN: Entire API and DB generator from model definition
I just meant something with a lower level of programming than business apps.

Usually, the frameworks themselves, “servers,” “engines,” and “drivers” would not be easy to generate with the MDA approach. I imagine, apps and games with highly customized UI/UX would not be a good fit either.

MDA is for “boring” business apps where you would want all your screens look the same unified way. That’s where MDA shines, cuts down coding and QA effort, and allows producing massive products with many hundreds of tables and screens.

xq3000··on Ask HN: Entire API and DB generator from model definition
I would say that’s a valid insight and most Line Of business (LOB) apps can (and really should) be produced that way.

However, this approach usually doesn’t work for more “system” level products.

Check out Model-Driven Architecture [1]. Most likely you’ll be able to configure an MDA toolchain to generate the code you want

[1] MDA https://en.wikipedia.org/wiki/Model-driven_architecture

xq3000··on Ask HN: When to Form an LLC?
I personally would make a different suggestion here: 1) set up a new corp as soon as possible to be able to track business expenses right away, issue stock, etc 2) use an S-CORP instead of an LLC. All those additional “processes” people usually mention are really just “good business,” not that difficult to keep up with, and ultimately will only add security especially if you will have cofounders / investors. 3) use ONE corp for all your MVPs, track per-product costs nicely for each of them (Xero does it well), and only maybe spin them off into separate companies if/when they succeed
xq3000··on Solid VPS hosting for ~100 members website?
It sounds like a pretty content heavy site, a site that can expect a lot of reads. Why not just put it on S3?

Disclosure: I’m with AWS

xq3000··on How can I create a Database of Subscription Box companies?
So, to clarify, it looks like you are already using Google Sheets, which is great.

But the spreadsheet you link to is designed more “visually” and not like a real database. You also don’t seem to be accounting for 1-to-Many and Many-to-Many relationships in the data.

Also, from the way you phrase your question, it sounds like you say “a database” but mean “a database and an app to manage it.”

Am I close?

If that’s the case, I’d suggest to begin with watching a few YouTube videos on “database design” to understand things like “primary keys” and 1-to-Many and Many-to-Many relationships. And then focus on designing just the tables of your database. Possibly, just using Google Sheets and with a little help from an experienced freelance developer.

Once you get the tables right, you can think about the app. A few options there would be Google Sheets, Airtables, Bubble.is, or even using something like MySQL and a custom-built app.

xq3000··on ElectroCRUD v2 – MySQL CRUD Application (Open Source, GitHub)
It would be perfect for several of my clients if only it was a web based app.
xq3000··on Even Harvard Is Now Teaching Personal Finance
https://college.harvard.edu/financial-aid/financial-literacy
Page 1 of 2Next →