-
Content Count
444 -
Joined
-
Last visited
Reputation Activity
-
xriko reacted to Zeus in [help] web dev
@xrikoI am in front a real keyboard so now I can help explain this. I will be writing my examples in SQL Server SQL, which is very similar to MySQL but a few small things are different.
I will start with the SONG table, because that's going to be your most important table. ID_SONG will be in every other table (or almost every other table) so the work we do here will make it easier later. When thinking about it, a song can belong to one artist and a song can belong to more than one CD or sometimes no CD at all. I would add two values, ID_DISK andID_ARTIST, so that I can link a song back to the CD or CDs it is on and the artist that recorded it. I would also think hard about how you want to represent a song performed live that is never officially released (either live distributed or only ever played live). Also if a SONG is on more than one release it should have more than one row in this table. That is okay.
CREATE TABLE SONG ( ID_SONG INT NOT NULL, TITLE_JP VARCHAR(300) NOT NULL, TITLE_ROMAJI VARCHAR(300) NOT NULL, ARRANGER VARCHAR(100) NULL, WRITER VARCHAR(100) NULL, ID_DISK INT NULL, ID_ARTIST INT NOT NULL )
For the ARTIST table, you can add other fields that you want to track like years active or the label they are signed to.
CREATE TABLE ARTIST ( ID_ARTIST INT NOT NULL IDENTITY(1,1), ARTIST_NAME_JP VARCHAR(300) NOT NULL, ARTIST_NAME_ROMAJI VARCHAR(300) NOT NULL )
For the CD table, you want to add another column so that you can join back to the band that released the CD and any other columns that you want. I would also heavily advise against storing images in your database and find another way to represent them, because that can cause your database to get big really fast, but if you still want to use the special LONGBLOB data type. Also, instead of maintaining a list of tracks that belong to an album in your CD table, store the ID_SONG value next to a new value called TRACKLIST_ORDER, so you can reuse the data in the other table and also keep the order that it was released in the album. It's up to you how you want to store different versions of the same release.
CREATE TABLE CD ( ID_DISK INT NOT NULL, ID_ARTIST INT NOT NULL, FRONT_COVER LONGBLOB, TITLE VARCHAR(300) NOT NULL, TITLE_ROMAJI VARCHAR(300) NOT NULL, RELEASE_DATE DATE, RELEASE_CODE VARCHAR(100), PRICE NUMERIC(3,2), ID_SONG INT NOT NULL, TRACKLIST_ORDER INT NOT NULL, EXTRAS VARCHAR(1000) )
The LIVE table can stay exactly as it is, except I would change SET_LIST to ID_SETLIST, and BANDS to SUPPORTING_BANDS. ID_SETLIST is a new column that you will use to join into another table (I will explain why shortly) and SUPPORTING_BANDS has the same values as the column ID_ARTIST in your ARTIST table. This means that a live that has two supporting bands before the main act will have two rows in this table. That is okay.
CREATE TABLE LIVE ( ID_LIVE INT NOT NULL, DATE DATE, VENUE VARCHAR(100), TOUR_NAME VARCHAR(100), TOUR_INFO VARCHAR(500), SUPPORTING_BANDS INT, DOORS_OPEN DATETIME, SHOW_STARTS DATETIME, PRICE_RESERVED NUMERIC(3,2), PRICE_DOOR NUMERIC(3,2), ID_SETLIST INT NOT NULL, ) Now all you need is a SET LIST table that has the ID of the set list, the ID of the band, the IDs of all the songs played, and the order they are played in. You want another table for SET_LIST because you do not want to store the set list as a string. It will be a lot of work to get the answers back later, especially if you want to look at all the concerts for a particular band. You can get back all the other information such as dates and albums by joining the tables that you need together, so there's no reason to store anything else here.
CREATE TABLE SET_LIST ( ID_SETLIST INT NOT NULL, ID_ARTIST INT NOT NULL, ID_SONG INT NOT NULL, TRACK_ORDER INT NOT NULL )
I hope all of this made sense.
-
xriko reacted to Peace Heavy mk II in [help] web dev
I'm not a database architect myself, but it seems like your set_list property, as well as your tracklist within the CD table, can just be a list of id_songs. Having a 4th table would be over complicating things.
-
-
xriko reacted to Axius in Sadie - A holy terrors [Scans]
01. a holy terrors
02. Barking the enemy and 03. Rock and rock stinky people
Back art
-
xriko reacted to kenecchi in Hello + Plug for VK show
Hi all, I wasn't aware that there is such an elaborate forum for J-rock/VK stuff! Glad to be here!
I'm Ken; I live in rural Ibaraki, Japan. I've been a fan of visual rock since I was in high school (early 00s!)
These days I work all the time but I occasionally find time to go to shows or play as a support bassist for local bands.
Recently I'm working on a YouTube show about late 90s/early 00s VK. In addition to doing reviews,
I would like to analyze various tropes and aspects of the genre . It's still a little rough but I'd appreciate any kind of
feedback or support. Thanks!
episode 1
episode 2
-
-
-
-
xriko reacted to WhirlingBlack in What about DIR EN GREY - CONCEIVED SORROW(DEMO Ver.)
I remember sometime before the album came out, roughly late 2006 I would say, that there had been a of leak of 4-5 songs in pre-production quality through some form of security breach in their internal servers. Apparently only a small handful of people got their hands on it though, and I never did, so I can't say for certain and it was over ten years ago, but those are my recollections of what I heard at the time. I know that @Furik was around at Batsu at the same time so maybe he remembers something about it too?
-
xriko reacted to Seelentau in What about DIR EN GREY - CONCEIVED SORROW(DEMO Ver.)
It's a pre-production version. I don't know where it comes from, though.
I also heard about the alleged tentative names for the TMOAB tracks, but I don't know if they are real...
-
xriko reacted to Axius in Your Most played Vk songs
God danm i listen to too much Awoi >.<
Awoi -レクイエム (Requiem)
Awoi - Kotodama
Awoi - センチメンタル・ラストシーン (Sentimental・last scene)
Awoi - Blind
Razor - Liquid Vain
Mamireta - Ojamashimasu
Mejibray - SE #1 and 2 the (whole thing)
Tensai - センパイの彼女
Signal - Apocalypse
Signal - Glow Back Over Scars
Lustknot - Sore wa namonaki doushi ni sasagutatta hitotsu no anthem
Awoi - 哀しい歌
Razor - DNA
Born - 黒蟻
Born - gurou
Born - GAGA SPARKING
Lustknot - Angelus
Lustknot - Living in this moment
Killaneth - 孤独-Einsamkeit-
Codomo Dragon - Wolfman
Codomo Dragon - NEPENTHES.
Dio distraught overlord - Byakuya ni Moyuru Hana
Dio distraught overlord - Garasu no umi
-
xriko reacted to Seelentau in Your last music-related buy!
Hopefully this arrives soon~ (although I already own the upper two)
Also, on Saturday, a tape player will arrive that can digitalise those tapes. Wanna see if they sound any different
-
xriko reacted to sakuran in Your last music-related buy!
Bought some CDs and a photoset from old gossip, and it turned out Hiro's photo was signed.
-
xriko reacted to Mamo in Current pictures of old vk guys
Saw this awhile back and never got around to posting it. Kyotaro (√eight, Black:list) and the rest of the members of his first band VolarK reunited after 13 years:
-
xriko got a reaction from Luca in Memorable Millenial Kei Vocalists
オトギ (otogi)
active : 2003 to 2014
Notables band : アヲイ (awoi)
----------------------------------------------------------------
mar
active: 2004 to 2011, retired
Notables band : It, As If In The Darkness
----------------------------------------------
緋絽 (hiro)
active : 2002 to now
Notables band: Visage, gossip, ヴァリル
-----------------------------
龍司 (ryuuji)
active : 2008/2011, retired
Notable band : Re:dis
-
xriko got a reaction from zaa_zaa in Memorable Millenial Kei Vocalists
オトギ (otogi)
active : 2003 to 2014
Notables band : アヲイ (awoi)
----------------------------------------------------------------
mar
active: 2004 to 2011, retired
Notables band : It, As If In The Darkness
----------------------------------------------
緋絽 (hiro)
active : 2002 to now
Notables band: Visage, gossip, ヴァリル
-----------------------------
龍司 (ryuuji)
active : 2008/2011, retired
Notable band : Re:dis
-
xriko reacted to Pretsy in Copy/Paste: When Imitation is the Most Sincere Form of Flattery
2005
2004
Also:
(Pay special attention to the bridge vocal melody)
(no studio version but pay attention to the first verse melody - it's slowed down a bit but you will recognize it)
-
xriko got a reaction from plastic_rainbow in Memorable Millenial Kei Vocalists
オトギ (otogi)
active : 2003 to 2014
Notables band : アヲイ (awoi)
----------------------------------------------------------------
mar
active: 2004 to 2011, retired
Notables band : It, As If In The Darkness
----------------------------------------------
緋絽 (hiro)
active : 2002 to now
Notables band: Visage, gossip, ヴァリル
-----------------------------
龍司 (ryuuji)
active : 2008/2011, retired
Notable band : Re:dis
-
xriko got a reaction from Zeus in Memorable Millenial Kei Vocalists
オトギ (otogi)
active : 2003 to 2014
Notables band : アヲイ (awoi)
----------------------------------------------------------------
mar
active: 2004 to 2011, retired
Notables band : It, As If In The Darkness
----------------------------------------------
緋絽 (hiro)
active : 2002 to now
Notables band: Visage, gossip, ヴァリル
-----------------------------
龍司 (ryuuji)
active : 2008/2011, retired
Notable band : Re:dis
-
xriko reacted to Willen in I do not eat frog legs
Thank you xriko!
I get your point but my presentation do not mention the fact that I'm always listening to new vk bands, especially since 2 years. I didn't mention a lot of indie bands because most of my favorites had a short career and disbanded, and the new ones I listen to are too recent for me to mention them in a presentation topic! Recently, I'm very interested in some bands like Zombie, DADAROMA, Purple Stone, Pentagon, Kuroyuri to Kage and REIGN. I'm always excited to discover new bands, or the oldest ones I have never listened to. I've always been very oshare kei-oriented but since 2 or 3 years I'm very interested in darker bands cause I'm looking for heavier rock!
-
-
xriko reacted to Messenger84 in The RarezHut Megathread: the largest internationally-based Visual Kei megastore
Time arrived, Thanks Guys!
-
xriko reacted to Seiji in Your last music-related buy!
Rarezhut package, including:
GUNIW TOOLS - FICKLE BOON
Cross Cradle - 聖域
gossip - Conservative race
MALICE MIZER - Voyage sans retour
nightmare x baroque flyer
武井誠(Takei Makoto) - はからず mo ワンモア・キッス
AlteMissioN - 巡礼
BLACK CAT - 碧色のリザレクション
Dali - -Dali復活ワンマン公演「色彩感覚コントラスト」at 2010.1.11 心斎橋FANJ-twice- SPECIAL DVD
JILS - PASSING e.p.
Rayarch - MAZE
天照(Amaterasu) - 遼かなる大地への讃歌
MaitoreiA - ユグドラシル
MIRAGE - 流星 (Ryuusei)
SCREW - DEEP SIX(Type A)
Guniw Tools - VVDADA
SADS - FILM COLLECTOR
V.A. - Shock Edge 2004
Vettic - bottom
V.A. - Anamorphosis
V.A. - THE BEST OF reveil [deux]
V.A. - Art Sensation
JIVE - Swing&Spice
Layarch - be disorder
V.A. - Cry-Max Pleasure~Welcome to the Front Line Party~
And also:
CREATURE CREATURE - Death is a flower and EXORCISING ORPHEUS
and Marco's Kindai Black.
Now I'm broke and happy.
-
xriko got a reaction from nattliga_toner in Your last music-related buy!
since few week i'm in a 90's mood.
se.re.nade.. sound very nice.
-
xriko got a reaction from IGM_Oficial in Your last music-related buy!
Those 2 V.A are lovely.
Well played !
.flac rip ?