Articles

Today’s Highlights 📰 Indonesias BP Taskin targets urban housing gaps in poverty reduction - ANTARA News This initiative could stimulate the construction sector and create jobs, while also improving living standards for urban residents. 📰 Indonesia Prepares for Delivery of Rafale Fighter Jets in Early 2026 - Jakarta Globe The purchase of Rafale fighter jets represents a significant investment in defense and could lead to increased cooperation with the jet’s manufacturer, Dassault Aviation. 📰 Indonesia, Iraq explore stronger oil and gas cooperation - ANTARA News Increased cooperation could lead to significant investments in the energy sector and create new revenue streams for both nations. 📰 BMKG Warns Three Cyclones Surround Indonesia, Reports to President Prabowo - Website Resmi Polri Severe weather events can disrupt business operations, supply chains, and infrastructure, leading to economic losses. 📰 Indonesia Enters China’s Durian Market with First Direct Frozen Export - MetroTVNews.com This move could significantly increase revenue for Indonesian durian farmers and processors, while also strengthening trade ties with China. 📰 Indonesia ships first frozen durian export to China - ANTARA News This export initiative could lead to increased investment in durian farming and processing infrastructure in Indonesia. 📰 Indonesia Resumes Spice Exports to US After Radiation Scare - Tempo.co English The resumption of spice exports will help Indonesian spice producers regain market share and revenue in the US market. Economy/Business 📰 Indonesia, Iraq explore stronger oil and gas cooperation - ANTARA News Source: news.google.com/…/CBMimAFBVV95cUxNWWRxQm9waUtSajZIR… ...

Today’s Highlights 📰 Indonesia Holds Second Place in SEA Games 2025 Medal Standings with 43 Golds - Website Resmi Polri Prestige for the country and potential economic benefits from sports-related activities. 📰 Indonesia climbs to second in SEA Games medal standings - The Jakarta Post This could lead to increased national pride and potentially boost the sports economy. 📰 Thailand Pulls Away as Indonesia Overtakes Vietnam at SEA Games 2025 - Jakarta Globe The games can impact national morale and potentially influence investment in sports programs. 📰 Indonesia banks on resource downstreaming for economic ascension - ANTARA News This strategy could increase the value of exports and create more jobs. 📰 Indonesia Condemns Bondi Beach Shooting in Australia - MetroTVNews.com This could affect diplomatic relations and tourism between the two countries. 📰 Tapping the Recreational Economy to Fuel Indonesia’s Growth - Tempo.co English This could lead to increased tourism revenue and job creation in the leisure sector. 📰 Unlocking the full value of green power in Indonesia - The Jakarta Post This could attract investment in renewable energy and reduce reliance on fossil fuels. Economy/Business 📰 Indonesia banks on resource downstreaming for economic ascension - ANTARA News Source: news.google.com/…/CBMipAFBVV95cUxNT1lKOFdsblRXWkZ0U… ...

Today’s Highlights 📰 SEA Games 2025: Indonesia Rises to Second in Medal Standings - Website Resmi Polri Major sporting success boosts national morale, which can indirectly influence domestic consumer sentiment and national brand visibility. It may also signal increased future government investment in sports-related infrastructure and development. 📰 Indonesia rises to second at SEA Games as Prabowo praises athletes - ANTARA News Government praise and national enthusiasm resulting from sports victories can translate into favorable public sentiment. This environment often encourages corporate sponsorship and investment in related industries and infrastructure development. 📰 Indonesia Adds Silver and Bronze in Swimming at SEA Games 2025 - RRI.co.id Strong performances in international events like the SEA Games increase the marketability of national athletes and sports programs. This drives commercial opportunities for endorsements, specialized training facilities, and sporting goods sales. 📰 Indonesia, Russia deepen industrial ties as trade and investment grow - ANTARA News Increased trade and investment flows between Indonesia and Russia create new market access and supply chain diversification opportunities for Indonesian industries. Businesses should monitor new bilateral agreements that could affect tariffs or investment incentives. 📰 Analyst urges cultural focus in Indonesias police reform - ANTARA News Successful police reform and improved governance reduce regulatory uncertainty and security risks for both foreign and domestic companies. A strong rule of law environment is a prerequisite for long-term business confidence and attracting FDI. 📰 Quantum geopolitics and Indonesia’s grand strategy 2025-2045 - The Jakarta Post Indonesia’s grand strategy provides the framework for future economic policy, infrastructure planning, and technological development over the next two decades. Businesses should study this strategy to understand future regulatory landscapes and investment priorities. 📰 Indonesia Sets $315 Billion Export Target for 2026, Eyes $406 Billion by 2029 - Jakarta Globe These significant export targets signal areas of intense government support and policy incentives for trade-oriented industries, including commodities, manufacturing, and value-added processing. Businesses operating in these sectors can anticipate favorable regulatory environments and infrastructure focus. Economy/Business 📰 Indonesia, Russia deepen industrial ties as trade and investment grow - ANTARA News Source: news.google.com/…/CBMiqgFBVV95cUxQbkhKMmhqYmQ2RDdKW… ...

Objective and Background In BigQuery, we often save historical data by appending suffixes like _YYYYMMDD to table names. Over time, this can lead to an accumulation of many versions of data that need to be deleted. However, the GCP console only allows deletion of one table at a time, and the bq command does not support wildcard deletions. To address this, we use the following approach. One-liner Replace <Project_name>, <Dataset_Name>, and <Table_Name_Pattern_To_Delete> in the command below. bq query --project_id=<Project_name> --use_legacy_sql=false --format=csv --max_rows=1000 "SELECT table_id FROM \`<Product_Name>.<Dataset_Name>.__TABLES__\` WHERE table_id LIKE '%<Table_Name_Pattern_To_Delete>%'" | tail -n +2 | xargs -I {} bq rm -f -t <Product_Name>:<Dataset_Name>.{} Additional Notes ‐ It is advisable to verify the target tables before executing the deletion. Use the following command to check: ...

In PostgreSQL, always use lowercase for object names (table names, column names) Reason In the database, uppercase and lowercase are distinguished when registering object names. In SQL, when enclosed in double quotes (" “), the exact string is used, but if not enclosed, the name is converted to lowercase (apparently). As a result, mismatches may occur. testdb=> \d iris Table "public.iris" Column | Type | Modifiers ---------------+-----------------------+----------- Id | integer | not null SepalLengthCm | numeric(15,2) | SepalWidthCm | numeric(15,2) | PetalLengthCm | numeric(15,2) | PetalWidthCm | numeric(15,2) | Species | character varying(20) | Indexes: "iris_pkey" PRIMARY KEY, btree ("Id") testdb=> select * from iris where SepalLengthCm > 5.0; --<--- NG ERROR: column "sepallengthcm" does not exist LINE 1: select * from iris where SepalLengthCm > 5.0; ^ HINT: Perhaps you meant to reference the column "iris.SepalLengthCm". testdb=> select * from iris where "iris.SepalLengthCm" > 5.0; --<--- NG ERROR: column "iris.SepalLengthCm" does not exist LINE 1: select * from iris where "iris.SepalLengthCm" > 5.0; ^ testdb=> select * from iris where "SepalLengthCm" > 5.0; --<--- OK testdb=> select * from iris where iris."SepalLengthCm" > 5.0; --<--- OK my previous blog post https://pumpkinpie-tea.blogspot.com/2016/06/postgresql.html

verb - kata kerja - 動詞 # Bahasa Indonesia Contoh kalimat English Japanese 5 percaya Saya percaya begitu. believe 信じる 4 bilang Dia bilang bahwa dia sudah pernah pergi ke Jerman. said 言った 3 berkata Dia berkata bahwa dia sudah pernah pergi ke Jerman. said 言った 2 nikmati (menikmati) Selamat menikmati liburan! enjoy 楽しむ 1 tahu Saya tidak tahu. know 知る

About This Blog This blog is a migration from my previous site. The previous URL was https://pumpkinpie-tea.blogspot.com/ Purpose of the Migration There were several reasons for migrating this site, primarily to experiment with the following technical aspects: Setting up a website with a custom domain Configuring and optimizing Google Analytics (GA) and SEO Building a website using a static site generator (Hugo) Hosting the site using Firebase Hosting It serves as a personal notepad, where I document my thoughts, experiments, and learning process. It’s a space for me to organize ideas and explore new technologies.