javascript – Abrir arquivo de formato específico no aplicativo que estou desenvolvendo — react native

Ola Devs!!
Estou com uma duvida aqui…
Sobre a possibilidade de configurar no aplicativo (que estou desenvolvendo) a opção de abrir um arquivo kml (arquivo de extensão).
Por exemplo, quando a pessoa clicar nesse arquivo de formato kml sendo através do whatsapp ou pelo gerenciado de arquivos do celular, daria a opção de abrir com o aplicativo.
Então a ideia seria configurar no aplicativo essa possibilidade de abrir o arquivo kml no aplicativo que estou desenvolvendo.

Stack de desenvolvimento: React Native + node.js

Native advertising formats from EvaDav

EvaDav is a client-oriented global advertising network, providing cutting-edge solutions both

to advertisers and publishers who are integrated into a single platform. It provides the best

performance and inventory and embraces the most perspective markets of advertising

formats – in-page, pops, native and classic push notifications.

EvaDav has developed its own anti-fraud system together with

an effective algorithm for predicting audience behavior. Ads will be shown to the maximum

target audience.


In-page Push

Premium Popunder

Native Push

Native Banner


Some numbers to back the claims about EvaDav being a leading push notification

advertising network:

➡️Daily Impressions: 3B+

➡️Active Advertisers: 20K+

➡️Active Publishers: 50K+

➡️Active SSP: 150+

➡️Supported Payment Systems: 15+ (Wire, PayPal, WebMoney, ePayments, Skrill,

Paxum, Payoneer, Capitalist, Bank Transfer, Wechat, AliPay, BitPay, etc.)


✅100% brand-safety- advertising doesn’t depend on the site and is shown in a separate


✅Creative policy- global standards with an individual approach

✅Premium inventory- priority access to top publishers

✅100% viewability- each impression is actually viewed by a user

✅High CTR- average CTR is more than 0.9%

✅Competitive CPC- average CPC starts at 0.001$

✅Targeting group- 30+ options to reach your audience

✅Wide choice of payments systems

✅Personal manager and tech support available 24/7

✅Cross-platform ad solutions

✅Own unique subscribers database


For video playback from cloud, would a properly written native mobile app be faster than a web app run on Android?

I want to develop a backend cloud service that delivers full color compressed videos (as high def as possible) to Android smart phones for streaming playback. Would I get better playback if I properly develop a native mobile app or if I simply use the browser, maybe with some scripting, to access and play the video? I want the highest bandwidth playback I can get. Thanks!

SQL Native Client Upgrade

Application server for CRM has SQL native client 2008 version installed. I have installed SQL native client 2012 side by side as need to connect to an sql availability group listener. How do I get the application server to use the new client version? Oledb connection

mobile – Should I buy an Expo ( with 2020 Expo SDK 39) or React Native CLI classes?

Good night, everyone…
I`ve been studying react native for about 1 year, and always used expo sdk 37. I managed to develop 2 different apps, but I only knew about “how to do it” and not ” how does it work”.

I can say I have intermediate level at this coding, and I`m looking for some online paid classes.

My doubt is:
I can’t find any classes that actually uses Expo during the teaching, and I heard many videos about how new EXPO SDK is incredible… So is it worth it to study and develop projects with React-native-cli or should I just keep geting better at expo?

Also,if you can truly explain me the advantages and disadvantages of using expo, feel free to do it

wp query – Extremely slow native WooCommerce queries, almost 100s for a product category archive page

Most of my product category archive pages are extremely slow, they take more than a minute to load. My CPU is maxed out during simple page loads.

I have around 11000 products in my store (all of them simple products and around 600 product categories (hierarchical).

I thought the issue was some PHP scripts, but there are only two PHP scripts on the archive page – both of them very lightweight and custom, I’ve measured and they run below 0,1s each (I also tried removing them, just to be 100% sure).

I installed Query Monitor and found out native WooCommerce products queries are extremely slow. This is the query for a category page:

FROM wp_posts
LEFT JOIN wp_term_relationships
ON (wp_posts.ID = wp_term_relationships.object_id)
INNER JOIN wp_postmeta
ON ( wp_posts.ID = wp_postmeta.post_id )
INNER JOIN wp_postmeta AS mt1
ON ( wp_posts.ID = mt1.post_id )
LEFT JOIN wp_wc_product_meta_lookup wc_product_meta_lookup
ON wp_posts.ID = wc_product_meta_lookup.product_id
AND ( wp_posts.ID NOT IN (
SELECT object_id
FROM wp_term_relationships
WHERE term_taxonomy_id IN (7) )
AND wp_term_relationships.term_taxonomy_id IN (74,75,76,80,82,83,93,94,101,102,104,105,109,110,111,114,115,125,127,129,130,131,132,133,137,139,140,141,143,144,145,152,154,155,157,159,160,163,166,170,173,176,177,186,187,188,189,193,195,199,200,205,209,211,212,217,218,220,221,222,223,225,226,229,230,232,233,234,235,237,244,245,249,252,255,257,259,260,267,276,277,278,280,283,287,288,292,297,298,300,301,304,305,307,308,310,312,314,316,319,328,336,339,344,346,352,375,389,390,391,392,393,394,395,396,399,401,402,405,407,409,410,411,413,415,418,420,421,423,424,425,426,430,432,434,438,439,440,441,442,443,444,445,446,447,448,449,450,452,453,455,457,458,459,460,461,462,463,464,465,466,467,468,469,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,494,495,499,500,501,502,503,504,505,506,507,508,509,510,511,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,532,533,534,535,536,537,538,539,540,541,542,543,545,546,547,548,549,550,551,552,553,554,555,556,557,558,559,560,561,562,563,564,565,566,567,568,569,570,571,572,573,574,575,576,577,578,579,580,581,582,583,584,585,586,587,588,589,590,592,594,595,596,597,598,599,600,601,602,603,604,605,606,607,608,609,610,611,612,615,616,617,618,619,620,621,622,623,624,625,626,627,628,629,630,631,632,633,634,635,636,637,638,639,640,641,642,643,644,645,646,647,648,649,650,651,652,653,654,655,656,657,658,659,660,661,662,663,664,665,666,667,668,669,670,671,672,673,674,675,676,677,678,679,680,681,682,683,684,685,686,687,688,689,690,692,694,695,696,697,698,699,700,701,702,703,704,705,706,707,708,709,711,712,713,714,715,716,717,718,719,720,721,722,723,724,725,726,727,728,729,730,731,732,733,734,735,736,737,738,739,740,741,743,744,745,746,747,751,762,763,766,767,768,770,771,772,774,775,776,777,778,779,780,781,782,783,784,785,786,787,788,789,790,791,792,793,794,795,796,797,798,799,800,801,802,804,805,807,809,811,813,814,815,816,817,818,819,820,830,833,834,838,839,841,842,863,867,868,869,891,1082,1083,1085,1107) )
AND ( ( wp_postmeta.meta_key = '_price'
AND CAST(wp_postmeta.meta_value AS SIGNED) != '' )
OR ( mt1.meta_key = '_price'
AND CAST(mt1.meta_value AS SIGNED) != '0' ) )
AND wp_posts.post_type = 'product'
AND (wp_posts.post_status = 'publish'
OR wp_posts.post_status = 'acf-disabled'
OR wp_posts.post_status = 'wc-partial-shipped'
OR wp_posts.post_status = 'private')
GROUP BY wp_posts.ID
ORDER BY wc_product_meta_lookup.total_sales DESC, wc_product_meta_lookup.product_id DESC
LIMIT 0, 35

And it takes more than 90 seconds to execute. I have no idea why. It is labelled as WP_Query->get_posts (Main Query). There are 2 more slow queries recorded, both of them take around 10 seconds and I believe they are being executed by the native WooCommerce filter widget, they are labelled as WC_Widget_Price_Filter->get_filtered_price.

I have no idea if those queries are wrong (being altered by a plugin or a theme), or if the database is somehow broken. I work with various WooCommerce stores that runs the same theme (Shopkeeper), basically same set of plugins, same server configuration and they run very smooth. They even have way more products and/or categories.

Any ideas? Thank you.

react native – Please assist with good advices here

What would I do in this instance? I have been a React native Developer for 2 years+ (Although I have been a software Developer using C#, Java , Python and PHP for close to 10 years also),done some side Hustle with it for a colleagues company and helped him support as well for React Native. Currently I have developed 2 apps and sent to playstore. Is this a good start to seek Remote jobs? Sharing the github Links as well as Playstore links on my Resume?

Bitcoin Native Script Language

I am intrigued by this Bitcoin Script Language, I want to learn how to program Bitcoin with it.

Any idea where I can, find some documentation to read/practice with ?

Windows VHDX native boot from scratch

I got Windows PE thumb drive and VHDX on GPT NTFS formatted HDD. This VHDX contains installed Win10 and partitioned as Microsoft recommends (system, msr, windows? recovery). What do I do wrong? How to setup the bootloader from WinPE in my case?

My actions are:
Boot form WinPE
CMD>bcdedit /v
There are no matching objects or the store is empty.
DISKPART>select vdisk file="C:VHDX.vhdx" 
DISKPART>attach vdisk
Diskpart successfully attached the virtual disk file.
DISKPART>uniqueid disk
Disk ID: {GUID}
CMD>select volume=5
CMD>assign letter=V
CMD>bcdboot f:windows /s V: /f UEFI
Boot files successfully created - I copied a boot files to the SYSTEM partition of my VHDX.
CMD>bcdedit /set {GUID} "(C:)VHDX.vhdx" 
An error occurred while attempting to reference the specified entry.
The system cannot find the file specified.
CMD>wpeutil reboot

After reboot I eject WinPE drive and see this screen.

Needed a versatile native writer for ongoing project!

I needed basically casino based native writer who is flexible to write anything like news, bingo, casino, poker, etc,
If you are a native writer and you feel like this job suits you, approach directly to below mail id:
pollsara144(at) with your sample work.
Thank you!