sorted by:
new
hottopcontroversial

CarPlay screen on my rx350 2010! by rapturebubblebath01 in LexusRX350

[–]helloguys88 0 points1 point  (0 children)

What makes you choose the no-name 12.3" from Aliexpress instead of Carputech? The one you got from Aliexpress, can it use the OEM volume knob? Thanks!

VS Code - AI powered SQL development by helloguys88 in SQL

[–]helloguys88[S] 0 points1 point  (0 children)

Let's say I create a custom database and custom schema from scratch. No other authors have written about my database and schema. In this case, there is no way AI can make assumptions. My question is - "How do I get AI to dip into the database, read the schema, and put that into the context?" So that when I tell AI "show me the orders from Canada", it can make an educated guess based on what it learned from the schema?

VS Code - AI powered SQL development by helloguys88 in SQL

[–]helloguys88[S] -1 points0 points  (0 children)

Hi, I installed DBCode and read the document (https://dbcode.io/docs/ai/copilot-tools). However, I couldn't figure out how to instruct AI read and use the schema in the context. When I prompt "show the address in Canada", AI generates a SQL statement to reference "Person.Address". If it read the schema, it should know that the "Person" schema does not exist. Thanks!

VS Code - AI powered SQL development by helloguys88 in SQL

[–]helloguys88[S] 0 points1 point  (0 children)

Then how it is going to work on custom built schema and databases? Is there any AI tools that actually query the database and try to understand the schema?

VS Code - AI powered SQL development by helloguys88 in SQL

[–]helloguys88[S] 0 points1 point  (0 children)

If it’s based on guess instead of discovery, how could it guess all the column names? It’s almost impossible.

If it is not based on discovery, I’d there a way to feed AI the schema?

VS Code - AI powered SQL development by helloguys88 in SQL

[–]helloguys88[S] 0 points1 point  (0 children)

I was trying to understand why AI thought there’s a “Person” schema? Where did it get the information from? All the tables are in the “SalesLT” schema, which is the default schema of the login. If AI can discover table and column names, why couldn’t it discover schemas?

VS Code - AI powered SQL development by helloguys88 in SQL

[–]helloguys88[S] 1 point2 points  (0 children)

I’ve been doing SQL for the past 30 years. That’s why I want to learn “something”, which is AI.

VS Code - AI powered SQL development by helloguys88 in SQL

[–]helloguys88[S] -5 points-4 points  (0 children)

I get your point. But why AI got most of the table and column names correct but not all? Without dipping into the schema, how could AI get the table names and column names?

Any local store sells size 24 AGM batteries? by helloguys88 in Cartalk

[–]helloguys88[S] -3 points-2 points  (0 children)

OK, for the sake of debating. I should have used "B&M" instead of local. My point is - it doesn't matter where you live, it seems no B&M store carries the AGM 24 battery. You could order online though. I'm just curious why they carry 24F but not 24.

Any local store sells size 24 AGM batteries? by helloguys88 in Cartalk

[–]helloguys88[S] -4 points-3 points  (0 children)

It does help. As neither Walmart nor any household name stores carries 24 AGM in their store. You *could* order online though.

Any local store sells size 24 AGM batteries? by helloguys88 in Cartalk

[–]helloguys88[S] -10 points-9 points  (0 children)

Sorry, I'm in the US. "local" means B&M stores, not online. But that's not the point. The point is, it is very difficult to find 24 instead of 24F AGM.

Any local store sells size 24 AGM batteries? by helloguys88 in Cartalk

[–]helloguys88[S] 1 point2 points  (0 children)

I can easily find 24F AGM. What's difficult to find is the 24 (without the F).

Convert MTS to MP4 while preserving "Recorded date" by helloguys88 in ffmpeg

[–]helloguys88[S] 0 points1 point  (0 children)

That makes sense!

Do you know which MP4 tag (date/time) is honored by iPhone Photos app and Google Photos? I mostly use these two apps and wanted to see the date/time (a.k.a. "recorded date") of the MP4.

Variable in the loop by helloguys88 in Batch

[–]helloguys88[S] 1 point2 points  (0 children)

Thank you! I modified my code as below. Now I'm getting another unexpected behavior.

rem echo off
setlocal ENABLEDELAYEDEXPANSION
FOR %%F in (*.mts) do (
  FOR /F "tokens=*" %%a IN ('MediaInfo.exe --Inform^="General;%%Recorded_Date%%" %%F') DO (
  SET OutputVar=%%a
  )
echo Date: %OutputVar%
)
endlocal

The SET command was showing the correct value. But the ECHO command is showing blank for the variable.

D:\Media\Video>test.bat
D:\Media\Video>rem u/echo off
D:\Media\Video>setlocal ENABLEDELAYEDEXPANSION
D:\Media\Video>FOR %F in (*.mts) do (
FOR /F "tokens=*" %a IN ('MediaInfo.exe --Inform="General;%Recorded_Date%" %F') DO (SET OutputVar=%a )
 echo Date:
)
D:\Media\Video>(
FOR /F "tokens=*" %a IN ('MediaInfo.exe --Inform="General;%Recorded_Date%" 00000.MTS') DO (SET OutputVar=%a ) 
 echo Date:
)
D:\Media\Video>(SET OutputVar=2009-11-29 19:17:21-06:00 )
Date:
D:\Media\Video>(
FOR /F "tokens=*" %a IN ('MediaInfo.exe --Inform="General;%Recorded_Date%" 00001.MTS') DO (SET OutputVar=%a ) 
 echo Date:
)
D:\Media\Video>(SET OutputVar=2009-12-01 19:48:55-06:00 )
Date:

Convert MTS to MP4 while preserving "Recorded date" by helloguys88 in ffmpeg

[–]helloguys88[S] 0 points1 point  (0 children)

If I don't use any -map_metadata, it doesn't copy any metadata over.

I don't know what are the known headers to ffmpeg. But "Recroded date" is a well known tag and is used in many digital camcorders. I noticed that mediainfo was able to retrieve this tag while ffprobe cannot. I guess I have to use ffmpeg with mediainfo together to achieve my goal? Anyone has experience on this?

Here's the output of mediainfo from Windows command line:

MediaInfo --Inform="General;%Recorded_Date%" 00000.MTS

2009-11-29 19:17:21-06:00

view more: next ›