15:[[31802502,{"by":"yamisobad","descendants":56,"id":31802502,"kids":[31804067,31803575,31804951,31802603,31808926,31805892,31805477,31810193,31802566,31805096,31806275,31802534,31805276,31804879,31803258,31806022,31805178,31806017,31804710,31835878,31807127,31802582,31818659,31803637,31819435,31804457,31821744,31820020,31821968],"score":69,"text":"$16","time":1655666555,"title":"Ask HN: 30s and “senior” software engineer, but I suck at programming","type":"story"}],[31713403,{"by":"itsmefaz","descendants":10,"id":31713403,"kids":[31744824,31713567,31714108,31715612],"score":3,"text":"$17","time":1655029156,"title":"Ask HN: Java Suffers from an Identity Problem","type":"story"}],[31648326,{"by":"andrecarini","descendants":291,"id":31648326,"kids":[31649688,31648673,31648805,31648719,31649227,31650645,31648809,31648752,31649576,31650890,31648891,31648954,31649341,31650430,31649338,31648623,31648969,31649042,31651185,31648983,31651070,31651665,31649356,31651627,31648522,31648544,31648693,31650329,31649069,31649462,31651737,31649548,31648691,31649300,31648804,31648841,31649222,31650049,31648541,31649448,31649205,31650792,31649052,31649372,31651547,31651532,31688047,31650969,31651386,31648952,31650922,31679271,31653618,31651539,31648724,31648697,31651054,31685801,31653712,31650188,31649265,31650056,31648680,31657065,31648797,31653519,31677185,31651373,31650741,31649492,31649652,31649174,31651573,31648585,31649204,31648928,31649213,31649522,31650565,31650095,31651512,31658814,31649326,31655019,31651043,31648971,31652327,31648732,31648907,31650683,31650305,31650291,31649263,31648787,31648859,31666470,31648745,31649317,31650358,31655964,31650103,31648711,31651598,31653080,31703114,31649290,31650296,31650120,31649210,31649176,31649612,31649458,31648852,31649378,31676503,31650025,31651307,31649094,31650752,31649127],"score":407,"text":"$18","time":1654561367,"title":"Tell HN: I used the same computer since 2007 (with minor upgrades)","type":"story"}],[31609649,{"by":"luke8086","descendants":2,"id":31609649,"kids":[31611150,31617154],"score":3,"text":"Let's say you have have a large-ish database table of product orders, and you'd like to allow users to query it with an API, using several different filter and sort options, and of course supporting pagination.

What would be the best strategy to optimize such query? Creating an index for every possible combination of options doesn't seem practical. How do large companies handle queries like [0], with 20 different filters and 10 different sort options?

In our particular case, we use a MySQL db in AWS RDS.

Tangentially, can you recommend any good books/resources with real-world usage patterns, and examples of the entire process of analyzing and solving database-related problems in growing web applications? Ideally written from the problem perspective, rather than just a reference of available db functionalities.

Thanks!

[0] https://shopify.dev/api/admin-graphql/2022-01/objects/Product#query-products","time":1654270100,"title":"Ask HN: Optimizing database table for user-made queries?","type":"story"}],[31608397,{"by":"firstSpeaker","descendants":50,"id":31608397,"kids":[31608528,31609925,31610025,31609988,31610113,31609863,31611662,31609545,31609586,31609209,31609943,31610288,31610218,31610181,31683940,31610627,31612543,31610335,31610465,31609678,31610093,31609718,31609736,31610007,31609898,31610504,31610104,31610577,31610648,31619871,31610771,31608551,31609342,31608428],"score":47,"text":"I am looking for a way to keep myself focus at work. I am very much multi-tasking and that is coming with the overhead that it has.

I wonder how the HN community deal with that and if Pomorodo technique is something you are using and recommending.","time":1654264861,"title":"Ask HN: How do you stay focused at work?","type":"story"}],[31537319,{"by":"ricardbejarano","descendants":319,"id":31537319,"kids":[31538222,31537599,31537604,31537856,31537939,31537707,31537628,31537706,31539952,31538372,31537843,31537481,31546014,31542839,31537625,31537664,31538255,31538505,31541046,31538742,31539911,31537731,31543376,31542761,31538998,31538962,31539204,31538521,31537764,31538094,31537558,31538093,31542000,31538323,31539730,31547186,31537534,31538474,31537794,31538240,31539589,31538252,31537641,31554872,31537647,31539052,31538084,31538741,31538589,31540520,31537906,31537882,31539746,31539898,31540812,31542120,31540657,31538737,31538375,31553987,31537519,31543057,31538928,31538926,31538086,31537510],"score":381,"time":1653708030,"title":"Terraform should have remained stateless","type":"story","url":"https://www.bejarano.io/terraform-stateless/"}],[31324917,{"by":"techsin101","descendants":479,"id":31324917,"kids":[31325684,31325157,31325966,31326072,31325530,31325052,31325720,31325230,31327020,31325345,31324959,31325122,31325401,31325153,31325334,31332177,31327576,31325576,31325975,31325343,31335316,31325207,31325925,31325043,31326055,31326670,31325707,31325485,31325906,31325884,31325782,31325432,31327799,31325322,31326606,31325601,31325953,31326988,31326718,31325655,31325209,31327937,31325268,31330592,31326152,31325762,31326344,31325123,31334690,31326007,31328102,31325434,31326155,31326445,31328429,31331998,31325309,31327868,31328381,31329126,31326782,31325982,31326491,31325844,31325726,31330067,31329100,31325516,31325886,31325525,31326851,31335356,31326019,31327079,31325955,31325853,31326191,31326434,31350042,31325464,31327672,31328417,31325271,31334243,31328110,31325879,31325498,31326076,31327392,31325355,31325641,31327950,31325984,31327386,31327688,31325092,31329049,31325827,31327121,31325960,31326623,31325395,31325329,31326128,31349362,31325866,31349912,31325496,31327675,31326446,31327856,31325150,31326535,31328044,31328132,31326300,31327826,31329661,31326402,31334040,31325430,31332558,31331593,31328228,31333497,31325934,31333094,31325591,31335616,31325867,31343110,31327528,31325750,31325113,31327471,31325863,31325841,31325742,31325199,31325897,31325664,31326190,31328019,31325802,31328970,31326080,31325812,31326482,31325303,31328358,31325912,31327533,31327027,31326884,31325463,31325378,31325610,31325711,31325327,31325503,31325228,31325368],"score":1097,"text":"$19","time":1652172517,"title":"No Dislikes has officially ruined YouTube for me","type":"story"}],[30702431,{"by":"eballci","descendants":45,"id":30702431,"kids":[30703736,30702754,30704589,30706951,30703771,30702543,30702510,30702699,30707613,30710065,30702978,30704968,30702671,30703748,30702518,30702765,30703250,30715936,30706335,30704071,30702672,30735076,30719517,30703186,30738502,30706818,30709453,30705148,30705287,30702691,30710101,30707342,30703586,30703651,30719880,30703688,30709695],"score":64,"text":"Hello everyone,\nI am Computer Science student which enthusiast about programming, software development techniques, project management and system design. I always read a lot of blog posts, cool stuff or techniques. Though, i can not find the way how to practise them. Sometimes i find an idea that i \nmay accomplish. Afterwards next i'm thinking about the idea and i realize the idea is not fullfilled or not useful for humanity, community, at least for me. And i am here to discuss my issue. Every comment is welcome.

Note: This is my first post on HN so if i violated some rules by (or the way) posting this i am so sorry. And also sorry for that i am not fluent in english.","time":1647456203,"title":"Tell HN: I Need Project Ideas","type":"story"}],[30705039,{"by":"omosubi","descendants":52,"id":30705039,"kids":[30706138,30711691,30706141,30706074,30705485,30706034,30705959,30707334,30705430,30707354,30708822,30705865,30705460,30705268,30706424,30705281,30706624,30706177,30708428,30705348,30706332,30706676,30706701,30706095,30706782,30706471,30706263,30706523,30712797,30706745],"score":21,"text":"Regardless of type: music, paintings, drawings, literature, movies, video games, sculpture, architecture etc.","time":1647470326,"title":"Ask HN: What recent art (last ~20 years) will be well known in 500 years?","type":"story"}],[30658212,{"by":"kirso","descendants":27,"id":30658212,"kids":[30660125,30658308,30661342,30662822,30660686,30660625,30662908,30735194,30658631,30660852,30659749,30660245,30661603,30661726,30659150,30658244,30658265],"score":31,"text":"A quick background:\nI started learning programming for the sake of building stuff. Quite frankly even the ability to help in any way during the crisis in Europe by collating information on the web is a seriously valuable skill. It sounds trivial to many here, but just a small contribution like that seems like a superpower.

As a job, it doesn't seem super enticing though. I started wondering how many people actually still do it because they enjoy it compared to "out of necessity"?

Feeling of creating something out of nothing, even super simple and uncomplicated but useful feels very rewarding...

Wordle is a good example of just a simple piece of software that is elegant in its own way and was created for fun instead of drilling on specifics of making something scalable or achieving an OKR. It feels like it's a lost philosophy nowadays where everyone is chasing unicorns and money.

Where did all the fun go?","time":1647148466,"title":"Ask HN: Are you still programming for fun?","type":"story"}],[30378306,{"by":"mmsimanga","descendants":253,"id":30378306,"kids":[30379089,30379232,30379423,30379579,30379744,30379362,30380640,30379323,30379246,30381581,30379222,30379293,30379935,30379658,30379588,30379291,30379435,30380743,30379832,30380669,30380001,30379895,30379780,30379195,30382845,30383957,30379601,30381985,30385996,30389468,30379861,30379197,30379887,30378845,30381733,30392148,30379563,30381241,30380393,30382736,30379689,30383619,30380108,30392483,30379553,30379512,30379057,30379671,30379665,30379603,30391932,30379703,30381329,30383105,30379015,30379503,30381060,30381522,30381841,30381019,30384180,30379428,30379612,30379931,30392351,30378823,30379398,30380478,30380012,30382675,30379921,30379097,30382848,30382615,30379957,30384201,30378882],"score":233,"text":"I have a laptop with an i5 processor and 8G of RAM. Hard drive is an SSD. It sometimes takes me a full minute and a half to get Teams open and ready to join a meeting. It is driving me crazy.","time":1645130121,"title":"Ask HN: Why is MS Teams so slow, do devs test Teams on less powerful machines?","type":"story"}],[30160282,{"by":"etamponi","descendants":242,"id":30160282,"kids":[30160466,30160459,30161757,30160675,30160533,30161454,30160428,30160920,30160347,30162040,30160838,30163301,30161809,30161079,30161661,30160654,30160565,30160485,30160770,30161435,30160458,30162952,30162842,30160860,30162171,30162128,30160328,30160472,30161560,30161126,30162217,30161526,30160515,30161406,30162398,30160791,30160653,30162172,30161863,30161128,30166677,30161779,30160790,30162863,30160429,30166087,30161919,30163891,30162969,30160936,30164471,30161212,30162296,30161035,30162026,30161643,30160787,30162353,30165111,30164577,30161537,30161689,30161470,30161979,30162127,30160528,30161969,30160405,30160318,30162550,30160975,30161214,30194773,30161281,30162139,30160761,30162272,30160637,30160601,30161527,30160765,30161706,30170186,30162644,30161237,30172239,30160747,30160710,30161000,30160716,30160762,30160430,30161972,30162988,30161456,30162306,30162145,30161791,30173942,30160550,30161263,30174296,30164057,30161003,30162561,30161696],"score":157,"text":"$1a","time":1643707207,"title":"Ask HN: How do you explain the sloppiness of modern software?","type":"story"}],[30131628,{"by":"pilingual","descendants":438,"id":30131628,"kids":[30132088,30131965,30136815,30133939,30132081,30131977,30132224,30132016,30132112,30132370,30135470,30132127,30132335,30131923,30135983,30132321,30137429,30132884,30133054,30132130,30135235,30132111,30133508,30132202,30134735,30135706,30132168,30132084,30132044,30132059,30133625,30132874,30137369,30132255,30137452,30132200,30137243,30131979,30133354,30136805,30135003,30133091,30132221,30134099,30132355,30133467,30133178,30139898,30134502,30132193,30132542,30132390,30137257,30133106,30132814,30137561,30136198,30132532,30131987,30132176,30132680,30135939,30132178,30132967,30134537,30135482,30134016,30132566,30133058,30136410,30134691,30137877,30134898,30131981,30132243,30134387,30132885,30132398,30132919,30135542,30132302,30132409,30135423,30132977,30133395,30135121,30133759,30133256,30132118,30132467,30139618,30145017,30133637,30132777,30132220,30132868,30133819,30137423,30132926,30134020,30136315,30132152,30132942,30133383,30132028,30142813,30132207,30131970],"score":352,"time":1643498299,"title":"Phone is still the best way to order pizza","type":"story","url":"https://dan.bulwinkle.net/blog/phone-is-still-the-best-way-to-order-pizza/"}],[29978723,{"by":"totablebanjo","descendants":1353,"id":29978723,"kids":[29980006,29979035,29981503,29981401,29979080,29978974,29979565,29978854,29988729,29978814,29981969,29978905,29978907,29980387,29978898,29979002,29980275,29987641,29979373,29982875,29980201,29979247,29979053,29980060,29979393,29980506,29978912,29989522,29979465,29985169,29979029,29987205,29979468,29979225,29983011,29981654,29979704,29978904,29979815,29979399,29982282,29987951,29982814,29980596,29979159,29979134,29980597,29979282,29979978,29981552,29978838,29979909,29979813,29979965,29980988,29989516,29983824,29979878,29980272,29978960,29979762,29979768,29983209,29984621,29979720,29980091,29980090,29979044,29981611,29984019,29979518,29981694,29978789,29985381,29982081,29982582,29980401,29979831,29986265,29978966,29983682,29979345,29987292,29978782,29987699,29980477,29981192,29982764,29982798,29983323,29992793,29984338,29979527,29978943,29982717,29981004,29985974,29984273,29979687,29979603,29981387,29979727,29980420,29980958,29981777,29983559,29979202,29981579,29981971,29980230,29979906,29980431,29987975,29983033,29981357,29981095,29978940,29981758,29979111,29979139,29979879,29979624,29979304,29980412,29984372,29979246,29980475,29984446,29980067,29979999,29980398,29979534,29979007,29979031,29981320,29979887,29982153,29979229,29979525,29982736,29979330,29984101,29980628,29981733,29981312,29980206,29980053,29979817,29980212,29979803,29978997,29979679,29979297,29985026,29978948,29989019,29979369,29979323,29982288,29979454,29980164,29979533,29980652,29980379,29981728,29979579,29979609,29979811,29979391,29979194,29979201,29983532,29979066,29978933,29980378],"score":2051,"time":1642512622,"title":"Microsoft to Acquire Activision Blizzard","type":"story","url":"https://news.microsoft.com/2022/01/18/microsoft-to-acquire-activision-blizzard-to-bring-the-joy-and-community-of-gaming-to-everyone-across-every-device/"}],[29874390,{"by":"mWQS10","descendants":78,"id":29874390,"kids":[29875676,29875233,29877012,29875353,29876709,29875126,29877508,29875092,29877710,29881224,29890380,29879033,29877390,29875136,29878098,29875031,29876385,29880314,29875215,29878317,29876772,29893204,29877947,29906964,29887998,29875070,29878515,29876803,29889349,29877182,29876564,29875904,29876686,29891813,29877050,29885732,29878599,29875404,29889545,29876500,29875118,29889458,29917302,29876842],"score":48,"text":"$1b","time":1641821086,"title":"Ask HN: I’m starting a new job and things feel off. Am I overreacting?","type":"story"}],[29446529,{"by":"MereCivilian","descendants":682,"id":29446529,"kids":[29446857,29447693,29447314,29446865,29447217,29446985,29448152,29448090,29446717,29446752,29450380,29448284,29447235,29448484,29446973,29446699,29450977,29447603,29448233,29447047,29450995,29447899,29447532,29446685,29448221,29448361,29446916,29451181,29446709,29447286,29446714,29449234,29447665,29447238,29448612,29447748,29447604,29446828,29449184,29450153,29449717,29446732,29448227,29450645,29449192,29448731,29447256,29447243,29446816,29446823,29446880,29447088,29449543,29450418,29446858,29446772,29448882,29453959,29447044,29447358,29447051,29450086,29448302,29447914,29446725,29452153,29447090,29447656,29447661,29447923,29448871,29448569,29451232,29450255,29448625,29446911,29448663,29447080,29448027,29446774,29446893,29472399,29447873,29448855,29447590,29447125,29449861,29450998,29447757,29447491,29447310,29450691,29450719,29447276,29448096,29466266,29446675,29447025,29457928,29448631,29447124,29446703,29448650,29447373,29448038,29446667],"score":985,"time":1638675964,"title":"Apple broke up with me","type":"story","url":"https://merecivilian.com/apple-broke-up-with-me/"}],[29109995,{"by":"zekenie","descendants":267,"id":29109995,"kids":[29116421,29114270,29116007,29115687,29117569,29116644,29116183,29116336,29117630,29115959,29115996,29118771,29116526,29121338,29116359,29116913,29115978,29118923,29121718,29118926,29118706,29117093,29118230,29117587,29116899,29116807,29116379,29116676,29126667,29119836,29119928,29138414,29116481,29118169,29118895,29116245,29117477,29118521,29119606,29119654,29116910,29116220,29116852,29116356,29132013,29120811,29120748,29119396,29121687,29115531,29125147,29118838,29117506,29119986,29116456,29116672],"score":738,"time":1636046645,"title":"Why is Excalidraw so good?","type":"story","url":"https://offbyone.us/posts/why-is-excalidraw-so-good/"}],[29004930,{"by":"PranavBerry","descendants":26,"id":29004930,"kids":[29005579,29006865,29010095,29006442,29005582,29005345,29006020,29012215,29007674,29005118,29006022,29005363,29010370,29009281,29008511,29011530],"score":16,"text":"What do you use to handle 2FA? Sms? Email? or an Authenticator app?

What problems do you face with whatever 2FA you use? Are there security issues with any of them?

In case you use a phone based 2FA, is the phone not having internet/network a frequent problem?

PS - I am ideating on a 2FA method using cryptography where the user will not need internet on his phone. A QR code will be generated on the phone for each login attempt. The website/app where the user is logging in will scan that QR code and if the information in it is valid, the user will be logged in. Please let me know if you have any feedback on this and if this solution will solve any problems you have with 2FA.","time":1635275792,"title":"How do you handle 2FA?","type":"story"}],[28451221,{"by":"rokhayakebe","descendants":8,"id":28451221,"kids":[28451575,28451474,28451448,28453014,28456164,28453317,28451510],"score":6,"text":"$1c","time":1631058374,"title":"Most People Should Learn How to Code","type":"story"}],[27776829,{"by":"todsacerdoti","descendants":110,"id":27776829,"kids":[27777719,27777728,27780808,27779500,27778338,27781062,27777550,27777429,27782127,27780816,27777761,27780076,27779611,27778862,27780268,27781813,27781020,27781090,27783278,27791932,27777629,27784135,27777690,27778751,27777693],"score":170,"time":1625773913,"title":"I made a mistake with Terraform and Azure made it worse","type":"story","url":"https://www.craigstuntz.com/posts/2021-07-08-how-i-made-a-giant-mistake-with-terraform.html"}],[27467999,{"by":"crummy","descendants":280,"id":27467999,"kids":[27468654,27468644,27471953,27468797,27468184,27471036,27468349,27468710,27469160,27468621,27468424,27469077,27468593,27470631,27468753,27468830,27468512,27468983,27468412,27471647,27472928,27469365,27468615,27470850,27472798,27474877,27468920,27468716,27471860,27474510,27471870,27490945,27468685,27468368,27469884,27472319,27468622,27471081,27470325,27468726,27470035,27470720,27469741,27469433,27470096,27469664,27468683,27472290,27469505,27489810,27471023,27472017,27468806,27469089,27469042],"score":795,"time":1623372575,"title":"Don't Feed the Thought Leaders","type":"story","url":"https://earthly.dev/blog/thought-leaders/"}],[26024180,{"by":"heisnotanalien","descendants":14,"id":26024180,"kids":[26025981,26028957,26024779,26032092,26027469,26024388,26026424,26033032,26024230],"score":9,"text":"One of the things I love about personal projects is that you don't need to explain what you did to anyone in a standup. You can devote your energy to the programming instead. I understand in a business context that it is helpful to explain what you did to someone else but let's face it, it also robs some of the joy of the process. Am I wrong here? Isn't programming a more creative endeavour than we think?","time":1612433447,"title":"I hate how programming has become just another business process","type":"story"}],[25978013,{"by":"thejokersthief","descendants":196,"id":25978013,"kids":[25978727,25978261,25978877,25978553,25979852,25978944,25978214,25981628,25978435,25979842,25979137,25978325,25979138,25978241,25978842,25978239,25980077,25978487,25978389,25978238,25978818,25979878,25979776,25981912,25979678,25980230,25981590,25978416,25979401,25979330,25981474,25978505,25979951,25981085,25983612,25978459,25980468,25979837,25979211,25978519,25979544,25978444,25979021,25978417,25978467,25978288],"score":414,"time":1612092386,"title":"How to Turn an IKEA Coffee Table into a DIY Server Rack","type":"story","url":"https://wiki.eth0.nl/index.php/LackRack"}],[25825244,{"by":"walterclifford","descendants":308,"id":25825244,"kids":[25826299,25826445,25825568,25825749,25825886,25825688,25826959,25825779,25825649,25826180,25826788,25828673,25826353,25826324,25825968,25827225,25826221,25825775,25826908,25826511,25828016,25826366,25826462,25825727,25827738,25833532,25826148,25825999,25826074,25826101,25829188,25826836,25830719,25826391,25825739,25829878,25827853,25826183,25826451,25830307,25829371,25825755,25830999,25828568,25826786,25828953,25826289,25830282,25826438,25827678,25849541,25826867,25826190,25826109,25829974,25826001,25829420,25826012,25826282],"score":780,"time":1610996573,"title":"Software effort estimation is mostly fake research","type":"story","url":"http://shape-of-code.coding-guidelines.com/2021/01/17/software-effort-estimation-is-mostly-fake-research/"}],[25801986,{"by":"wheresvic4","descendants":223,"id":25801986,"kids":[25805574,25803305,25802274,25802610,25802213,25803048,25803178,25804057,25802550,25803049,25802271,25803784,25805314,25803454,25802729,25807316,25802345,25804125,25803384,25803011,25802378,25803502,25804978,25805515,25807662,25817296,25804260,25802736,25808131,25811476,25802998,25804055,25804524,25806596,25803444,25808657,25806795,25803254,25808725,25810553,25804334,25803282,25808020,25807138,25802618,25805038,25806397,25802910,25806915],"score":269,"time":1610802723,"title":"The Problem with Gradle","type":"story","url":"https://www.bruceeckel.com/2021/01/02/the-problem-with-gradle/"}],[25734387,{"by":"petr25102018","descendants":13,"id":25734387,"kids":[25750262,25735769,25735620,25743024,25743258,25740097,25740247,25752476,25757991,25737581,25753017],"score":7,"text":"The technology can be a language, library, framework, cloud provider, code editor, saas or anything relevant to software development.","time":1610391885,"title":"Ask HN: What technology did you recently use, but wouldn't like to use again?","type":"story"}],[25564829,{"by":"politician","descendants":6,"id":25564829,"kids":[25565972,25564847,25589914],"score":2,"text":"Was support for authenticating to websites using SSH keys ever considered by any of the standards bodies or browser vendors (esp. Firefox)? If so, is there any documentation or historical record of why support was never implemented?","time":1609199623,"title":"Ask HN: Were SSH keys ever considered for browser authentication?","type":"story"}]]

1.	Blizzard Botched Warcraft III Remake After Internal Fights, Pressure over Costs(bloomberg.com) 5 points by franzwong 4 years ago \| 0 comments
2.	Ask HN: Why don't we create checksum for source code? 1 points by franzwong 5 years ago \| 3 comments

user:	franzwong
created:	March 22, 2012
karma:	157