15:[[32993688,{"by":"ksec","descendants":1,"id":32993688,"kids":[33004502],"score":1,"time":1664276049,"title":"Apple launches App Store development program focusing on UK wome","type":"story","url":"https://appleinsider.com/articles/22/09/27/apple-launches-app-store-development-program-focusing-on-uk-women"}],[32979686,{"by":"hieu229","descendants":3,"id":32979686,"kids":[32986690,32991551,32979968],"score":1,"text":"Hi guys,

I'm building a social media mobile app (and potentially available for web).

As any social media app, there are a lots of relation data queries involve. For example, user follow authors, author create posts, post belong to topics.

Would it be much better to use SQL over NoSQL database in this case? Or maybe a mix of both?

Considering ease of development, the performance, and number of request trips. Such as checking if:\n- The current user is following an author (in a post page or author's profile page)\n- The current user has liked or bookmarked a post (in a post page)

Also, there are a number of querying recommendations for posts and authors for a user behind the sense.

Please share your advice if you have experienced in both NoSQL and SQL databases with similar project. Any database recommendation in particular?

Many thanks!","time":1664169428,"title":"Ask HN: NoSQL or SQL database for a social media app?","type":"story"}],[32937523,{"by":"atomiomi","descendants":70,"id":32937523,"kids":[32940312,32938644,32938755,32939160,32937817,32953276,32938465,32940008,32938205,32938828,32938566,32938179,32938891,32940001,32939070,32940234,32938963,33014474,32938048,32948241,32959135,32939027,32960077,32938633,32940561,32940192],"score":76,"text":"$16","time":1663846974,"title":"I came up with a better way to communicate with users","type":"story"}],[32938589,{"by":"april_22","descendants":434,"id":32938589,"kids":[32940313,32939382,32941844,32940186,32940498,32938992,32939088,32939007,32938821,32941444,32939900,32938724,32939367,32938827,32942749,32940239,32944454,32939963,32943832,32939940,32948026,32945124,32944171,32940980,32938780,32939942,32945936,32938673,32993860,32940811],"score":614,"time":1663853862,"title":"Google loses EU appeal and is fined a record $4B","type":"story","url":"https://www.axios.com/2022/09/14/google-loses-appeal-eu-antitrust-ruling"}],[32889929,{"by":"acconrad","descendants":547,"id":32889929,"kids":[32890467,32890755,32895544,32890917,32891547,32890515,32890873,32894387,32892025,32891596,32890550,32892087,32890456,32891107,32891370,32895738,32890690,32893780,32891934,32891723,32890861,32891017,32892880,32907648,32891604,32890561,32903010,32893411,32890931,32890599,32900673,32890475,32891926,32895294,32890720,32890558,32890818],"score":629,"time":1663525024,"title":"The $300B Google-Meta advertising duopoly is under attack","type":"story","url":"https://www.economist.com/business/2022/09/18/the-300bn-google-meta-advertising-duopoly-is-under-attack"}],[32866892,{"by":"Brajeshwar","descendants":43,"id":32866892,"kids":[32868907,32867291,32870010,32873934,32869286,32868597,32874738,32872135,32869741],"score":108,"time":1663340173,"title":"World’s longest journey by pumpkin boat","type":"story","url":"https://www.smithsonianmag.com/smart-news/pumpkin-boat-world-record-180980723/"}],[32842295,{"by":"DocFeind","descendants":8,"id":32842295,"kids":[32845918,32849890,32846986],"score":63,"time":1663184441,"title":"Drug Turns Cancer Gene into ‘Eat Me’ Flag for Immune System","type":"story","url":"https://www.ucsf.edu/news/2022/09/423661/drug-turns-cancer-gene-eat-me-flag-immune-system"}],[32830043,{"by":"devonnull","descendants":52,"id":32830043,"kids":[32832257,32831991,32830929,32830542,32831321,32830781,32831583,32834700,32847483,32830579,32832954,32833117,32833257,32834944],"score":31,"time":1663102400,"title":"I Use a Chromebook","type":"story","url":"https://www.aboutchromebooks.com/opinion/why-i-use-a-chromebook/"}],[32805361,{"by":"todsacerdoti","descendants":66,"id":32805361,"kids":[32807538,32805527,32805567,32805510,32805534,32805503,32805965,32805521,32806072,32806284,32807435,32805478,32806667,32805528,32805622,32805618,32805581,32805474,32805536,32805477,32805516,32806045,32806136,32805674,32815373,32805380],"score":122,"time":1662949627,"title":"http://pn./","type":"story","url":"http://pn./"}],[32777737,{"by":"helsinkiandrew","descendants":532,"id":32777737,"kids":[32782720,32778653,32784441,32778571,32786829,32778141,32778104,32784169,32786585,32777738,32785840,32784143,32778125,32786199,32787514,32784832,32782760,32782556,32778055,32787748,32785174,32781844,32786962,32781422],"score":404,"time":1662721342,"title":"Google pays ‘enormous’ sums to maintain search-engine dominance, DOJ says","type":"story","url":"https://www.bloomberg.com/news/articles/2022-09-08/google-pays-enormous-sums-to-maintain-its-dominance-doj-says"}],[32771261,{"by":"galaxyLogic","descendants":109,"id":32771261,"kids":[32773341,32772301,32772657,32772509,32772038,32771517,32772244,32773408,32772392,32773052,32788346,32772475,32775587,32772017,32772749,32775268,32772133,32772501,32771550,32772200,32774662],"score":108,"time":1662667372,"title":"Eight Secret Societies (2016)","type":"story","url":"https://www.smithsonianmag.com/history/secret-societies-you-might-not-know-180958294/"}],[32752505,{"by":"mmegger","descendants":16,"id":32752505,"kids":[32752829,32753295,32753389,32758950,32761109,32752874],"score":49,"time":1662567106,"title":"Generate Synthetic Data in 3 Lines of Code","type":"story","url":"https://gretel.ai/blog/generate-synthetic-data-in-3-lines-of-code"}],[32742274,{"by":"rglullis","descendants":89,"id":32742274,"kids":[32746218,32745555,32747527,32746964,32745916,32746130,32749491,32743666,32751869,32749779,32745741,32748820,32750823,32749671,32746262,32746260,32748596,32747364,32749497,32746435],"score":170,"time":1662493539,"title":"Let's Make Amazon into a Dumb Pipe","type":"story","url":"https://scribe.rip/view-a-sku-32721d623aee"}],[32729784,{"by":"vadcv","descendants":34,"id":32729784,"kids":[32731201,32731166,32730623,32734934,32731347,32731128,32732774,32736482,32736496,32733843,32734987,32730870],"score":156,"time":1662413795,"title":"How to present backend demos","type":"story","url":"https://rxhl.notion.site/How-To-Present-Backend-Demos-861303c09e3e48fcb33a2a6999260e59"}],[32711904,{"by":"elephant_burger","descendants":78,"id":32711904,"kids":[32721178,32720763,32720369,32720822,32721405,32721220,32723765,32722029,32721151,32720980,32720708,32720271,32720644,32721092,32737906,32721539,32721277,32723897,32720551,32721418,32721052,32721622,32721500,32721076,32720418,32728796,32721424,32720667,32721546],"score":144,"time":1662290778,"title":"The IKEA Effect – Why managers fall in love with their own ideas","type":"story","url":"https://mannhowie.com/ikea-effect"}],[32698044,{"by":"sogen","descendants":307,"id":32698044,"kids":[32700173,32700238,32698750,32698569,32698515,32699345,32699003,32698523,32698470,32699975,32698651,32699853,32698869,32698524,32699004,32698538,32699565,32699299,32698694,32698518,32699210,32698549,32699445,32698494,32698880,32698563,32698771,32699333,32699100,32698966,32699309,32701318,32701014,32698568,32698472,32700014,32699153,32698992,32701057,32699943,32698664,32698879,32699201,32699428,32732092,32698684,32698606,32699140,32699237],"score":266,"time":1662172127,"title":"Nokia’s Burning Platform Memo (2011)","type":"story","url":"https://aaplinvestors.net/stats/iphone/nokiamemo/"}],[32686357,{"by":"JKCalhoun","descendants":12,"id":32686357,"kids":[32686738,32686864,32689121,32686875,32687648,32686756,32686605,32686758,32688845,32687225,32686473],"score":16,"text":"Backing up my documents and files to portable hard drives has been my strategy for decades now. I have so much data now, copied from one machine after another, from one drive to another that I have multiple copies of many files squirreled away in different locations on my backup drives (who knows how that happens — organization strategies changing over time?).

There has to be a tool (script?) that can scan a volume and using filenames, file sizes, come up with a list of possible duplicate files.

I don't think I would trust it to auto-cleanup (auto-delete duplicates) but at least with the duplicate paths laid out I could go through and begin the slow process of pruning until I have a final, canonical (and singular) backup of my files.

(Bonus if I can point it at the iCloud for the same purpose.)","time":1662090360,"title":"Ask HN: Identify duplicate files in my data hoard?","type":"story"}],[32670354,{"by":"memorable","descendants":14,"id":32670354,"kids":[32671063,32672281,32673129,32675922,32671347,32675570,32670784,32673690,32673796,32671951],"score":68,"time":1661993307,"title":"Fylm: AI-powered web colour corrector","type":"story","url":"https://fylm.ai/"}],[32640733,{"by":"lysergia","descendants":170,"id":32640733,"kids":[32641529,32641554,32642940,32645002,32645555,32643456,32641192,32644413,32641483,32643174,32641844,32641885,32647590,32641298,32641455,32643418,32641541,32642413,32641238,32647184,32642669,32641874,32644700,32644926,32644437,32643222,32648506,32641709,32643644,32643161,32648751,32645805,32658077,32644442,32647698,32646554,32644566,32648926,32647866,32641998,32643235,32647382,32643660,32644371,32647600,32645832,32643595,32647539,32653644,32646058,32642512,32647761,32641449,32643027,32643808],"score":620,"time":1661793153,"title":"90s Cursor Effects","type":"story","url":"https://tholman.com/cursor-effects/"}],[32631610,{"by":"Lammy","descendants":62,"id":32631610,"kids":[32632310,32634741,32632579,32633848,32636604,32632494,32635199,32634269,32633425,32633511,32632418,32633776,32634673,32633830,32634590],"score":122,"time":1661717313,"title":"The Quest for Fuel in World War II (1993)","type":"story","url":"http://www.eiaonline.com/history/bloodforoil.htm"}],[32583868,{"by":"drdee","descendants":7,"id":32583868,"kids":[32615432,32616773,32615573,32615123],"score":21,"time":1661366346,"title":"Panic at the Library","type":"story","url":"https://www.laphamsquarterly.org/roundtable/panic-library"}],[32597998,{"by":"bluepnume","descendants":237,"id":32597998,"kids":[32600453,32598759,32603159,32598588,32599241,32602706,32598824,32598933,32604787,32600345,32598956,32598216,32603212,32599082,32600501,32607711,32603048,32604608,32599001,32603074],"score":152,"time":1661452320,"title":"Subscriptions are out, refills are in","type":"story","url":"https://bluepnume.medium.com/subscriptions-are-out-refills-are-in-311fd6e41e5e"}],[32580016,{"by":"qin","descendants":76,"id":32580016,"kids":[32583917,32581428,32583837,32580573,32582465,32580534,32581873,32583584,32585777,32589405,32582172,32583524],"score":333,"time":1661351771,"title":"Accounting for Developers, Part II","type":"story","url":"https://www.moderntreasury.com/journal/accounting-for-developers-part-ii"}],[32566123,{"by":"flreln","descendants":50,"id":32566123,"kids":[32567684,32567631,32571424,32566957,32575412,32569621,32574500,32572061,32574897,32567320,32566734,32567254,32574648,32574407,32566757,32567941,32567305,32567671],"score":212,"time":1661267759,"title":"How to communicate why your startup is worth joining","type":"story","url":"https://wasp-lang.dev/blog/2022/08/15/how-to-communicate-why-your-startup-is-worth-joining"}],[32555028,{"by":"flimsythoughts","descendants":413,"id":32555028,"kids":[32555540,32556637,32555608,32555115,32555048,32558913,32555411,32555144,32555752,32555208,32557720,32556699,32556641,32556608,32555939,32555591,32555318,32557243,32556046,32557886,32555640,32555174,32556219,32555916,32559663,32579543,32560384,32555914,32555919,32558408,32558932,32561529,32555477,32564858,32556469,32556403,32555354,32556192,32555300,32557946,32557889,32555993,32557182,32555334,32555638,32555475,32556185,32555586],"score":770,"time":1661191703,"title":"Stable Diffusion Public Release","type":"story","url":"https://stability.ai/blog/stable-diffusion-public-release"}],[32471605,{"by":"gmays","descendants":36,"id":32471605,"kids":[32473673,32473665,32476679,32474687,32479408,32480769,32474626,32474883,32475267],"score":146,"time":1660580301,"title":"How to design a referral program","type":"story","url":"https://andrewchen.com/how-to-design-a-referral-program/"}],[32440479,{"by":"Tomte","descendants":39,"id":32440479,"kids":[32442307,32441859,32442475,32447229,32441996,32441885,32447491,32447557,32442427,32441798,32442486,32449377],"score":216,"time":1660320017,"title":"Logistics, How Did They Do It, Part III: On the Move","type":"story","url":"https://acoup.blog/2022/08/12/collections-logistics-how-did-they-do-it-part-iii-on-the-move/"}],[32434535,{"by":"crhulls","descendants":8,"id":32434535,"kids":[32434673,32435663,32434715,32434960,32434650],"score":5,"time":1660276184,"title":"CEO posts crying selfie on LinkedIn after laying off employees","type":"story","url":"https://www.cnbc.com/2022/08/11/ceo-posts-crying-selfie-on-linkedin-after-laying-off-employees-and-it-goes-viral-.html"}],[32418679,{"by":"samwillis","descendants":153,"id":32418679,"kids":[32419845,32419623,32419941,32422234,32419933,32422400,32420493,32420405,32420835,32421924,32430140,32420505,32419872,32421189,32420751,32424637,32420725,32419836,32421157,32419801,32421763,32422624,32419780,32420400,32423122,32421597,32421536,32424127,32421886,32421723,32422232,32420928,32421582,32421154,32420743,32421553,32421850,32425177,32420775,32421091,32419742,32421254],"score":430,"time":1660166827,"title":"Let websites framebust out of native apps","type":"story","url":"https://www.holovaty.com/writing/framebust-native-apps/"}]]

user:	Raziarazzi
created:	July 30, 2022
karma:	-3