Soft Cakes: 2019

2019年9月19日

利用photogrammetry工具軟體將照片轉為3D model (Photo to 3D model)

Photogrammetry (攝影測量法)是一種利用被攝物體影像來重建物體空間位置和三維形狀的技術。
wiki
http://en.wikipedia.org/wiki/Photogrammetry

Photogrammetry 簡介與工具軟體連結介紹

Quixel - Megascans, Bridge and Mixer help you shape the future of 3D graphics.
官網: https://quixel.com/

介紹 Photoscan 的文章...
Getting Started with Photogrammetry: Photoscan

介紹 123D Catch 的文章...
Getting Started with Photogrammetry: 123D Catch

VisualSFM:
VisualSFM : A Visual Structure from Motion System(含 VisualSFM 軟體下載連結)
VisualSFM, Tool for creating 3D reconstruction from photos
使用流程介紹...
Open Source Photogrammetry: Ditching 123D Catch (Use VisualSFM...)

3DF Zephyr

COLMAP ( Open Source )

2019年9月18日

SQL tip: SQL查詢時，多筆中如何只取最新的1筆資料(利用 left join 寫法)

=======================================================
SQL 查詢時，若特定欄位值有兩筆以上，如何只取最新的1筆資料
=======================================================

select * form Table1
left join Table2
on Table1.[欄位A]=Table2.[欄位A]
and
Table2.[時間欄位] = (select max([時間欄位]) from Table2 where [欄位A]=Table1.[欄位A])

2019年9月17日

3D Programming Resource (3D 程式設計資源) Part 2

這一篇內容大部份與3D Model (特別是人物模組)程式庫有關...

============================
3D Engine 程式庫
============================
Panda3D

Render Pipeline with Physically Based Shading for Panda3D

lyost/d3d12_framework

A free game engine - Amazon Lumberyard

Psychosynth ( arximboldi psychosynth GitHub code)

============================
3D Model 程式庫與範例程式
============================

Open3mod, Open 3D Model Viewer

Powerful 3D Viewer and basic editor for 40+ file formats, including OBJ, 3DS, BLEND, STL (more info), FBX, DXF, LWO, LWS, MD5, MD3, MD2, NDO, X, IFC and Collada. One of only a few independent FBX Viewers.

Alexander Gessler GitHub code - 3D Graphics, Game Programming. Used to be a freelancer, now at @google Munich.

Yuusha Modding Blog - Digital yuusha modding archives. Some AG3 clothes editor talk, but nothing about AG3 in general.

Floyd Project

enimaroah SB3Utility GitHub code
HF-Alamar SB3Utility GitHub code

============================
GUI 程式庫
============================
GiGi - a GUI library for OpenGL

MyGUI
官網:
http://mygui.info/

GitHub code

介紹文章...
MyGUI 中文MYGUI在win7下的中文完美输入及其显示
MyGUI中文完美解决方案

CEGUI - a GUI C++ Library
CEGUI筆記
SpringEmbedders - a ceGUI sample

SpringEmbedders is a graph-visualization program based on the paper Non-Euclidean Spring Embedders, by Stephen G. Kobourov and Kevin Wampler, in INFOVIS 2004 pages 207-214.

=======================================
對應知名3D建模軟體之模組匯入/匯出程式庫
=======================================

NifTools is an open source project creating tools—such as an editor, C++ and Python libraries, and import/export plugins for Maya, 3ds Max, and Blender.

NifTools 資源網站: