Live data from Hacker News

Ask HN: What are you hacking these holidays?

news.ycombinator.com

41–50 of 50 posts

Re: Ask HN: What are you hacking these holidays?

#42
Porting FlatNote, my text/md based OneNote/ evernote alternative to mac.

Notes are stored in dropbox as plain text files. The app itself is basically just a markdown editor with a file tree, autosave and a list of recent files.

I'm currently playing around with various display modes for content, so if it sees a list it will render checkboxes which can be tapped to mark an item as ~complete~

My philosophy is that everything should be 100% open on the platform so you can just walk away with your data with minimal effort. FlatNote files will always be readable as markdown by any other app with no 'export' required

Re: Ask HN: What are you hacking these holidays?

#43

Earlier quoted context omitted.

How would you (as the DB author) know when a query has updated results?

Something like this: subscribe ('SELECT * FROM tableA', callback) On the initial subscription, 'callback' would be called once for each row in 'tableA', then again when a row is inserted or updated. It would be the same as Firebase in this respect.

No, you as the person writing this new database, not you as the user of the API.

Re: Ask HN: What are you hacking these holidays?

#44

Earlier quoted context omitted.

Something like this: subscribe ('SELECT * FROM tableA', callback) On the initial subscription, 'callback' would be called once for each row in 'tableA', then again when a row is inserted or updated. It would be the same as Firebase in this respect.

No, you as the person writing this new database, not you as the user of the API.

Not OP but I would watch for mutations in the subscribed columns, then test the changed rows on the query's constraints and fire an event if it satisfies them.

I'm sure there is a more clever/efficient way of doing this though, and I can't wait to see how he/she implements it.

Re: Ask HN: What are you hacking these holidays?

#45

Trying to figure out how to market my side project. https://www.printpost.co Any suggestions welcome.

You could buy some Instagram ads or run some promotions (e.g. "post a picture with the hashtag #printpost for a chance to get it printed").

Re: Ask HN: What are you hacking these holidays?

#46
Working on an in-app PDF viewer in a react side project. I am working with PDF.js and experimenting with tracking page views, per page views, and total time interacted with a document. Once I have that initial data I would like to use some nice charts from ReCharts to really make the data look pretty.

Re: Ask HN: What are you hacking these holidays?

#47

I've been thinking about prototyping a Firebase clone that uses a relational database and SQL syntax. Instead of subscribing to "nodes" you would subscribe to queries. Anyone know if this exists already?

Related in a limited fashion:

https://docs.microsoft.com/en-us/dotnet/framework/data/adone...

Then there's this write-up of someone replacing rethinkdb with postgres for live queries - (including a link to some code)

http://blog.sagemath.com/2017/02/09/rethinkdb-vs-postgres.ht...

Have you any plans already of how you will go about this?

Re: Ask HN: What are you hacking these holidays?

#48

Earlier quoted context omitted.

No, you as the person writing this new database, not you as the user of the API.

Not OP but I would watch for mutations in the subscribed columns, then test the changed rows on the query's constraints and fire an event if it satisfies them. I'm sure there is a more clever/efficient way of doing this though, and I can't wait to see how he/she implements it.

[deleted]

Re: Ask HN: What are you hacking these holidays?

#50
post #36

I'll be working on my Test Case automation service. It'll make play/record web testing a breeze. https://swif.club/?s=hw

that landing page is pretty sparse on information, and the only next page is a sign up page. Spend the holidays organising your landing page(s)

Thanks for the actionable feedback!
Post reply on HN